Indigo Beam Consulting

Analytics Engineer

Indigo Beam Consulting  •  Houston, TX (Onsite)  •  7 hours ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Analytics Engineer Contract to hire | Onsite 4 days a week | Houston, TX Our client, an established industrial company in the Houston area, is adding a new seat to its small, high-visibility IT data team. This team owns the company's enterprise data platform. In this role you will build the layer between raw data and reporting: SQL warehouse models, Azure Data Factory pipelines and Power BI semantic models. You will partner directly with Finance and Operations to turn business rules into trusted, governed data. What you will do Design and build dimensional models (star schema) in the SQL warehouse, including fact and dimension design and KPI standardization Build and support Azure Data Factory and Microsoft Fabric pipelines Own Power BI semantic models: DAX, Power Query, RLS, workspace administration, refresh and performance tuning Validate data from source to target and catch gaps before they reach reports Translate Finance and Operations business rules into governed data models, with data dictionaries, metric definitions and lineage Deliver executive reporting across the full stack, from ingestion to dashboards Requirements Must have 7 to 15 years of experience in BI, analytics engineering or data engineering, working as a senior hands-on individual contributor Advanced SQL (CTEs, window functions, multi-source views) with T-SQL / SQL Server Dimensional modeling (star schema), fact and dimension design, KPI standardization Power BI semantic models: advanced DAX, Power Query, RLS, workspace administration, refresh and performance tuning Azure Data Factory pipeline build and support Hands-on Microsoft Fabric experience (Lakehouse, pipelines, semantic models, OneLake, Dataflows) Data quality and reconciliation: source-to-target validation, catching data gaps before they hit reports Experience turning Finance and Operations business rules into governed data models, with documentation (data dictionaries, metric definitions, lineage) Nice to have Python for automation and data apps Databricks / Spark SQL, Delta Lake ERP, billing or CRM consolidation (multi-source reconciliation) Governance and cost or health monitoring of the BI platform Git, CI/CD AI-assisted analytics (Copilot, Fabric/Databricks AI features) Background in energy, oil and gas or industrial companies in the Houston area Benefits Contract to hire engagement Upon conversion: competitive base salary, annual bonus, 401K and benefits Onsite 4 days a week in Houston, TX

Indigo Beam Consulting

About Indigo Beam Consulting

Indigo Beam Consulting represents a common sense approach to solving business problems through technology. Indigo is the most fundamental yet overlooked color of the rainbow. Born out of Bluware Inc., Indigo Beam was conceived as a full-service business consulting company that deeply cares about creating technology solutions that are in harmony with environments in which they exist. We believe that for a technology solution to be sustainable, it has to be congruent with the business processes it serves, indigenously maintainable, and cognizant of the unique traits of the organization which it calls home.

Indigo Beam consultants represent a wealth of experience and deep expertise in the Power and Utilities, Oil and Gas, Public Sector and Healthcare Industries. Our reference list represents over twenty five satisfied and long term relationships who are not only clients but part of the Indigo Beam Family.

Industry
IT & Software
Company Size
11-50 employees
Headquarters
Houston, TX
Year Founded
2012
Social Media