SOFTWARE ENGINEER II - BUSINESS INTELLIGENCE

<p><strong><span data-contrast="none"><span data-ccp-parastyle="heading 1">Meet the Team:</span></span></strong><span data-ccp-props="{"335559738":320,"335559739":140,"335572079":6,"335572080":4,"335572081":7949855,"469789806":"single"}"> </span></p> <p><span data-contrast="auto">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.</span><span data-ccp-props="{"335559739":160}"> </span></p> <p> </p> <p><strong><span data-contrast="none"><span data-ccp-parastyle="heading 1">What You'll Do:</span></span></strong><span data-ccp-props="{"335559738":320,"335559739":140,"335572079":6,"335572080":4,"335572081":7949855,"469789806":"single"}"> </span></p> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="1" data-aria-level="1"><span data-contrast="auto">Design, build, and maintain ETL/ELT pipelines that power our data architecture.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="2" data-aria-level="1"><span data-contrast="auto">Structure and optimize tables and views to support fast, reliable reporting and dashboard performance.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="3" data-aria-level="1"><span data-contrast="auto">Build data quality checks, validation, and documentation so stakeholders can trust the numbers behind leadership and board-level reporting.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="4" data-aria-level="1"><span data-contrast="auto">Partner with BI analysts and business stakeholders to understand how data will be consumed downstream, translating reporting needs into data models and pipelines.</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="5" data-aria-level="1"><span data-contrast="auto">Support and help evolve leadership-critical deliverables, including the enterprise SPI dashboard and consolidated TES/WBR metrics reporting.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="6" data-aria-level="1"><span data-contrast="auto">Help migrate existing AWS/Athena-based data delivery to our Databricks platform.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="7" data-aria-level="1"><span data-contrast="auto">Define, instrument, and maintain business KPIs from scratch using SQL and Python.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="8" data-aria-level="1"><span data-contrast="auto">Contribute to hands-on dashboard development as interest and BI tooling needs align.</span></li> </ul> <p> </p> <p><strong><span data-contrast="none"><span data-ccp-parastyle="heading 1">What You'll Need to Succeed:</span></span></strong><span data-ccp-props="{"335559738":320,"335559739":140,"335572079":6,"335572080":4,"335572081":7949855,"469789806":"single"}"> </span></p> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="9" data-aria-level="1"><span data-contrast="auto">Bachelor's degree in Computer Science, Data Engineering, or a related field, with 4</span><span data-contrast="auto">+ years of</span><span data-contrast="auto"> professional experience in data engineering or software engineering (equivalent experience considered).</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="10" data-aria-level="1"><span data-contrast="auto">Hands-on data engineering experience — building and maintaining ETL pipelines, data quality checks, and structuring tables vs. views for reporting performance.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="11" data-aria-level="1"><span data-contrast="auto">Proficiency in Python, PySpark</span><span data-contrast="auto">,</span><span data-contrast="auto"> or similar for pipeline / ETL development, and experience with pandas, numpy, or other data analysis tooling.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="12" data-aria-level="1"><span data-contrast="auto">Strong SQL or similar skills.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="13" data-aria-level="1"><span data-contrast="auto">Understanding of how data is consumed downstream and willingness to work with consumers on improvements. </span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="14" data-aria-level="1"><span data-contrast="auto">Experience with BI tools such as Tableau, Power BI, or QuickSight.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="15" data-aria-level="1"><span data-contrast="auto">Comfort working with ambiguous, evolving requirements and partnering directly with stakeholders across the business.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <p> </p> <p><strong><span data-contrast="none"><span data-ccp-parastyle="heading 1">Bonus Points:</span></span></strong><span data-ccp-props="{"335559738":320,"335559739":140,"335572079":6,"335572080":4,"335572081":7949855,"469789806":"single"}"> </span></p> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="16" data-aria-level="1"><span data-contrast="auto">Experience with the Databricks platform, particularly for serving data, visualizations, and jobs.</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="17" data-aria-level="1"><span data-contrast="auto">AWS experience, particularly Athena, Glue, or other managed data services.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="18" data-aria-level="1"><span data-contrast="auto">Knowledge of relational, NoSQL, vector, and data warehouse architectures.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="19" data-aria-level="1"><span data-contrast="auto">Hands-on dashboard-building experience, or strong interest in developing it.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="20" data-aria-level="1"><span data-contrast="auto">Experience scaling data for ML/AI workloads (e.g., Ray).</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{"335552541":1,"335559685":460,"335559991":260,"469769242":[8226],"469777803":"left","469777804":"•","469777815":"hybridMultilevel"}" data-aria-posinset="21" data-aria-level="1"><span data-contrast="auto">Background in automotive, AV, robotics, or other safety-critical data environments.</span><span data-ccp-props="{"335559739":80}"> </span></li> </ul> <p> </p> <p><strong><span data-contrast="none"><span data-ccp-parastyle="heading 1">Work Location:</span></span></strong><span data-ccp-props="{"335559738":320,"335559739":140,"335572079":6,"335572080":4,"335572081":7949855,"469789806":"single"}"> </span></p> <p><span data-contrast="auto">Ann Arbor, MI is the hiring hub for this role; remote candidates are considered.</span><span data-ccp-props="{"335559739":160}"> </span></p><div class="content-pay-transparency"><div class="pay-input"><div class="description"><span style="text-decoration: underline;"><strong>Hiring Range for Job Opening </strong></span></div><div class="title">US Pay Range</div><div class="pay-range"><span>$139,000</span><span class="divider">-</span><span>$166,800 USD</span></div></div></div>