Data Engineer - Snowflake
Role : Data Engineer – SnowflakeLocation : Addison, TX Interview Mode: On-SiteDuration : 03 month (Contract to Hire)Description:Building a cloud-native analytics platform on Azure and Snowflake to support our business operations. The data engineer owns the pipelines that make it run — ingesting data from our core source systems, transforming it through a Bronze/Silver/Gold medallion architecture, and keeping it reliable in production. This is hands-on engineering work: you will build, not just advise.What You'll OwnBuild and maintain ELT pipelines in Azure Data Factory (ADF) ingesting data disparate data sources into Azure Data Lake Storage Gen2Implement Snowflake Bronze → Silver → Gold layer transformations: incremental loads, SCD Type 2, and fact/dimension modeling aligned to business requirementsWrite and optimize T-SQL against SQL Server for performant source extraction without disrupting operational workloadsMaintain pipeline monitoring, alerting, and error recovery — pipelines support 24/7 revenue operations and uptime mattersHandle PHI/PII data in full compliance with HIPAA: field masking, access controls, and audit-ready data handling at every layerCollaborate with our AI/ML engineer to ensure Silver layer data structures are ML-ready and consistently documentedMust-Have SkillsAzure Data Factory and ADLS Gen2 — production pipeline experience, not just training exercisesSnowflake — tasks, streams, incremental loading, query optimization, RBAC basicsSQL Server / T-SQL — strong enough to write efficient extraction queries against a complex operational schemaAdvanced SQL — window functions, CTEs, SCD Type 2 implementationETL/ELT patterns — incremental load design, idempotency, error handlingNice to HaveHealthcare data experiencePython for transformation utilities or pipeline testingdbt for Silver/Gold layer managementAzure DevOps / CI/CD for pipeline deploymentQualifications5-8+ years of data engineering experience with at least 2 years on AzureDemonstrated Snowflake production experienceBachelor's in CS, Information Systems, or equivalent experienceExperience working with regulated data (HIPAA, PCI, or similar)