Senior Data Engineer

📋 Description

• Design, construct, and sustain ETL and reverse-ETL pipelines connecting Snowflake, Azure Data Factory, and legacy SQL Server systems.

• Create and enhance Snowflake data warehouse models, ensuring optimal performance, dependability, and high availability.

• Establish and uphold row-level and column-level security measures to safeguard sensitive healthcare information.

• Collaborate with the existing SQL Server Data Engineering team to strategize and implement the transition of legacy ETL processes and warehouse models to Snowflake and the cloud.

• Develop and manage data transformations utilizing dbt.

• Oversee pipeline health, resolve failures, and ensure uptime and data integrity across all data flows.

• Guide colleagues and contribute to engineering best practices, code assessments, and documentation.

• Acquire knowledge and adopt Sigma as the organization’s business intelligence and reporting tool.

⛳️ Requirements

• Bachelor’s degree in Computer Science, Data Engineering, or a related discipline, or equivalent experience.

• Over 10 years of experience in data engineering, ETL development, and data warehouse modeling.

• Demonstrated practical experience with Snowflake, encompassing architecture, optimization, and security.

• Strong command of SQL and Python.

• Familiarity with at least one major BI/visualization platform (e.g., Power BI, Tableau, Looker, Sigma).

• Experience with dbt and Azure Data Factory.

• Previous experience with healthcare data, including understanding of data sensitivity, HIPAA, and security best practices.

• Experience in implementing row-level and/or column-level security in a data warehouse context.

• Excellent self-management abilities with the capacity to work independently in a fully remote setting.

🏝️ Benefits

• Health care claim data management

• Ownership and collaboration

• Mentorship opportunities

• Hands-on technical role