Senior Business Intelligence Engineer Job Dallas area,Texas USA,IT/Tech

Position Summary

Daisy Brand is modernizing its data platform and data visualization strategy, moving from a traditional solution (SQL Server, SSIS, and Tableau) to a modern cloud data platform built on Azure SQL Managed Instance and Microsoft Fabric. We are looking for a Senior BI Engineer to help lead that transformation.

Position Summary

In this role, you will design and build the dimensional models — the fact and dimension tables, star schemas, and the T‑SQL and ETL behind them — that the business runs on. You will translate business reporting needs into well‑architected, efficient data models, working directly with business partners rather than receiving finished structures from a separate engineering team. You will also build the semantic models and the operational framework that make those models trustworthy in production.

This role will drive innovation, enhance user experience, and enable data democratization across our organization.

This is a hands‑on engineering role. You will personally write the T‑SQL, build the pipelines, and own the results.

Location and Travel Requirements

This position operates under a hybrid work model, requiring onsite presence Monday, Tuesday, and Thursday, with Wednesday and Friday designated as remote workdays. While this schedule is typical, team or business needs may require additional onsite days.

Corporate Office Location Update:
Currently, the Daisy Brand corporate office is located in Dallas, TX at 635 and 75. Anticipated September 2027, we will be moving to the Granite Park business complex in North Plano (intersection of Dallas North Tollway and Sam Rayburn Tollway).

Key Responsibilities

Define, design, develop, document, and maintain dimensional data models and data warehouse architecture, personally building the fact and dimension tables, star schemas, and source‑to‑target mappings.
Oversee and perform analysis, design, implementation, and support of the company data warehouse, including developing ETL/ELT routines with appropriate tools — handling incremental loads, historical data, restartability, error handling, and load‑order dependencies.
Build and maintain semantic and analytical models (SSAS Tabular and Power BI semantic models), including measures, hierarchies, refresh orchestration, and row‑level security.
Own production reliability for the data warehouse: monitor pipeline and cube processing runs, build audit, logging, and alerting frameworks, investigate failures, document root cause, and implement corrective action.
Work across data sources such as SQL Server, Dataverse, Excel, Azure SQL, SharePoint, API‑based data, and unstructured data.
Migrate legacy warehouse logic (SQL Server, SSIS, SSRS, Tableau) onto the modern Azure SQL Managed Instance and Microsoft Fabric platform.
Maintain data integrity, ongoing solution quality, and adherence to security, architectural, and usability standards; perform data profiling, validation, and reconciliation, and resolve data quality issues with the relevant teams.
Collaborate with subject‑matter experts, often in ambiguous situations, to determine business information and reporting requirements.
Maintain technical documentation — source‑to‑target mappings, ETL specifications, job dependencies, and deployment notes — and participate in code review, source control, and release management within a Scrum process.
Build and maintain relationships with technology teams and business partners to align technology initiatives with business strategy.
Provide technical and architectural guidance to ensure effective reporting and analysis.
Stay current on new technologies through continuous learning, industry publications, vendor contacts, and training.

Other duties as assigned.

Qualifications And Requirements Basic Qualifications

7+ years of hands‑on data warehouse / BI engineering experience — you have personally built…