Analytics Engineer

National Trench Safety is seeking an Analytics Engineer to support company-wide decision-making through reporting and data infrastructure. The role owns the layer between raw data and finished reporting, building SQL data models, Power BI semantic models and dashboards, supporting data pipelines, and partnering with business stakeholders to translate requirements into accurate, documented solutions.

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

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

Master's degree is a plus

ERP exposure

ETL/ELT concepts

Azure Data Factory

Microsoft Fabric Administration

Lakehouses

Dataflows Gen2

Git experience

Master's degree

Company

Trench and traffic safety equipment rental, sales, and services

Houston, Texas, USA

https://www.ntsafety.com/

Founded in 2004

501-1000 employees

Qualifications

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

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

Minimum (three) 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

Knowledge of data quality frameworks and data governance practices

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

Master's degree is a plus

Required skills

Power BI, DAX, SQL, Dimensional Modeling, Azure SQL Data Warehouse, Azure Data Factory, ETL/ELT, Microsoft Fabric, Git, Python, Data Quality Frameworks, Data Governance, Stakeholder Management

Preferred skills

Basic Git/source control experience, Python for data tasks, Master's degree is a plus, Houston, Texas, USA, https://www.ntsafety.com/, H1B Sponsorship, Data Powered by, Distribution of Different Job Fields Receiving Sponsorship, Represents job field similar to this job, Engineering and Development, Trends of Total Sponsorships, *2022, (1), 2021, Late Stage, Total Funding, unknown, 2022-01-01, Debt Financing, 2020-01-01, 2017-05-01, Private Equity, Leadership Team, Phil Mason, President and CEO, Recent News, reynoldaequity.com, HAS MERGED WITH TRENCH PLATE RENTAL COMPANY, 2026-09-01, Maryland Daily Record

Experience

3+ years