Hybrid Data Analytics Engineer — Power BI & SQL

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

Benefits offered by this job

Dental insurance

Health insurance

Vision insurance

Job summary

DEXTER TECHNOLOGIES INC in Houston is seeking a Data Analytics Engineer to bridge data engineering and business intelligence. You'll write and optimize SQL, build staging tables, views, and fact/dimension models in an Azure SQL data warehouse, and develop semantic models and reports in Power BI.

You will monitor Azure Data Factory pipelines, troubleshoot failures, and collaborate with stakeholders across Finance and Operations to deliver accurate, well-modeled data.

Qualifications

• 3+ years in a data-focused role with hands-on SQL work.
• Experience building semantic models in Power BI.
• Knowledge of dimensional modeling and data warehousing concepts.
• Ability to translate requirements into working data models with stakeholders.
• Strong attention to data integrity and join logic.

Responsibilities

• Data modeling & SQL: design and maintain SQL views, staging tables, and fact/dimension models in Azure SQL.
• Semantic models & reporting: build Power BI semantic models and reports for stakeholders.
• Pipeline support: monitor Azure Data Factory pipelines and Power BI refreshes; troubleshoot failures.
• Pipeline modifications: make minor changes to existing pipelines for evolving needs.
• Business partnership: translate reporting requests into accurate data models with SMEs.
• Documentation: document data models, metrics, and report logic for traceability.
• Standards & quality: contribute to naming conventions and semantic model design.

Skills

SQL

Power BI

Dimensional modeling

Stakeholder engagement

Data quality

Education

Bachelor’s degree in Computer Science or related

Master’s degree a plus

Tools

Azure Data Factory

Git

Python

Job description

DEXTER TECHNOLOGIES INC in Houston is seeking a Data Analytics Engineer to bridge data engineering and business intelligence. You'll write and optimize SQL, build staging tables, views, and fact/dimension models in an Azure SQL data warehouse, and develop semantic models and reports in Power BI.

You will monitor Azure Data Factory pipelines, troubleshoot failures, and collaborate with stakeholders across Finance and Operations to deliver accurate, well-modeled data.