Full Time - Data Engineer - S4CH
About the position 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. 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. Responsibilities • Advanced SQL Development: Write and optimize complex SQL queries and dbt models for data transformation and analysis within Snowflake. • DBT Model Development: Build, test, and maintain dbt models that convert raw data into actionable insights. • ETL/ELT Pipeline Management: Design and manage efficient pipelines using dbt, OpenFlow, and Python to process and deliver data across systems. • SQL Performance Tuning: Optimize query performance, clustering, and cost efficiency in Snowflake • Data Quality Assurance: Ensure that transformed data meets accuracy and consistency standards through dbt testing and validation frameworks. • Collaboration: Work closely with data engineers, analysts, and architecture leads to translate data requirements into scalable transformations • Data Documentation: Maintain clear documentation for dbt models, data flows, and dependencies for ongoing visibility and reuse • Version Control: Manage dbt and Python projects in Git, following clean, modular, and testable development practices • Automation Support: Partner with automation engineers to enhance data ingestion and transformation workflows through OpenFlow 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. Nice-to-haves • 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. Benefits • Medical, Dental and Vision Insurance: Comprehensive health coverage to ensure you and your family stay healthy. • Life and Disability Coverage: Financial protection for you and your loved ones in case of unforeseen circumstances. • Retirement Savings Plan: Plan for your future with our retirement savings options. • Commuter and Transit Benefits: Assistance with your daily commute to make your journey to work easier. • Employee Assistance Program (EAP): Access to confidential support and resources for personal and work-related issues. • Employee Discount Program: Enjoy discounts on various products and services as a valued member of our team. • Provider Incentive Compensation Program: Quality & Productivity. • Professional License, Certification and DEA Fees Reimbursement. Apply tot his job