Business Intelligence Analyst

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.

About the Role

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.

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.

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.
About the Work

- 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.

- Design, build, and maintain dashboards, reports and semantic models that give teams a consistent, governed view of performance.

- Write and optimize SQL - CTEs, window functions, aggregations - against production and unstructured data sources to build reports and independently validate findings.

- 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.

- Contribute to metric definitions and governance: work with the people accountable for a number until there's one definition, one source, one owner.

- 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.

- Maintain and improve the automated data extracts that teams across Operations rely on daily.

- Use AI tools to accelerate your own SQL, dbt, and dashboard development with the judgment to verify outputs rather than trust them blindly.

- Document your models, dashboards, and logic clearly enough that a teammate can maintain them without you in the room.

- Other duties as assigned.

About You

- 2+ years in BI or analytics including some hands-on experience building SQL based data models in production.

- Bachelor's degree in Computer Science, Information Systems, Statistics, Engineering, Business Analytics or equivalent practical experience.

- 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.

- 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.

- 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.

- Experience building dashboards that move users from what happened to why via drill-downs, cross-filtering a