Senior BI Engineer: Modernize Data Warehouse on Azure

Daisy Brand; Dallas (TX); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Daisy Brand, a Dallas-based market leader in sour cream and cottage cheese, is modernizing its data platform from SQL Server/SSIS/Tableau to Azure SQL Managed Instance and Microsoft Fabric. We seek a Senior BI Engineer to lead the transformation and own dimensional models and ETL pipelines.

You will write T-SQL, build pipelines, and translate business reporting needs into scalable data structures by collaborating with business partners. This hands-on role emphasizes reliable, secure BI solutions.

Qualifications

• 7+ years hands-on data warehouse / BI engineering experience
• 5+ years designing and building dimensional models using Kimball methodology
• 5+ years of advanced T-SQL
• 4+ years building and deploying ETL/ELT pipelines end to end with SSIS, Azure Data Factory, Microsoft Fabric, or Synapse
• 3+ years supporting production data environments
• 2+ years with semantic and analytical models — SSAS Tabular, Power BI semantic models
• Thorough understanding of data warehouse architecture, data modeling, security, and usability principles
• Experience with source control and release management (Azure DevOps or Git)
• Business‑facing communication — translate requirements from SMEs into modeled reporting solutions
• Comfort with ambiguity in fast-paced, collaborative environments

Responsibilities

• Define and maintain dimensional data models and warehouse architecture
• Oversee ETL/ELT routines with incremental loads and historical data handling
• Build and maintain semantic models (SSAS Tabular, Power BI) and measures
• Own production reliability: monitor pipelines, build audit/logging frameworks
• Work with diverse data sources (SQL Server, Dataverse, Excel, Azure SQL, SharePoint, API data)
• Migrate legacy warehouse logic to Azure SQL Managed Instance and Microsoft Fabric
• Maintain data integrity and data quality, ensure security/usability standards
• Collaborate with SMEs to determine reporting requirements
• Maintain technical documentation and participate in code reviews and Scrum processes
• Build relationships with tech teams to align initiatives
• Provide architectural guidance for reporting and analysis
• Stay current on new technologies

Skills

Dimensional modeling

T-SQL

Data warehouse design

Communication with SMEs

Data governance

Education

Bachelor’s degree in Computer Science or related field

Tools

SSIS

Azure Data Factory

Power BI

SSAS Tabular

Azure DevOps

Git

Job description

Daisy Brand, a Dallas-based market leader in sour cream and cottage cheese, is modernizing its data platform from SQL Server/SSIS/Tableau to Azure SQL Managed Instance and Microsoft Fabric. We seek a Senior BI Engineer to lead the transformation and own dimensional models and ETL pipelines.

You will write T-SQL, build pipelines, and translate business reporting needs into scalable data structures by collaborating with business partners. This hands-on role emphasizes reliable, secure BI solutions.