Business Intelligence Analyst

Summary

Agility Robotics develops commercially deployed humanoid robots that work alongside teams in warehouses, manufacturing facilities, and distribution centers. The Business Intelligence Analyst will support Operations by gathering stakeholder requirements, developing governed dashboards and semantic models, and building data models that transform operations data into reliable analytics. The role also contributes to metric governance, data validation, automated extracts, and documentation.

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

Skills

• 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
• All of our roles are U.S.-based. Applicants must have current authorization to work in the United States
• 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

Qualifications

Must Haves

• 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
• All of our roles are U.S.-based. Applicants must have current authorization to work in the United States

Nice to Haves

• 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

Benefits

• 401(k) Plan: Includes a 6% company match.
• Equity: Company stock options.
• Insurance Coverage: 100% company-paid medical, dental, vision, and short/long-term disability insurance for employees.
• Eligible for benefits on your first day of employment.
• Employee Assistance Program (EAP).
• Exempt Employees: Flexible, unlimited PTO and 12 company holidays, including a winter shutdown.
• Non-Exempt Employees: 10 vacation days, paid sick leave, and 12 company holidays, including a winter shutdown, annually.
• Catered lunches four times a week and a variety of healthy snacks and refreshments at our Salem and Pittsburgh locations.
• Generous paid parental leave programs.
• A culture that supports flexible work arrangements.
• Professional development and tuition reimbursement programs.
• Relocation assistance provided for eligible roles.
• Annual discretionary bonus provided for eligible roles.