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.

Hiring Range for Job Opening

US Pay Range

$139,000-$166,800 USD