Snowflake Data Engineer

Our Addison, TX-based client is seeking a Data Engineer to build and maintain data pipelines for a cloud-native analytics platform on Azure and Snowflake. Responsibilities include data ingestion, transformation using Bronze/Silver/Gold medallion architecture, and production reliability. The role is initially fully onsite, with potential for two remote days per week after a few months, and is available as a six-month contract-to-hire or direct hire.

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

WHAT YOU’LL DO:

• Build and maintain ELT pipelines in Azure Data Factory (ADF) ingesting data disparate data sources into Azure Data Lake Storage Gen
  2.
• 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.

WHAT YOU’LL BRING:

• 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 Dev Ops/CI/CD for pipeline deployment.