Job Description

Job Title: Senior BI Engineer (Data Warehouse & Microsoft Fabric)
Location: Dallas, TX. Hybrid: 3 days in the office 

About the Role:
A food & beverage manufacturer is replacing its on-premises SQL Server, SSIS and Tableau setup with a cloud analytics platform on Azure SQL Managed Instance and Microsoft Fabric. This senior engineer will help steer that move. You’ll design the warehouse yourself, write the code and own production reliability. You’ll work directly with business stakeholders rather than receiving designs from another team.

What You’ll Do:

• Gather reporting needs straight from business users and turn them into Kimball-style star schemas, building the fact and dimension tables and the source-to-target mappings yourself
• Write and tune the T-SQL behind the warehouse: stored procedures, views, functions and indexing strategy for high-volume tables
• Build ETL/ELT pipelines that handle incremental loads, history tracking, restarts after failure, error trapping and load sequencing
• Build and maintain SSAS Tabular and Power BI semantic models, including DAX measures, hierarchies, scheduled refreshes and row-level security
• Own uptime: watch pipeline and model-processing runs, add audit logging and alerting, troubleshoot failures and write up root cause and fixes
• Move legacy SSIS, SSRS and Tableau logic onto Azure SQL MI and Fabric
• Bring in data from ERP and operational systems, Dataverse, SharePoint, Excel, Azure SQL, REST APIs and semi-structured files
• Profile, validate and reconcile data, and work with source-system owners to fix quality problems
• Keep mappings, ETL specs, job dependencies and deployment notes current; take part in code reviews, Git/Azure DevOps workflows and Scrum releases
• Advise analysts and IT partners on modeling, security and usability best practices

What You Bring:

• 7+ years building data warehouse and BI solutions with your own hands, not only leading others who did
• 5+ years of dimensional modeling. You can explain grain, surrogate keys, SCD types and conformed dimensions from projects you’ve delivered
• 5+ years of advanced T-SQL, including execution plan reading and performance tuning
• 4+ years delivering pipelines end to end in SSIS, Azure Data Factory, Fabric or Synapse
• 3+ years supporting production data platforms: job monitoring, failure triage and corrective action
• 2+ years with Tabular or Power BI semantic models, DAX, refresh orchestration and RLS
• Source control and release management experience in Azure DevOps or Git, within Scrum
• Confident with business users: you can take a vague request and deliver a documented, modeled solution

Nice to Have:

• Degree in CS, MIS, IT, Engineering or similar (equivalent experience accepted)
• Microsoft certifications: Fabric Analytics Engineer, Azure Data Engineer or Azure Database Administrator
• Hands-on Fabric, Synapse, ADF or Databricks. Strong modern-stack skills can offset a lighter legacy background, and the reverse
• Azure Data Lake, CI/CD pipelines and API-based integrations
• A prior legacy-to-cloud warehouse migration
• Manufacturing data experience and familiarity with Dynamics 365 Finance & Operations data structures