Key skills
SQLAIETLELTBITableauSnowflakeBigQuerydbtGCPSQL ServerCollaboration
About this role
WellSky is a company that values independent thinking and collaboration, and they are seeking a Senior Data Engineer. The role involves designing, building, and maintaining scalable data pipelines and infrastructure to support data-driven decision-making processes, while collaborating with various stakeholders to enhance data quality and accessibility.
Responsibilities:
- Create, develop, maintain, and leverage data pipelines, data models, reporting, and dashboards to solve business problems or assigned tasks in coordination with multiple teams
- Develop and maintain data solutions to enable new or existing solutions and BI development for the data warehouse and data visualization solutions
- Enhance and document workflows for complex data-related challenges by identifying patterns, trends, and anomalies in the data, and find ways to optimize data processing and storage to promote data quality through automation
- Develop understanding of different WellSky solutions and become a subject matter expertise in the healthcare domain
- Identify opportunities in code reviews and contribute to the development of best practices and coding standards
- Adhere to WellSky core values, ensure PHI data security, and adapt to changing BI technologies
- Leverage AI tools and platforms as an integral part of daily responsibilities to enhance decision-making, streamline workflows, and drive data-informed outcomes
- Perform other job duties as assigned
Requirements:
- Bachelor's degree or relevant work experience
- 4-6 years of relevant work experience
- Strong SQL skills with hands-on experience developing and supporting data pipelines and data warehouse solutions
- Experience with SQL Server data integration and ETL development (including SSIS or equivalent)
- Experience with cloud-based data platforms and services, preferably within GCP environments
- Experience with Snowflake data warehouse development and management
- Experience with DBT for ELT/ETL processes, data modeling, testing, and documentation
- GCP expertise, especially with Cloud SQL, BigQuery, and DataStream
- Experience with data replication tools such as HVR (or similar CDC/replication technologies)
- Experience supporting BI/reporting environments such as Tableau through well-modeled, performant datasets
- Healthcare industry experience