Business Intelligence Analyst at Agility Robotics

Job description

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 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. Anticipated Base Salary Range $120,000 — $187,000 USD In addition to base pay, our competitive total rewards package consists of the following for full-time employees: 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. Benefit Start Date: Eligible for benefits on your first day of employment. Well-Being Support: Employee Assistance Program (EAP). Time Off: 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. On-Site Perks: Catered lunches four times a week and a variety of healthy snacks and refreshments at our Salem and Pittsburgh locations. Parental Leave: Generous paid parental leave programs. Work Environment: A culture that supports flexible work arrangements. Growth Opportunities: Professional development and tuition reimbursement programs. Relocation Assistance: Provided for eligible roles. Annual Discretionary Bonus: Provided for eligible roles. All of our roles are U.S.-based. Applicants must have current authorization to work in the United States. 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. Agility Robotics does not accept unsolicited referrals from third-party recruiting agencies. We prioritize direct applicants and encourage all qualified candidates to apply directly through our careers page. If you are represented by a third party, your application may not be considered. To ensure full consideration, please apply directly.

Requirements

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.
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'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.
On-Site Perks: Catered lunches four times a week and a variety of healthy snacks and refreshments at our Salem and Pittsburgh locations.
Work Environment: A culture that supports flexible work arrangements.
Growth Opportunities: Professional development and tuition reimbursement programs.
Relocation Assistance: Provided for eligible roles.
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.
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.
Insurance Coverage: 100% company-paid medical, dental, vision, and short/long-term disability insurance for employees.
Benefit Start Date: Eligible for benefits on your first day of employment.
Annual Discretionary Bonus: Provided for eligible roles.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlaigo

Platform: greenhouse
Effort: quick

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Pto

Parental Leave

Professional Development