Business Intelligence Architect
Big Tex Trailers
Business Intelligence Architect
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.
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.
Vacancy posted 5 days ago
Similar jobs that could be interesting for youBased on the Business Intelligence Architect in Addison, TX vacancy
- ...Job Summary This position is responsible for the development and delivery of business intelligence solutions, with a focus on designing and implementing reports and dashboards using MS Fabric, MicroStrategy, BusinessObjects (BO), and other enterprise reporting tools...Business intelligence
- ...AWS Databricks Architect Location: Plano TX (100% onsite role from Day 1) Responsibilities: Leading the architecture... ...troubleshoot and optimize Databricks queries for analytics and business intelligence use cases. Basic knowledge of DevOps practices for...Business intelligenceFlexible hours
- ...About the role As a BI Architect , you will make an impact by designing and implementing scalable, enterprise Business Intelligence solutions that enable data-driven decision-making. You will be a valued member of the data and analytics team and work collaboratively...Business intelligenceWork at officeRemote work
- A leading healthcare organization in Dallas, Texas seeks an experienced BI Developer. This position involves delivering business intelligence solutions, ensuring data integrity, and developing reports, dashboards, and analytical tools using various technologies such as...Business intelligence
- A healthcare technology solutions provider based in Dallas is seeking a Senior BI Developer responsible for creating business intelligence solutions. The role requires expertise in MS Fabric, MicroStrategy, and SQL, with at least 10 years of experience. You will work on...Business intelligence
- ...warehousing applications 2+ years of strong Hadoop and NoSQL experience Must have architected full lifecycle of data warehousing projects including ETL, Data Models and Business Intelligence tools. Strong foundational knowledge and experience with distributed systems...Business intelligence
- A technology solutions company is seeking a detail-oriented Power BI Developer in Dallas, Texas to design and maintain business intelligence solutions. Responsibilities include developing Power BI dashboards and ensuring data integrity while collaborating with stakeholders...Business intelligence
- ...About the job Snowflake Architect JOB DESCRIPTION ~10 + years experience ~ We are seeking an experienced snowflake... ...performance data solutions on Snowflake platform ~ Understand business challenges, data requirements and current technology...Business intelligence
- Job Description Seeking detail‑oriented Power BI Developer to design, develop, and maintain business intelligence solutions using Microsoft Power BI. Will transform raw data into meaningful insights through interactive dashboards and reports, enabling data‑driven decision...Business intelligencePermanent employmentContract workLocal area
$57.14 - $58.82 per hour
...Cloud Data Architect Pay Rate Range: $57.14 - 58.82/hr Role: Cloud Data Architect Job Description 1. Architecture & Design... ...DSS if BFSI). 5. Stakeholder Collaboration Work with business stakeholders to translate requirements into technical architectures...Business intelligence- ...Power Bi Architect We are seeking a Power BI Architect with deep hands on expertise in designing and delivering enterprise scale analytics... ...with a focus on performance, scalability, security, and business adoption. Key Responsibilities Architecture & Design...Business intelligence
- ...governance for Power BI development across the organization. Architect enterprise semantic models using Power BI datasets, shared... ...Ensure scalable, high-performance BI solutions aligned with business and technical requirements. Power BI Development & Optimization...Business intelligence
- ...Sr. Bi Architect The Sr. BI Architect plays a crucial role by ensuring that data-driven insights are used to drive decision-making... ...an individual would typically need a combination of technical, business, and soft skills in the industry for 8-10 years. A combination...Business intelligence
- ...Power BI Architect Location: New Jersey (preferred) or Dallas, TX Work Mode: Remote with Hybrid (3 days remote + 2 days/week at... ...to lead enterprise-level BI initiatives, working closely with business stakeholders to translate requirements into scalable, cloud-native...Business intelligenceWork at officeRemote work2 days per week3 days per week
- ...About the Job The Integration Architect will be responsible for working in close partnership with Integration leadership, the... ...creation. ~ Experience with EDW development life cycle from business requirement gathering to end solutions. ~ Experience with...Business intelligenceTemporary workFor contractorsWork at officeRelocationRelocation packageFlexible hours
- ...Oracle Functional Financials Architect Who We Are R-Cubed Consulting is a business strategy and technology consulting firm powered by relationships, results, and reputation. These core values guide everything we do, shaping our commitment to delivering...Business intelligence
- TechDigital Group is seeking a Power BI Architect located in Dallas, Texas. The successful candidate will have 8-12 years of experience in BI and data engineering, including 5+ years hands-on with Power BI and GCP. Responsibilities include architecting and delivering Power...Business intelligence
- ...and deploy scalable Snowflake architectures, collaborating with business and technology teams to ensure efficient, high-quality data... ...processes using Snowflake and complementary cloud technologies. Architect and implement scalable data warehouse solutions to support...Business intelligence
- ...Oracle Fusion HCM Functional Technical Lead/Architect This role is a hands on senior position responsible for the end to end functional... ...closely with HR, Product, and IT stakeholders to translate business strategy and requirements into scalable, secure, and compliant...Business intelligence
- Helen of Troy in Dallas, TX is seeking a Sr. BI Developer to enhance decision-making with analytical tools. This hybrid role involves designing Power BI solutions and leading a data-centric culture within the organization. The ideal candidate will have over 7 years of BI...Business intelligence
$136k - $142k
Kiewit is seeking a Power BI Developer to design and deliver analytics solutions for complex EPC projects. This remote position focuses on developing dashboards and managing data strategies to support decision-making in major construction programs. The role offers competitive...Business intelligenceRemote job- ...Lead Architect A career with us is a journey, not a destination. This could be the next best step in your technical career. Join us... ...As a Lead Architect at JPMorgan Chase within the CIB line of business, you are an integral part of a team that works to develop high...Business intelligence
$120k - $140k
...Power BI Architect (Dallas, TX | Hybrid) Location: Dallas, TX (Hybrid; some in-office travel required) Work authorization: Unable... ...And more… About Smartbridge At Smartbridge, we simplify business transformation, applying thought leadership and innovation to...Business intelligenceWork at office- ...: Partner with the core Marketing Analytics team to gather business requirements and translate them into tangible deliverables with... ...experience developing Data Warehousing or Business Intelligence Applications. Must have progressive experience with coding languages...Business intelligenceRemote workWorldwide
- ...Job Title: Workday Architect Location: 100% Remote Duration: Contract Job Description: Solutions Architect for Workday... ...specializing in HR. This pivotal role involves consulting with HR business stakeholders to prepare and design roadmaps for solutions in...Contract workWork at officeRemote work
$52k
...Job Description PIM Architect: High Level requirements for the Role Lead remediation efforts for the existing... ...scalable, next-generation PIM platform, ensuring alignment with business goals and technical feasibility. Collaborate and...Full timeFor contractors- ...Job Title: Google Kubernetes Architect Duration: Contract Location: Phoenix, AZ (On-site). Skills: Google Kubernetes Engine (GKE); GCP; ETL - Big Data / Data Warehousing; Cloud Networking; Machine Learning; Kubernetes; Openshift; Postgres / Postgresql...Contract workWork at office
- ...Job Title: Guidewire PolicyCenter Architect Location: Waren, NJ (Hybrid) Duration: Contract ROLE SUMMARY: The Guidewire... ...10, the architect spearheads technical design, aligns it with business goals and IT strategies, and enhances our Guidewire ecosystem'...Contract workWork at office
- ...performance diagnostics, and support ROI focused planning and optimization. MAJOR DUTIES AND RESPONSIBILITIES Drives the business intelligence of our eyewear brands, frames and lenses, ideating and maintaining dashboards to support Marketing activities, and to...Business intelligenceMinimum wageFull timeLocal area
- ...and Cloud Services. You will need to understand your part of business logic and implement it using the language supported by the base... ...results to non-technical audiences • Knowledge of business intelligence and analytical tools, technologies and techniques. • Familiarity...Business intelligenceRemote workFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Business Intelligence Architect. Be the first to apply!
Related searches
- business technology Addison, TX
- business technician Addison, TX
- regional business director Addison, TX
- business recruiter Addison, TX
- area business manager Addison, TX
- new business Addison, TX
- entry level business to business sales Addison, TX
- business to business sales Addison, TX
- business objects Addison, TX
- business operations intern Addison, TX


