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