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.