Software Engineer II - Business Intelligence

Meet the Team:

Torc's BI team partners across the business to bring visibility and reporting that help leadership and teams make faster, better-informed decisions. This is an exciting opportunity to help define how data engineering and BI work together at Torc, with real influence over the architecture and tooling.

What You'll Do:

• Design, build, and maintain ETL/ELT pipelines that power our data architecture.

• Structure and optimize tables and views to support fast, reliable reporting and dashboard performance.

• Build data quality checks, validation, and documentation so stakeholders can trust the numbers behind leadership and board-level reporting.

• Partner with BI analysts and business stakeholders to understand how data will be consumed downstream, translating reporting needs into data models and pipelines.

• Support and help evolve leadership-critical deliverables, including the enterprise SPI dashboard and consolidated TES/WBR metrics reporting.

• Help migrate existing AWS/Athena-based data delivery to our Databricks platform.

• Define, instrument, and maintain business KPIs from scratch using SQL and Python.

• Contribute to hands-on dashboard development as interest and BI tooling needs align.

What You'll Need to Succeed:

• Bachelor's degree in Computer Science, Data Engineering, or a related field, with 4+ years of professional experience in data engineering or software engineering (equivalent experience considered).

• Hands-on data engineering experience — building and maintaining ETL pipelines, data quality checks, and structuring tables vs. views for reporting performance.

• Proficiency in Python, PySpark, or similar for pipeline / ETL development, and experience with pandas, numpy, or other data analysis tooling.

• Strong SQL or similar skills.

• Understanding of how data is consumed downstream and willingness to work with consumers on improvements.

• Experience with BI tools such as Tableau, Power BI, or QuickSight.

• Comfort working with ambiguous, evolving requirements and partnering directly with stakeholders across the business.

Bonus Points:

• Experience with the Databricks platform, particularly for serving data, visualizations, and jobs.

• AWS experience, particularly Athena, Glue, or other managed data services.

• Knowledge of relational, NoSQL, vector, and data warehouse architectures.

• Hands-on dashboard-building experience, or strong interest in developing it.

• Experience scaling data for ML/AI workloads (e.g., Ray).

• Background in automotive, AV, robotics, or other safety-critical data environments.

Work Location:

Ann Arbor, MI is the hiring hub for this role; remote candidates are considered.