Business Intelligence Architect

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

Job Location: ATW Corporate HQ - Addison, TX 75001. Position: Business Intelligence Architect.

Job Overview

The Business Intelligence Architect owns the data foundation that sits between our source systems and the reports consumed by the business. This role designs and builds the transformation layer on top of our Azure Synapse and SQL infrastructure — creating clean, governed, and consistent data models that enable reliable reporting across all business functions.

• Building and maintaining the layered data architecture that transforms raw ERP tables into stable, business-ready models.
• Serving as the technical link between IT infrastructure and business-facing analytics.
• Translating business reporting requirements into data structures that support accurate, consistent decision-making.

Job Responsibilities

• Assess, document, and extend the existing Synapse and SQL data environment — identify what is salvageable and what needs to be rebuilt.
• Design and implement a layered data architecture (Bronze/Silver/Gold) that ingests raw source tables and produces clean, queryable views for downstream reporting.
• Build dimensional models and star schemas across key business domains including sales, inventory, production, purchasing, and finance.
• Define transformation logic, business rules, and grain definitions so all reports draw from a consistent version of truth.
• Own data pipeline health — refresh schedules, incremental load logic, and failure alerting.
• Optimize query performance across the transformation layer including indexing, materialization, and incremental refresh policies.
• Partner with IT on the underlying Azure Synapse and SQL infrastructure and build the technical case for platform improvements including Microsoft Fabric migration.
• Develop and maintain Power BI semantic models and core reports on top of the governed data layer.
• Write and optimize DAX measures and calculated columns to support operational and executive reporting.
• Publish curated, documented datasets that enable business users to answer ad-hoc questions without individual report requests.
• Enforce naming conventions, lineage documentation, and data governance standards across the analytics environment.
• Manage workspace permissions and row-level security to ensure appropriate data access.

Education – Experience Required

• 3+ years of experience in data engineering, data architecture, or a combined BI/data modeling role — manufacturing or ERP environment preferred.
• Strong SQL proficiency and hands-on experience with Azure Synapse Analytics, Azure Data Factory, or equivalent cloud data platforms.
• Demonstrated experience designing dimensional models, star schemas, and layered/medallion data architectures.
• Power BI proficiency including semantic model development and DAX — sufficient to validate and deliver reports from the data layer.
• Familiarity with Microsoft Dynamics 365 or other enterprise ERP data structures.
• Ability to assess an existing data environment, identify technical debt, and build a practical remediation plan.
• Clear communicator — able to explain technical decisions to non-technical stakeholders.
• Microsoft Fabric experience a plus.
• Comfortable operating independently in a lean, fast-moving team environment.