Snowflake Data Engineer

• Build and maintain ELT pipelines in Azure Data Factory (ADF) ingesting data disparate data sources into Azure Data Lake Storage Gen2.
• Implement Snowflake Bronze Silver Gold layer transformations: incremental loads, SCD Type 2, and fact/dimension modeling aligned to business requirements.
• Write and optimize T-SQL against SQL Server for performant source extraction without disrupting operational workloads.
• Maintain pipeline monitoring, alerting, and error recovery - pipelines support 24/7 revenue operations and uptime matters.
• Handle PHI/PII data in full compliance with HIPAA: field masking, access controls, and audit-ready data handling at every layer.
• Collaborate with our AI/ML engineer to ensure Silver-layer data structures are ML-ready and consistently documented.

• Bachelor’s degree in Computer Science, Information Systems, or equivalent experience.
• 5 8+ years of data engineering experience, including 2+ years with Azure and hands-on production experience with Azure Data Factory, ADLS Gen2, and Snowflake.
• Strong SQL Server/T-SQL skills, including complex queries, CTEs, window functions, and SCD Type 2, plus experience with Snowflake tasks, streams, incremental loading, query optimization, and RBAC.
• Strong understanding of ETL/ELT patterns, idempotency, error handling, and working with regulated data (HIPAA, PCI, or similar).
• Preferred: Healthcare data experience, Python for data transformation and pipeline testing, dbt for Silver/Gold layer management, and Azure DevOps/CI/CD for pipeline deployment.

COMP: Up to $150K, dependent on candidate’s experience WHAT OUR CLIENT OFFERS:

• Competitive salary with performance-based bonus opportunities
• Comprehensive health, dental, and vision insurance
• 401(k) plan with 3% non-discretionary company contribution
• Paid holidays, PTO, and professional development support
• A collaborative and growth-oriented work environment