Lead Snowflake Data Engineer

We are looking for a Lead Snowflake Data Engineer to lead the design, security, and development of an enterprise Snowflake platform. This hands-on role includes building production dbt models, establishing engineering standards, and mentoring the team.

Key Responsibilities

• Build Silver and Gold dbt models that transform source data into reliable datasets for reporting and analytics.
• Own Snowflake platform architecture, environment design, and role hierarchies.
• Protect sensitive data through RBAC, masking policies, and row access policies.
• Manage Git and CI/CD workflows, including automated testing and controlled production releases.
• Review code, mentor engineers, and optimize Snowflake performance and costs.

Required Qualifications

• 10 years in data engineering or data warehousing, including 3 years building and running dbt on Snowflake in production.
• Strong SQL and dbt experience with incremental models, snapshots, macros, testing, and documentation.
• Experience with dimensional and medallion modeling, including line-item corrections and adjustments.
• Hands-on Snowflake security experience and knowledge of Streams and Tasks, Dynamic Tables, Time Travel, cloning, and warehouse sizing.
• Experience owning production releases, conducting code reviews, and providing technical leadership.
• Bachelor's degree in a relevant field or equivalent practical experience.

Preferred Qualifications

• Healthcare claims, revenue-cycle data, X12/EDI, or experience with regulated data.
• Azure Data Factory, ADLS Gen2, Azure DevOps, Python, or infrastructure as code.
• Snowflake cost governance, FinOps, or SnowPro certification.