Hybrid Analytics Engineer — SQL, Power BI, Data Modeling

DEXTER TECHNOLOGIES INC

Parsippany-Troy Hills (NJ)

Hybrid

USD 110,000 - 140,000

Full time

14 days+

Application generator

Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.

Get past ATS filters

Benefits offered by this job

401(k)

Bonus based on performance

Paid time off

Job summary

Dexter Technologies Inc. is seeking an Analytics Engineer in Houston, TX. This hybrid role blends data engineering and business intelligence.

You will design and optimize SQL, build staging tables, and create fact/dimension models in an Azure SQL warehouse while developing semantic Power BI models. You will work with Sr. Manager Data & Analytics and cross-functional stakeholders in Finance and Operations, monitor data pipelines, troubleshoot failures, and contribute to data standards,

Qualifications

Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field.
3+ years in a data-focused role with hands-on SQL work (CTEs, window functions, multi-source views).
Experience building semantic models in Power BI and writing DAX.
Ability to translate business requirements into data models.

Responsibilities

Design, build, and maintain SQL views, staging tables, and fact/dimension models in our Azure SQL data warehouse.
Build and maintain Power BI semantic models and the reports and dashboards for stakeholders.
Monitor Azure Data Factory pipelines and dataset refreshes; respond to failures with basic troubleshooting.
Make minor pipeline modifications to support changing business requirements.
Partner with business SMEs to translate reporting needs into accurate data models.
Document data models, metric definitions, and report logic for data lineage.