Analytics Engineer - Direct Hire - 4 days onsite - Houston- TX

DEXTER TECHNOLOGIES INC•Houston, TX

4d•$120,000 - $145,000•Hybrid

About The Position

The Analytics Engineer bridges data engineering and business intelligence, with ownership across the data stack. The role involves writing and optimizing SQL, building data models, creating Power BI semantic models and reports, and supporting scheduled data pipelines. The position works closely with the Sr. Manager, Data & Analytics and business stakeholders in Finance, Operations, and other functions to deliver accurate, well-modeled data. It is based in Houston, Texas, and is hybrid, with four days onsite.

Requirements

At least 3 years in a data-focused role, such as analytics engineer, BI developer, or data analyst, with hands-on SQL experience.
Comfort with SQL CTEs, window functions, and reading and writing complex, multi-source views.
Power BI experience building semantic models from scratch and writing DAX involving CALCULATE, filter context, and context transition.
Knowledge of dimensional modeling fundamentals, including star schemas and slowly changing dimensions.
Experience working directly with business stakeholders to translate ambiguous requirements or business rules into a working data model.
Strong attention to data integrity, including validating joins and date boundaries.
Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field.

Nice To Haves

Exposure to an ERP or other core business system as a data source, such as order, invoicing, or general ledger data.
Understanding of ETL/ELT concepts and working knowledge of orchestration tools such as Azure Data Factory or similar tools.
Familiarity with Microsoft Fabric Administration and Environment, including Lakehouses and Dataflows Gen2.
Basic Git or source control experience.
Python for data tasks.
Knowledge of data quality frameworks and data governance practices.
Master’s degree.

Responsibilities

Design, build, and maintain SQL views, staging tables, and fact/dimension models in an Azure SQL data warehouse, including deduplication and business-rule logic.
Build and maintain Power BI semantic models, including relationships, DAX measures, and security roles, along with reports and dashboards for business stakeholders and company-wide reporting.
Share responsibility with the Sr. Manager, Data & Analytics for monitoring scheduled Azure Data Factory pipelines and Power BI dataset refreshes; respond to failures and perform basic troubleshooting.
Make minor modifications to existing pipelines to support new or changing business requirements as familiarity with the tooling grows.
Partner with business subject matter experts to translate reporting requests and business logic into accurate, well-documented data models.
Write and maintain documentation for data models, metric definitions, and report logic to clarify data lineage and ownership.
Follow and help evolve team standards for naming conventions, DAX style, and semantic model design.
Identify process improvements, optimize data workflows, and incorporate new technologies or tools to enhance data analytics capabilities.