Data Architect, AI and Data Practice

Indigo Beam; Georgia; On-site; USD 180,000 - 240,000; Full time

Job summary

Indigo Beam Consulting is seeking a senior data & AI practitioner to join at the ground floor of our combined AI and Data practice in Houston. You will hands-on with data work—reporting, dashboards, data warehouses—and progressively contribute to building semantic models and governed data foundations for AI agents.

You will lead end-to-end engagements on small teams, collaborating with senior consultants and client stakeholders to deliver trusted, scalable data platforms in a fast-moving

Qualifications

• 15+ years of industry experience with ≥10 years in data & analytics
• Minimum DP-600 or PL-300 certifications; DP-700 a plus
• Strong SQL and dimensional modeling with production DW delivery
• Deep Power BI skills: DAX, tabular models, governance
• Experience with Fabric/Synapse, Azure Data Factory; lakehouse patterns

Responsibilities

• Design and build data warehouse and lakehouse solutions
• Deliver reporting and BI using Power BI datasets
• Collaborate with clients to transform needs into governed models
• Own engagements end-to-end on small teams

Skills

SQL

Dimensional Modeling

Power BI

Consulting

Client Delivery

Cloud Data Platform

Tools

Microsoft Fabric

Azure Synapse

Azure Data Factory

OneLake

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.