Data Architect, AI and Data Practice

Indigo Beam Consulting; Houston (TX); Hybrid; USD 180,000 - 240,000; Full time

Job summary

Indigo Beam Consulting in Houston, TX is seeking a senior data analytics consultant to lead hands-on data work and evolve into AI-enabled semantic delivery with senior guidance.

You will design data warehouse and lakehouse solutions, deliver Power BI reports, and partner with clients to define governed data models from requirements to delivery. Hybrid work model with client-facing engagements.

Qualifications

• Minimum 15 years of industry experience, including 10+ years in data and analytics.
• 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) is a plus.
• Strong SQL and dimensional modeling fundamentals, with production data warehouse delivery experience.

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.

Skills

SQL & Dimensional Modeling

Power BI & DAX

Client Engagement

Data Warehouse Delivery

Fabric/Synapse/ADF

Tools

Fabric

Synapse

Azure Data Factory

OneLake

Snowflake

Databricks

dbt

Oracle

Redshift

S3

Job description

Location: Houston- Hybrid (3 days onsite)

Type: Full time

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.