Business Intelligence Architect

Big Tex Trailers; Addison (TX); On-site; USD 95,000 - 130,000; Full time

Job summary

Big Tex Trailers, located in Addison, Texas, is looking for a Business Intelligence Architect to own the data foundation for reporting across the organization. This pivotal role involves designing and building data models that ensure reliable decision-making.

Ideal candidates have 3+ years in data engineering or architecture, strong SQL skills, and familiarity with Azure products. Responsibilities include data pipeline management and developing Power BI reports.

Qualifications

• 3+ years of experience in data engineering or data architecture.
• Strong SQL proficiency with hands-on Azure Synapse experience.
• Ability to design dimensional models and layered data architectures.

Responsibilities

• Assess, document, and extend the existing Synapse and SQL data environment.
• Design and implement a layered data architecture for data ingestion.
• Build dimensional models and star schemas for key business domains.

Skills

Data engineering

Data architecture

SQL proficiency

Power BI proficiency

Communication

Tools

Azure Synapse Analytics

Azure Data Factory

Microsoft Dynamics 365

Job description

Position: Business Intelligence Architect

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.

Key Aspects of the role include:

• 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.

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.

Qualifications

• 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.
• Comfortable operating independently in a lean, fast-moving team environment.