Data Engineer

Role: Data EngineerLocation: Addison TX (Onsite)Ideal Candidate Personality / Soft SkillsStrong collaborator who works well with cross-functional teams.Comfortable operating in a brand-new, evolving environment and helping build processes from the ground up.Ownership mindset with the ability to manage, build, and expand data solutions.Proactive in managing pipeline health, data quality, and data governance experience.Adaptable, hands-on, and capable of balancing engineering execution with operational support.About the RoleClient is 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)