Business Intelligence Analyst at Agility Robotics

United States

$120k - $187k

<div class="content-intro"><p>Agility’s commercially deployed humanoids operate alongside teams in warehouses, manufacturing facilities, and distribution centers—tackling physically demanding and repetitive tasks while enabling workers to focus on higher-value work. With industry-leading safety standards and years of proven deployment data, we're pioneering a new era of automation that enhances human potential.</p></div><h1><span style="font-size: 12pt;"><strong>About the Role</strong></span></h1> <p><span style="font-size: 10pt;">Agility Robotics is scaling its Operations Business Intelligence function. As a Business Intelligence Analyst, you will help turn operations data into analytics that people trust so the organization runs on numbers instead of anecdotes.</span></p> <p><span style="font-size: 10pt;">You'll join a small fast moving BI team embedded within Operations and report to the Business Intelligence Manager. This is a full-stack role: you'll gather requirements directly from stakeholders across Operations; build and maintain governed dashboards and semantic models; and, as we bring Databricks and dbt online, help build the Operations specific data models that sit on top of our data platform's governed layers. The BI team owns requirements, metric definitions, and the analytics layer that turns raw tables into numbers people can trust.</span></p> <p><span style="font-size: 10pt;">This role is a strong fit for someone who can move fluidly between a stakeholder conversation and a SQL window function and who wants to help shape how a data function gets built rather than just execute inside one that already exists.</span></p> <h1><span style="font-size: 12pt;"><strong>About the Work</strong></span></h1> <ul> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Partner directly with stakeholders across Operations, Quality, Production, and Supply Chain to gather requirements and translate open-ended business questions into structured, testable data questions.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Design, build, and maintain dashboards, reports and semantic models that give teams a consistent, governed view of performance.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Write and optimize SQL - CTEs, window functions, aggregations - against production and unstructured data sources to build reports and independently validate findings.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Help lead transition from Power BI based reporting onto Databricks/dbt by building the Operations specific dbt models that sit on top of data engineering's governed layers to answer Operations specific questions.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Contribute to metric definitions and governance: work with the people accountable for a number until there's one definition, one source, one owner.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Validate your own analysis before it goes wide: know the failure modes of your data, spot-check outputs against a second source, and flag data-quality issues rather than assuming a query or pipeline is right by default.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Maintain and improve the automated data extracts that teams across Operations rely on daily.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Use AI tools to accelerate your own SQL, dbt, and dashboard development with the judgment to verify outputs rather than trust them blindly.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Document your models, dashboards, and logic clearly enough that a teammate can maintain them without you in the room.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Other duties as assigned.</span></li> </ul> <h1><span style="font-size: 12pt;"><strong>About You</strong></span></h1> <ul> <li style="font-size: 10pt;"><span style="font-size: 10pt;">2+ years in BI or analytics including some hands-on experience building SQL based data models in production.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Bachelor's degree in Computer Science, Information Systems, Statistics, Engineering, Business Analytics or equivalent practical experience.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Strong SQL, including CTEs, window functions, and writing performant queries against large tables. You can go from a business question to a query to an answer without hand-holding.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Hands-on production experience building SQL-based transformation models — dbt or a comparable framework like Dataform or SQLMesh — on a modern cloud warehouse. You can describe how you structured staging vs. mart layers, what you tested, and how you used version control, not just that using SQL to build views.&nbsp;</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Direct experience building BI dashboards end-to-end (Power BI, Databricks, Looker or similar) — not just formatting visuals, but building the data model and calculations underneath them.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience building dashboards that move users from what happened to why via drill-downs, cross-filtering and leading indicator/threshold flags that point toward what to act on next.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience gathering and validating requirements directly from business stakeholders, including ones who don't yet have the vocabulary to describe what they need.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">You can look at a number that seems wrong, form a hypothesis about why, and figure out whether the issue is the data, the logic, or the underlying business process and you talk to the stakeholders behind the system when the data alone doesn't explain it.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">You're comfortable working independently in a still-forming data environment; some of what you'll build won't have a clean, governed source yet.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">You communicate clearly with both technical and non-technical audiences, and you're comfortable presenting a finding when the number surprises people.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">You're curious about how systems fit together and you dig past a surface-level answer.</span></li> </ul> <h1><span style="font-size: 12pt;"><strong>Bonus Points</strong></span></h1> <ul> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience with Databricks, Unity Catalog, or a modern cloud data warehouse.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Comfortable with git/version control for analytics code.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Background in manufacturing, robotics, or another operationally complex, high-growth environment.</span></li> <li style="font-size: 10pt;"><span style="font-size: 10pt;">Experience building or maintaining a semantic layer or metric governance process across multiple stakeholder teams.</span></li> </ul> <p>&nbsp;</p> <hr> <p>&nbsp;</p> <p><span style="font-size: 12pt;"><strong>Location</strong></span></p> <ul> <li style="font-size: 10pt;"><span style="font-size: 10pt;">This is a fully remote role with the option to work hybrid if a commutable distance from our Salem, OR, Pittsburgh, PA, or Fremont, CA offices.</span></li> </ul> <p><span style="font-size: 10pt;"><em>The final salary offered to a successful candidate will be dependent on several factors that may include but are not limited to: market location, job-related knowledge, skills, and experience. This range may change based on geographical location and may be modified in the future.</em></span></p><div class="content-pay-transparency"><div class="pay-input"><div class="title">Anticipated Base Salary Range</div><div class="pay-range"><span>$120,000</span><span class="divider">&mdash;</span><span>$187,000 USD</span></div></div></div><div class="content-conclusion"><p><strong><em>In addition to base pay, our competitive total rewards package consists of the following for full-time employees:</em></strong></p> <ul> <li><strong>401(k) Plan:</strong><span class="Apple-converted-space">&nbsp;</span>Includes a 6% company match.</li> <li><strong>Equity:</strong><span class="Apple-converted-space">&nbsp;</span>Company stock options.</li> <li><strong>Insurance Coverage:</strong><span class="Apple-converted-space">&nbsp;</span>100% company-paid medical, dental, vision, and short/long-term disability insurance for employees.</li> <li><strong>Benefit Start Date:</strong><span class="Apple-converted-space">&nbsp;</span>Eligible for benefits on your first day of employment.</li> <li><strong>Well-Being Support:</strong><span class="Apple-converted-space">&nbsp;</span>Employee Assistance Program (EAP).</li> <li><strong>Time Off:</strong> <ul> <li><strong>Exempt Employees:</strong><span class="Apple-converted-space">&nbsp;</span>Flexible, unlimited PTO and 12 company holidays, including a winter shutdown.</li> <li><strong>Non-Exempt Employees:</strong><span class="Apple-converted-space">&nbsp;</span>10 vacation days, paid sick leave, and 12 company holidays, including a winter shutdown, annually.</li> </ul> </li> <li><strong>On-Site Perks:</strong><span class="Apple-converted-space">&nbsp;</span>Catered lunches four times a week and a variety of healthy snacks and refreshments at our Salem and Pittsburgh locations.</li> <li><strong>Parental Leave:</strong><span class="Apple-converted-space">&nbsp;</span>Generous paid parental leave programs.</li> <li><strong>Work Environment:</strong><span class="Apple-converted-space">&nbsp;</span>A culture that supports flexible work arrangements.</li> <li><strong>Growth Opportunities:</strong><span class="Apple-converted-space">&nbsp;</span>Professional development and tuition reimbursement programs.</li> <li><strong>Relocation Assistance:</strong><span class="Apple-converted-space">&nbsp;</span>Provided for eligible roles.</li> <li><strong>Annual Discretionary Bonus:</strong> Provided for eligible roles.</li> </ul> <p><span style="font-weight: 400;">All of our roles are U.S.-based. Applicants must have current authorization to work in the United States.</span></p> <p><span style="font-weight: 400;">Agility Robotics is committed to a work environment in which all individuals are treated with respect and dignity. Each individual has the right to work in a professional atmosphere that promotes equal employment opportunities and prohibits unlawful discriminatory practices, including harassment. Therefore, it is the policy of Agility Robotics to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, age, disability, marital status, citizenship, national origin, genetic information, or any other characteristic protected by law. Agility Robotics prohibits any such discrimination or harassment.</span></p> <p>&nbsp;</p> <p><strong>Agility Robotics does not accept unsolicited referrals from third-party recruiting agencies.&nbsp; We prioritize direct applicants and encourage all qualified candidates to apply directly through our careers page.&nbsp; If you are represented by a third party, your application may not be considered.&nbsp; To ensure full consideration, please apply directly.</strong></p> <p>&nbsp;</p></div>