Azure BI Architect: Data Foundation & Analytics Leader

Big Tex Trailer Manufacturing; Addison (TX); On-site; USD 100,000 - 120,000; Full time

Job summary

Big Tex Trailer Manufacturing in Addison, TX is seeking a Business Intelligence Architect to own the data foundation between source systems and business reports. This role focuses on designing a data transformation layer on Azure Synapse to ensure reliable reporting.

With strong SQL and Power BI skills, the ideal candidate will improve data workflows, model architecture, and optimize query performance. A minimum of 3 years in data engineering within a manufacturing environment is preferred.

Qualifications

• 3+ years in data engineering, data architecture, or a combined BI/data modeling role.
• Strong SQL skills with Azure Synapse Analytics or equivalent cloud platforms.
• Experience designing dimensional models and layered data architectures.
• Proficiency in Power BI with semantic model development and DAX.

Responsibilities

• Build and maintain layered data architecture for queryable views.
• Optimize data pipeline health and query performance.
• Design data models across sales, inventory, and finance domains.
• Manage data governance standards and workspace permissions.

Skills

SQL proficiency

Data modeling

Power BI

Azure Synapse Analytics

Communication skills

Education

3+ years of experience in data engineering or data architecture

Experience in manufacturing or ERP environment

Tools

Azure Data Factory

Microsoft Dynamics 365

Job description

Big Tex Trailer Manufacturing in Addison, TX is seeking a Business Intelligence Architect to own the data foundation between source systems and business reports. This role focuses on designing a data transformation layer on Azure Synapse to ensure reliable reporting.

With strong SQL and Power BI skills, the ideal candidate will improve data workflows, model architecture, and optimize query performance. A minimum of 3 years in data engineering within a manufacturing environment is preferred.