Senior Data Engineer

Senior Data Engineer

Join a Microsoft-centric data team modernizing its warehouse architecture and pipelines on Azure. The role focuses on translating business data needs into dimensional models, building reliable extraction and loading routines, and tuning SQL so analytics teams receive trusted, performant datasets.



Successful applicants must be able to demonstrate proven, professional experience across the below areas:

* Designing and maintaining dimensional data warehouses with Kimball methodology: conformed dimensions, fact tables, referential integrity, and slowly changing dimensions.
* Writing and optimizing T-SQL stored procedures, user-defined functions, and advanced queries; analyzing execution plans and applying index strategies on Azure SQL Managed Instance or on-prem SQL Server.
* Developing, scheduling, and monitoring ETL/ELT pipelines in SSIS (Control Flow, Data Flow, checkpoints) and Azure Data Factory (pipelines, triggers, integration runtimes); leveraging Fabric or Synapse for distributed or serverless workloads, and managing load order, dependencies, logging, and error handling.
* Collaborating with analytics teams to refine data models so structures remain extensible, well documented, and performance-oriented; implementing source control and CI/CD for database objects and pipeline assets.



Any experience across the below areas, whilst not essential, would be highly advantageous:

* Data governance and quality frameworks, including cataloging, lineage tracking, and automated testing of stored procedures.
* Monitoring and optimization through Log Analytics or similar, plus awareness of Azure cost-management levers (partitioning, tier selection, pay-as-you-go compute).



This is a permanent position, working onsite at the company headquarters in the Richardson/Plano area of Dallas.