Analytics Engineer

DEXTER TECHNOLOGIES INC; Houston (TX); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

Flexible work from home options

Job summary

Dexter Technologies Inc. is seeking a Hybrid Analytics Engineer in Houston, TX to bridge data engineering and Power BI business intelligence.

The role focuses on building and optimizing Azure SQL data warehouse models and operating scheduled Azure Data Factory and Power BI refresh pipelines to deliver accurate, business-facing reporting. You will work with stakeholders to translate requirements into well-documented data models, maintain documentation, and evolve team standards for naming

Qualifications

• 3+ years in a data-focused role with hands-on SQL (CTEs, window functions).
• Experience building semantic models in Power BI from scratch and writing DAX.
• Familiarity with dimensional modeling (star schemas, SCDs).
• Experience translating business rules into data models with stakeholders.
• Attention to detail to verify joins and data integrity in reports.

Responsibilities

• Design, build, and maintain SQL views, staging tables, and fact/dimension models in an Azure SQL data warehouse.
• Build Power BI semantic models, DAX measures, and security roles for reports and dashboards.
• Monitor and troubleshoot Azure Data Factory pipelines and Power BI dataset refreshes.
• Translate reporting requests into accurate data models with business SMEs.
• Document data models, metric definitions, and report logic to clarify data lineage.

Skills

SQL proficiency

Stakeholder collaboration

Detail-oriented

Education

Bachelor's degree in CS/Data Science/IS

Tools

Power BI

DAX

Azure Data Factory

Azure SQL

CTEs / Window functions

Job description

This Hybrid Analytics Engineer role in Houston, TX supports the connection between data engineering and Power BI business intelligence. The position builds and optimizes Azure SQL data warehouse models and helps operate scheduled Azure Data Factory and Power BI refresh pipelines, with an emphasis on accurate, business-facing reporting.

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 such as status-based routing and multi-source reconciliation.
• Build and maintain Power BI semantic model relationships, DAX measures, and security roles, along with the reports and dashboards delivered to business stakeholders and for 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 pipeline failures and perform basic troubleshooting.
• Make minor updates to existing pipelines to support new or changing business requirements as tooling familiarity grows.
• Partner with business SMEs to translate reporting requests and business logic (commission structures, revenue recognition, inventory rules, etc.) into accurate, well-documented data models.
• Write and maintain documentation for data models, metric definitions, and report logic to clarify data lineage and ownership beyond any single individual.
• Help evolve team standards for naming conventions, DAX style, and semantic model design as team practices mature.
• Proactively identify process improvement opportunities, optimize data workflows, and incorporate new technologies or tools to enhance data analytics capabilities.

Requirements

• 3+ years in a data-focused role (analytics engineer, BI developer, data analyst, or similar) with hands-on SQL work using CTEs, window functions, and experience reading and writing complex multi-source views.
• Strong Power BI experience building semantic models from scratch and writing DAX using CALCULATE, filter context, and context transition, not limited to basic aggregations.
• Dimensional modeling fundamentals, including star schemas and slowly changing dimensions.
• Experience working directly with business stakeholders to translate ambiguous requirements or business rules into an operational data model.
• High attention to detail, including verifying joins and understanding how issues such as a bad join or an inclusive date boundary can quietly break reporting.

Technologies

• SQL, Azure SQL, Power BI, DAX
• Azure Data Factory
• CTEs, window functions

Education

Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field.

Benefits

• Flexible work from home options available.

Preferred Qualifications

• Exposure to an ERP or other core business system as a data source (order, invoicing, or GL data), with an understanding that business rules often drive deduplication or classification.
• Understanding of ETL/ELT concepts and working knowledge of orchestration tools such as Azure Data Factory (or similar) for automating data pipelines.
• Familiarity with Microsoft Fabric Administration and Environment (Lakehouses, Dataflows Gen2), not required but considered a plus.
• Basic Git/source control experience.
• Python for data tasks.
• Knowledge of data quality frameworks and data governance practices.Master's degree is a plus.

Job Details

• Location: Houston, TX (hybrid)
• Employment Type: Full-time
• Minimum Experience: 3 years