Software Engineer II - Business Intelligence

Job description

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