Software Engineer II - Business Intelligence

Title: Software Engineer II - Business Intelligence Location: Ann Arbor, MI; Remote (US) <p><strong><span data-contrast="none"><span data-ccp-parastyle="heading 1">Meet the Team:</span></span></strong><span data-ccp-props="{&quot;335559738&quot;:320,&quot;335559739&quot;:140,&quot;335572079&quot;:6,&quot;335572080&quot;:4,&quot;335572081&quot;:7949855,&quot;469789806&quot;:&quot;single&quot;}">&nbsp;</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="{&quot;335559739&quot;:160}">&nbsp;</span></p> <p><strong><span data-contrast="none"><span data-ccp-parastyle="heading 1">What You'll Do:</span></span></strong><span data-ccp-props="{&quot;335559738&quot;:320,&quot;335559739&quot;:140,&quot;335572079&quot;:6,&quot;335572080&quot;:4,&quot;335572081&quot;:7949855,&quot;469789806&quot;:&quot;single&quot;}">&nbsp;</span></p> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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><strong><span data-contrast="none"><span data-ccp-parastyle="heading 1">What You'll Need to Succeed:</span></span></strong><span data-ccp-props="{&quot;335559738&quot;:320,&quot;335559739&quot;:140,&quot;335572079&quot;:6,&quot;335572080&quot;:4,&quot;335572081&quot;:7949855,&quot;469789806&quot;:&quot;single&quot;}">&nbsp;</span></p> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" data-aria-posinset="11" data-aria-level="1"><span data-contrast="auto">Proficiency in Python,&nbsp;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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" data-aria-posinset="12" data-aria-level="1"><span data-contrast="auto">Strong SQL or similar skills.</span><span data-ccp-props="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <p><strong><span data-contrast="none"><span data-ccp-parastyle="heading 1">Bonus Points:</span></span></strong><span data-ccp-props="{&quot;335559738&quot;:320,&quot;335559739&quot;:140,&quot;335572079&quot;:6,&quot;335572080&quot;:4,&quot;335572081&quot;:7949855,&quot;469789806&quot;:&quot;single&quot;}">&nbsp;</span></p> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <ul> <li data-leveltext="•" data-font="" data-listid="1" data-list-defn-props="{&quot;335552541&quot;:1,&quot;335559685&quot;:460,&quot;335559991&quot;:260,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;•&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}" 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="{&quot;335559739&quot;:80}">&nbsp;</span></li> </ul> <p><strong><span data-contrast="none"><span data-ccp-parastyle="heading 1">Work Location:</span></span></strong><span data-ccp-props="{&quot;335559738&quot;:320,&quot;335559739&quot;:140,&quot;335572079&quot;:6,&quot;335572080&quot;:4,&quot;335572081&quot;:7949855,&quot;469789806&quot;:&quot;single&quot;}">&nbsp;</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="{&quot;335559739&quot;:160}">&nbsp;</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&nbsp;</strong></span></div><div class="title">US Pay Range</div><div class="pay-range"><span>$139,000</span><span class="divider">&mdash;</span><span>$166,800 USD</span></div></div></div>