Analytics Engineer - Direct Hire - 4 days onsite

DEXTER TECHNOLOGIES INC•Parsippany-Troy Hills, NJ

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

About The Position

Dexter Technologies Inc. is seeking an Analytics Engineer for a full-time, direct-hire position with their client, an industry leader. This hybrid role bridges data engineering and business intelligence. The Analytics Engineer will be responsible for writing and optimizing SQL to build staging tables, views, and fact/dimension models, as well as building semantic models and reports in Power BI. The role involves monitoring scheduled data pipelines, performing first-line troubleshooting, and collaborating with the Sr. Manager, Data & Analytics, and business stakeholders across various functions. This position offers the opportunity for broad ownership across the data stack in a team where individual contributions are highly visible.

Requirements

3+ years in a data-focused role (analytics engineer, BI developer, data analyst, or similar) with hands-on SQL work, including CTEs, window functions, and complex, multi-source views.
Solid Power BI experience, including building semantic models from scratch and writing DAX involving CALCULATE, filter context, and context transition.
Understanding of dimensional modeling fundamentals (star schemas, slowly changing dimensions).
Proven ability to work directly with business stakeholders to translate ambiguous requirements or business rules into a working data model.
Strong attention to detail with data integrity.

Nice To Haves

Exposure to an ERP or other core business system as a data source.
Understanding of ETL/ELT concepts and working knowledge of orchestration tools like Azure Data Factory or similar.
Familiarity with Microsoft Fabric Administration and Environment (Lakehouses, Dataflows Gen2).
Basic Git / source control experience.
Python for data tasks.
Knowledge of data quality frameworks and data governance practices.

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, and create reports and dashboards for business stakeholders.
Monitor scheduled Azure Data Factory pipelines and Power BI dataset refreshes, responding to failures and performing basic troubleshooting.
Make minor modifications to existing pipelines to support new or changing business requirements.
Partner with business SMEs 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.
Follow and help evolve team standards for naming conventions, DAX style, and semantic model design.
Proactively identify opportunities for process improvements, optimize current data workflows, and incorporate new technologies or tools to enhance data analytics capabilities.