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