Analytics Engineer

National Trench Safety, LLC; Houston (TX); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Remote-friendly schedule

Job summary

National Trench Safety, LLC is seeking an Analytics Engineer in Houston to own the interface between raw data and reporting. You will design data models in Azure SQL, build Power BI semantic models, and support data pipelines while partnering with Finance, Operations, and other teams to ensure accurate, documented data structures.

You will monitor Azure Data Factory pipelines and Power BI refreshes, troubleshoot failures, and implement small pipeline changes as business needs evolve.

Qualifications

• Solid Power BI experience with semantic models and advanced DAX.
• Ability to translate business needs into data models with stakeholders.
• Strong attention to detail and data integrity in joins and boundaries.

Responsibilities

• Design, build, and maintain SQL views and data models in Azure SQL.
• Create and maintain Power BI semantic models and dashboards.
• Monitor Azure Data Factory pipelines and dataset refreshes; troubleshoot issues.
• Modify pipelines to meet evolving business requirements.
• Collaborate with SMEs to translate reporting needs into data structures.
• Document data models, definitions, and report logic for lineage.
• Help evolve naming conventions and model design standards.
• Identify process improvements and adopt new data analytics tools.

Skills

Power BI

SQL

Data modeling

DAX

Stakeholder collaboration

Data integrity

Attention to detail

Education

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

Master’s degree is a plus

Tools

Azure Data Factory

Git

Microsoft Fabric Administration

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full-time Regular Professional Houston, TX, US

4 days ago Requisition ID: 2205

Job Summary

The Data & Analytics team builds the reporting and data infrastructure that supports company-wide decision-making. The Analytics Engineer will own the layer between raw data and finished reporting, combining SQL data modeling with Power BI semantic models and dashboards.

This hybrid role partners with the Sr. Manager, Data & Analytics and business stakeholders across Finance, Operations, and other functions to build accurate, well-documented data models, support scheduled data pipelines, and troubleshoot refresh or pipeline issues as needed.

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

• 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.
• 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.

Qualifications

• Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field. Master’s degree is a plus.
• 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.