JOBSEARCHER

Senior Data Engineer

Robert HalfPlano, TXL6 LeadNovember 13th, 2026
About the Role: A large construction and building services company is looking for a Senior Data Engineer to build production-grade data pipelines and data products on Snowflake, dbt and Microsoft Fabric. You'll turn solution architectures into reliable, reusable pipelines across a medallion Lakehouse. You'll partner with the Sr. Solution Architect, Data Product Managers and governance leads, and grow into a technical lead as the data and AI team scales.
What You'll Do: Design, build and maintain production pipelines across the Bronze/Silver/Gold medallion architecture on Snowflake and Microsoft FabricUse dbt as the primary transformation layer, with modular, tested, documented models, incremental strategies and the dbt Semantic LayerIngest batch, micro-batch and streaming data from enterprise sources such as Dynamics 365, Procore, Workday, IoT and field operations platforms Build Kimball, Data Vault or OBT models plus reusable conformed dimensions, shared facts and domain data products Own pipeline reliability with monitoring, alerting and fast fixes to meet data product SLAsBuild reusable frameworks, templates and standards for pipeline design, dbt project structure, testing and deployment Build data quality tests and contribute to architecture decision records and technical documentation Support AI/ML workloads with feature engineering, embedding pipelines and RAG data feeds on Snowflake CortexMentor engineers, lead design and code reviews, and help assess candidates as the team grows What You Bring8–10+ years of hands-on data engineering with deep Snowflake experience: Snowpark, dynamic tables, streams and tasks, data sharing, query optimization, cost management and security Production-grade dbt in enterprise environments: modular models, testing, incremental strategies and the Semantic Layer Lakehouse and medallion architecture at production scale, with Kimball, Data Vault or OBT modeling Working proficiency in Microsoft Fabric (Lakehouse, OneLake, Data Warehouse, Dataflows Gen2, Data Factory, Notebooks, Eventstream) Experience with the Azure data stack (Data Factory, Event Hubs, Blob Storage, Key Vault) Expert SQL (window functions, CTEs, performance tuning) and strong PythonGit, branching strategies and CI/CD for data pipelines Experience integrating multiple enterprise source systems (ERP, CRM, HCM, field operations)A track record of mentoring peers and building standards that sped up team delivery Understanding of Power BI semantic model design and how it shapes upstream modeling
Nice to Have: Snowflake Cortex (Cortex Analyst, Semantic Views, ML Functions), embeddings and vector store integration for RAGFamiliarity with Snowflake Horizon and Microsoft Fabric AI capabilities Construction, building services, facilities management or project-based business data experience