> Markdown version of [/jobs/ext/3734248-snowflake-data-engineer](https://www.wearedevelopers.com/jobs/ext/3734248-snowflake-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Snowflake Data Engineer - **Company:** BUSINESS CENTRIC TECHNOLOGIES LLC - **Location:** Addison, TX, United States - **Experience:** Experienced - **Salary:** $150,000.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Microsoft Azure, Information Systems, Continuous Integration, Information Engineering, Extract Transform Load (ETL), Data Structures, Database Queries, Microsoft SQL Server, Query Optimization, Role-Based Access Control, Azure Data Lake, Transact-SQL, Data Processing, Azure Data Factory, Snowflake, Information Technology, Data Pipelines - **Published:** October 14, 2026 - **Apply:** https://www.careerjet.com/jobad/us12a2f6d615d0832c46b99ce834ed283e ## About the Role * 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. ## Description * 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.