Analytics Engineer - Direct Hire - 4 days onsite

DEXTER TECHNOLOGIES INC; Parsippany-Troy Hills (NJ); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

401(k)

Bonus based on performance

Paid time off

Job summary

Dexter Technologies Inc. is seeking an Analytics Engineer to bridge data engineering and BI. You will design and optimize SQL views, staging tables, and star schemas while building semantic Power BI models for business reporting.

You’ll monitor Azure Data Factory pipelines, handle failures, and collaborate with Finance, Operations, and other stakeholders to ensure accurate data across the organization. The role offers breadth and ownership on a small team, with opportunities to evolve data

Qualifications

• 3+ years in a data-focused role with hands-on SQL
• Solid Power BI experience building semantic models and DAX measures
• Dimensional modeling fundamentals (star schemas, SCDs)
• Experience translating requirements from business stakeholders into data models
• Strong data integrity and careful joins to avoid incorrect reports

Responsibilities

• Design, build, and maintain SQL views, staging tables, and models in Azure SQL data warehouse
• Develop Power BI semantic models and dashboards for business users
• Monitor Azure Data Factory pipelines and Power BI dataset refreshes; troubleshoot failures
• Make minor modifications to pipelines as requirements change
• Partner with business SMEs to translate reporting needs into data definitions
• Document data models, metrics, and reporting logic for data lineage
• Support standards for naming, DAX style, and semantic model design
• Identify opportunities to improve data workflows and adopt new tools

Skills

SQL

Power BI

Dimensional modeling

Stakeholder collaboration

Attention to detail

Education

Bachelor’s degree in CS / DS / IS

Master’s degree a plus

Tools

Azure Data Factory

Git

Python

Microsoft Fabric

Job description

Benefits

• 401(k)
• Bonus based on performance
• Paid time off

Dexter Technologies Inc., is a leading provider of Staffing and Recruiting Services. For over two decades, we have put countless professionals to work at exciting opportunities. We are proud of the fact that many of them have been promoted to more senior roles: management, senior management, and senior executive leadership positions.

We are actively seeking qualified candidates for the following position for our client, who is an industry leader:

Analytics Engineer

Location: Houston, TX

Type: Full-time

This role is a hybrid, bridging the gap between data engineering and business intelligence. You'll spend part of your time writing and optimizing SQL — building staging tables, views, and fact/dimension models — and part of your time building semantic models and reports in Power BI. Keeping an eye on our scheduled data pipelines, you’ll handle first-line troubleshooting when something fails. You'll work closely with the Sr. Manager, Data & Analytics, and with business stakeholders across Finance, Operations, and other functions who depend on accurate, well-modeled data.

This is a great fit for someone who wants breadth — real ownership across the data stack — on a team small enough that your work visibly matters.

Key Responsibilities

• Data modeling & SQL: Design, build, and maintain SQL views, staging tables, and fact/dimension models in our Azure SQL data warehouse, including deduplication and business-rule logic (e.g., status-based routing, multi-source reconciliation).
• Semantic models & reporting: Build and maintain Power BI semantic models — relationships, DAX measures, security roles — and the reports and dashboards built on top of them for business stakeholders and company-wide reporting.
• Pipeline support: 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.
• Pipeline modifications: Make minor modifications to existing pipelines to support new or changing business requirements, as your familiarity with the tooling grows.
• Business partnership: Partner with business SMEs to translate reporting requests and business logic (commission structures, revenue recognition, inventory rules, etc.) into accurate, well-documented data models.
• Documentation: Write and maintain documentation for data models, metric definitions, and report logic so that data lineage and ownership are clear beyond any one person.
• Standards & quality: Follow and help evolve team standards for naming conventions, DAX style, and semantic model design as the team's practices mature.
• Continuous Improvement: Proactively identify opportunities for process improvements, optimize current data workflows, and incorporate new technologies or tools to enhance data analytics capabilities.

Knowledge and Skills

Required

• 3+ years in a data-focused role (analytics engineer, BI developer, data analyst, or similar) with hands-on SQL work — comfortable with CTEs, window functions, and reading/writing complex, multi-source views.
• Solid Power BI experience beyond report formatting — you've built semantic models from scratch and written DAX involving CALCULATE, filter context, and context transition, not just basic aggregations.
• Dimensional modeling fundamentals (star schemas, slowly changing dimensions).
• A track record of working directly with business stakeholders to translate ambiguous requirements or business rules into a working data model.
• Strong attention to detail with data integrity — you double-check your joins and know how a bad join or an inclusive date boundary can quietly break a report.

Preferred

• Exposure to an ERP or other core business system as a data source (order, invoicing, or GL data) - you understand that business rules, not just dates, often drive how records should be deduplicated or classified.
• Understanding of ETL/ELT concepts and working knowledge of orchestration tools like Azure Data Factory or similar tools for automating data pipelines.
• Familiarity with Microsoft Fabric Administration and Environment (Lakehouses, Dataflows Gen2) — not required, but a plus given our platform direction.
• Basic Git / source control experience.
• Python for data tasks.
• Knowledge of data quality frameworks and data governance practices.

Qualifications

• Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field. Master’s degree is a plus.
• 3+ years in a data-focused role (analytics engineer, BI developer, data analyst, or similar) with hands-on SQL work — comfortable with CTEs, window functions, and reading/writing complex, multi-source views.