Senior Analytics Engineer - Business Intelligence

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.

- Answer complex business questions via ad hoc SQL or Python analysis when a question does not yet warrant a permanent model or dashboard.

- Leverage AI-assisted development tools (e.g., GitHub Copilot, Cursor, ChatGPT/Claude) to accelerate SQL, Python, and documentation work, applying sound engineering judgment to review, validate, and take ownership of any AI-generated output before it reaches production.

- Evaluate and, where it adds value, implement AI/LLM-powered BI capabilities — such as natural-language querying, semantic layers, and AI-generated summaries or anomaly alerts — to keep our reporting stack modern and to help the team work more efficiently.

What You’ll Need to Succeed

- Bachelor’s degree in Computer Science, Data Engineering, Data Analysis, or a related field with 6+ years of experience OR a Master's degree with 3+ years of experience.

- Deep hands-on experience with data modeling and database/warehouse design — building governed, reusable data models that serve multiple downstream dashboards and reporting tools consistently.

- Strong SQL skills and proficiency in Python (pandas, PySpark, or simila