Data Architect, AI and Data Practice

Indigo Beam; Houston (TX); On-site; USD 150,000 - 210,000; Full time

Job summary

Indigo Beam Consulting is building a data and AI practice from the ground up in Houston. The role blends hands-on data work—reporting, dashboards and data warehouse engagements for mid-market clients—with the technical side of semantic delivery, including building semantic models and governed data foundations.

You will work directly with client stakeholders and grow into leading engagements end to end on small teams, from architecture through implementation to handover.

Qualifications

• 15+ years of industry experience with 10+ years in data/analytics and 10+ years in consulting or client delivery
• Current Microsoft data platform certifications (DP-600 or PL-300); DP-700 a plus
• Strong SQL and dimensional modeling fundamentals with production data warehouse delivery experience

Responsibilities

• Design and build data warehouse and lakehouse solutions with dimensional modeling and ELT pipelines
• Deliver reporting and BI: Power BI datasets, DAX, tabular models, dashboards
• Work with client stakeholders to turn reporting needs into governed, documented models
• Own engagements end to end on small teams from architecture to handover
• Develop semantic layers: Fabric semantic models and ontologies grounded in business definitions

Skills

SQL

Power BI

Dimensional modeling

Data warehousing

DAX

Education

DP-600 Fabric Analytics Engineer

PL-300 Power BI Data Analyst

DP-700 Fabric Data Engineer

Tools

Microsoft Fabric

Azure Synapse

Power BI

Azure Data Factory

Purview

Entra ID

Copilot Studio

dbt

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.