Data Architect, AI and Data Practice

Indigo Beam, LLC; Houston (TX); Hybrid; USD 140,000 - 200,000; Full time

Job summary

Indigo Beam Consulting in Houston is seeking an accomplished data and AI consultant to join our ground-floor AI and Data practice. You will work hands-on on data warehouse and reporting engagements, then grow into semantic model development with governance capabilities.

From day one you will partner with clients to translate reporting needs into governed data foundations, building scalable solutions using Fabric, Synapse, Power BI, and dbt, while mentoring teams on best practices.

Qualifications

• At least 15 years of industry experience, including at least 10 years in data and analytics and at least 10 years in consulting or client delivery roles.
• Current Microsoft data platform certifications, DP-600 (Fabric Analytics Engineer) or PL-300 (Power BI Data Analyst); DP-700 (Fabric Data Engineer) a plus.
• Strong SQL and dimensional modeling fundamentals, with production data warehouse delivery experience.
• Deep Power BI: DAX, tabular model design, workspace governance, deployment practices.
• Microsoft data platform experience: Fabric or Synapse, Azure Data Factory or equivalent pipeline tooling, OneLake or lakehouse patterns.
• Experience outside the Microsoft stack: Snowflake, Databricks, Oracle, AWS analytics services (Redshift, Glue, S3), or dbt.

Responsibilities

• Design and build data warehouse and lakehouse solutions: dimensional modeling, ELT pipelines, performance tuning.
• Deliver reporting and BI: Power BI datasets, DAX, tabular semantic models, report and dashboard development.
• Work directly with client stakeholders to turn loosely stated reporting needs into governed, documented models.
• Own engagements end to end on small teams: architecture through hands-on build through handover.
• Build agent-ready semantic layers: Microsoft Fabric semantic models and Fabric IQ ontologies.
• Carry governance through to agents with Microsoft Purview and Entra ID: sensitivity labels, permissions and row level security that agents inherit.

Skills

Data analytics

Consulting

Client delivery

Communication

Tools

Power BI

SQL

DAX

Fabric

Synapse

Azure Data Factory

dbt

OneLake

Job description

Houston, United States | Posted on 08/24/2026

Indigo Beam Consulting provides a common-sense approach to solving business problems through technology.

Born out of Bluware Inc. which has been in business for twenty-seven years, Indigo Beam was conceived as a full-service business consulting company that deeply cares about creating technology solutions that are in harmony with the environments in which they exist.

We believe that for a technology solution to be sustainable, it must be congruent with the business processes it serves, indigenously maintainable, and cognizant of the unique traits of the organization which it calls home.

Job Description

Overview

This is a dual mandate role at the ground floor of our combined AI and Data practice.

From day one you will be hands on and billable on classic data work: reporting, dashboards and data warehouse engagements for mid-market clients. As our AI offerings expand, the same role grows into the technical half of our semantic delivery pair: building the semantic models, business ontologies and governed data foundations that make AI agents trustworthy, alongside a senior functional consultant who runs the business workshops.

You should want both halves. The reporting and warehouse work is not a holding pattern; it is where client trust and the follow-on AI work come from.

What you will do first

• Design and build data warehouse and lakehouse solutions: dimensional modeling, ELT pipelines, performance tuning.
• Deliver reporting and BI: Power BI datasets, DAX, tabular semantic models, report and dashboard development.
• Work directly with client stakeholders to turn loosely stated reporting needs into governed, documented models.
• Own engagements end to end on small teams: architecture through hands-on build through handover.

Where the role grows

• Build agent-ready semantic layers: Microsoft Fabric semantic models and Fabric IQ ontologies (entities, relationships, rules) grounded in definitions agreed with the business.
• Carry governance through to agents with Microsoft Purview and Entra ID: sensitivity labels, permissions and row level security that agents inherit.
• Stand up and validate data agents (Fabric data agents, Copilot Studio) against eval suites of known-correct business questions.
• Help shape reusable method and accelerators as we productize these offerings.

Requirements

• At least 15 years of industry experience, including at least 10 years in data and analytics and at least 10 years in consulting or client delivery roles.
• Current Microsoft data platform certifications, at minimum DP-600 (Fabric Analytics Engineer) or PL-300 (Power BI Data Analyst); DP-700 (Fabric Data Engineer) is a plus. These also count toward our Microsoft partner designations.
• Strong SQL and dimensional modeling fundamentals, with production data warehouse delivery experience.
• Deep Power BI: DAX, tabular model design, workspace governance, deployment practices.
• Microsoft data platform experience: Fabric or Synapse, Azure Data Factory or equivalent pipeline tooling, OneLake or lakehouse patterns.
• Experience outside the Microsoft stack, because our clients run mixed estates. Meaningful exposure to at least one of: Snowflake, Databricks, Oracle, AWS analytics services (Redshift, Glue, S3), or dbt.
• Consulting temperament: comfortable in front of clients, able to run a working session, write things down, and manage more than one engagement at a time.

Nice to have

• Fabric IQ, semantic layer tooling (dbt Semantic Layer, Cube, AtScale), or knowledge graph and ontology experience.
• Exposure to AI agent tooling: Copilot Studio, Azure AI Foundry, MCP, or LLM evaluation practices.
• Esri ArcGIS or GIS data experience, given our geospatial practice.

Why this role?

You join at the start of a practice, not the middle of one. The path from this seat is toward the lead semantic architect role as the AI offerings scale, with direct influence on how the offerings, accelerators and standards get built. Small senior teams, no delivery pyramid, and clients who deal with the person doing the work.