Sr. Data Engineer

WellSky Corporation is dedicated to creating an authentic culture through independent thinking and collaboration. The Sr Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and infrastructure to support data-driven decision-making processes, 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