Back to search
Big Tex Trailers Linkedin · Posted 5d ago

Business Intelligence Architect

Addison, Texas, United States

Linkedin
Continue to application Add your email once, then Caio opens the original posting.

Indexed description

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.


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.


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.
Free. 20 seconds. No password. See every match in this search.

Create a free Caio profile to unlock more results and save your role and location preferences.

Unlock free search
Want help applying to roles like this? Search Caio for free. If CV tailoring and application tracking get heavy, Full Caio Agent adds a human specialist.
View Full Agent