Business Intelligence Analyst

Agility Robotics is pioneering a new era of automation with commercially deployed humanoids that work alongside teams in various facilities. As a Business Intelligence Analyst, you will transform operations data into trusted analytics, collaborate with stakeholders to gather requirements, and develop dashboards to provide a governed view of performance.

Responsibilities:

• 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

Requirements:

• 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
• Hands-on production experience building SQL-based transformation models — dbt or a comparable framework like Dataform or SQLMesh — on a modern cloud warehouse
• Direct experience building BI dashboards end-to-end (Power BI, Databricks, Looker or similar)
• Experience building dashboards that move users from what happened to why via drill-downs, cross-filtering and leading indicator/threshold flags
• Experience gathering and validating requirements directly from business stakeholders
• Ability to analyze data issues and communicate with stakeholders
• Comfortable working independently in a still-forming data environment
• Clear communication with both technical and non-technical audiences
• Curiosity about how systems fit together and ability to dig past surface-level answers
• 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