Full Time - Data Engineer - S4CH

About Us
 

We’re a data-driven healthcare organization modernizing our analytics platform to power value-based care. Our team is transitioning from SQL Server to Snowflake as our cloud data warehouse and implementing dbt, Python, and OpenFlowto build reliable, automated data pipelines.
 

You’ll join a collaborative, high-skill data team that values maintainability, clarity, and thoughtful design — working alongside engineers who specialize in automation, SQL Server administration, and data architecture.

Position Overview
 

• We’re seeking an experienced Data Engineer with strong SQL, dbt, and Python skills to design, build, and maintain our data transformation and analytics pipelines in Snowflake.
• The ideal candidate has hands-on experience with modern ELT tools, data modeling, and cloud-based platforms — and brings a mindset of automation, testing, and documentation to every project.
• You’ll collaborate closely with our data architects and integration engineers to ensure data from OpenFlow pipelines is transformed into trusted, analytics-ready models for reporting and advanced analytics.

Job Type: Full-Time

Location: Remote

Salary: 100,000 - 151,000

Sign On Bonus: $1500

Reports To: AVP Data and Software Engineering

Essential Duties and Responsibilities:

• Knowledge of database coding and tables; as well as general database management
• Understanding of client management, support, and communicating progress and timelines accordingly
• Organizes and/or leads Informatics projects in the implementation/use of new data warehouse tools and systems
• Ability to train new hires; as well as lead in training of new client staff members
• Understanding data schema and the analysis of database performance and accuracy
• Understanding of ETL tools, OLAP design, and data quality processes
• Knowledge of Business Intelligence life cycle: planning, design, development, validation, deployment, documentation, and ongoing support
• Working knowledge of electronic medical records software (eCW, Nextgen, etc) and the backend storage of that data
• Ability to generate effective probability modeling and statistics as it pertains to healthcare outcomes and financial risks
• Ability to manage sometimes lengthy and complicated projects from throughout the life cycle and meet the deadlines associated with these projects
• Development, maintenance, technical support of various reports and dashboards
• Knowledge of Microsoft® SQL including coding language, creation of tables, stored procedures, and query design
• Fundamental understanding of outpatient healthcare workflows
• Knowledge of relational database concepts and flat/formatted file processing.
• Possesses strong commitment to data validation processes in order to ensure accuracy of reporting (internal quality control)
• Possesses a firm grasp of patient confidentiality and system security practices to prevent HIPAA and other security violations.
• Knowledge of IBM Cognos® or other database reporting software such as SAS, SPSS, and Crystal Reports
• Ability to meet the needs of other members of the Informatics department to maximize efficiency and minimize complexity of end-user products
   

Requirements:

• Education: Bachelor's Degree
• Proven experience as a dbt Developer or in a similar Data Engineer role.
• Expert-level SQL skills — capable of writing, tuning, and debugging complex queries across large datasets.
• Strong experience with Snowflake or comparable data warehouse technologies (BigQuery, Redshift, etc.).
• Proficiency in Python for scripting, automation, or data manipulation.
• Solid understanding of data warehousing concepts, modeling, and ELT workflows.
• Familiarity with Git or other version control systems.
• Experience working with cloud-based platforms such as AWS, GCP, or Azure.

Preferred:

• Experience working with OpenFlow or similar orchestration/ETL systems (Airflow, SSIS, etc.).
• Familiarity with healthcare or clinical data models.
• Experience with Snowflake Cortex, or other LLM platforms.
• Exposure to CI/CD pipelines or Infrastructure as Code concepts.<