Business Intelligence Analyst

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 and leading indicator/threshold flags that point toward what to act on next.
• Experience gathering and validating requirements directly from business stakeholders, including ones who don't yet have the vocabulary to describe what they need.
• 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.
• 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.
• You communicate clearly with both technical and non-technical audiences, and you're comfortable presenting a finding when the number surprises people.
• You're curious about how systems fit together and you dig past a surface-level answer.

Bonus Points

• Experience with Databricks, Unity Catalog, or a modern cloud data warehouse.
• Comfortable with git/version control for analytics code.
• Background in manufacturing, robotics, or another operationally complex, high-growth environment.
• Experience building or maintaining a semantic layer or metric governance process across multiple stakeholder teams.

Location

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

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.