Analytics Engineer

About the Role

Torc’s Business Intelligence team partners across the company to bring visibility and reporting that help leadership and every function make faster, better-informed decisions. We are looking for a senior technical leader who can own the data models and dashboards that power BI across the business — building the governed, reusable layer that sits between raw source systems and providing consistent reporting in all dashboards used by our stakeholders in different business units.

This role sits at the intersection of data engineering and business intelligence. You’ll design and build the pipelines and data models that make reporting fast, trustworthy, and consistent, while also staying close enough to the business to know what leadership actually needs to see. You’ll be a hands-on technical lead for the BI function with a focus on engineering, safety, and operational data — setting standards for data modeling, validation, and reporting, while also mentoring analysts and engineers so the whole team levels up.

What You’ll Do

• Design, build, and own the data models that serve as the single source of truth for BI reporting — structuring tables, views, and semantic layers so metrics are defined once and used consistently across all dashboards and tools.
• Design, build, and maintain ETL/ELT pipelines that feed those models, ensuring data is accurate, timely, and reliable at scale.
• Partner with data producers and business stakeholders to translate reporting and decision-making needs into durable data models and pipelines, rather than one-off dashboard logic.
• Define, instrument, and maintain business KPIs from scratch using SQL and Python, and ensure definitions stay consistent across teams and dashboards.
• Build and enforce data quality checks, validation processes, and documentation so stakeholders can trust the numbers behind leadership- and board-level reporting.
• Create and maintain actionable, user-friendly dashboards and visualizations (Tableau, Power BI, or similar) to provide valuable insight.
• Support and help evolve leadership-critical reporting deliverables, ensuring governed, well-documented data models rather than ad hoc queries.
• Help evolve the team’s data platform and architecture (e.g., improving legacy pipelines), balancing pragmatism with long-term maintainability.
• Work with IT and data partners to design secure, sustainable, and scalable paths for data access from source systems into BI-ready models.
• Mentor team members across data engineering, data analysis, data validation, and BI reporting — through code and model reviews, pairing, documentation, and by setting reusable standards and best practices.
• Cultivate data literacy across the organization through documentation, training, and clear communication of how and why data is modeled the way it is.