Senior Data Engineer

Senior Data Engineer with expertise in data warehousing, ETL pipeline development, and Snowflake, leading data infrastructure modernization in healthcare data environment.

Location: United States

Responsibilities

• Design, build, and maintain ETL and reverse-ETL pipelines between Snowflake, Azure Data Factory, and legacy SQL Server systems.
• Develop and optimize Snowflake data warehouse models, ensuring performance, reliability, and high availability.
• Implement and maintain row-level and column-level security policies to protect sensitive healthcare data.
• Partner with the existing SQL Server Data Engineering team to plan and execute the migration of legacy ETL processes and warehouse models to Snowflake and the cloud.
• Build and maintain data transformations using dbt.
• Monitor pipeline health, troubleshoot failures, and ensure uptime and data integrity across all data flows.
• Mentor peers and contribute to engineering best practices, code reviews, and documentation.
• Learn and adopt Sigma as the organization’s BI and reporting tool.

Requirements

• Bachelor’s degree in Computer Science, Data Engineering, or related field, or equivalent experience.
• 10+ years of experience in data engineering, ETL development, and data warehouse modeling.
• Proven hands-on experience with Snowflake, including architecture, optimization, and security.
• Strong proficiency in SQL and Python.
• Experience with at least one major BI/visualization platform (e.g., Power BI, Tableau, Looker, Sigma).
• Experience with dbt and Azure Data Factory.
• Prior experience working with healthcare data, including familiarity with data sensitivity, HIPAA, and security best practices.
• Experience implementing row-level and/or column-level security in a data warehouse environment.
• Strong self-management skills with the ability to work independently in a fully remote environment.