Business Intelligence Analyst

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.

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

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., Remote or Hybrid United States 100K-110K Annually Senior level 100K-110K Annually Senior level Insurance * Logistics * Software * Transportation * Business Intelligence Transform data into actionable insights by building dashboards, reports, and visualizations. Partner with cross-functional teams and data engineering to ensure data quality, lineage, and AI-ready metadata. Audit datasets, define monitoring rules, document data dictionaries, pilot AI-assisted BI tools, and apply hypothesis-driven analysis to surface insights that inform business decisions. Top Skills: Ai Coding AssistantsAtlanEtl ToolsLlm-Based ToolsLookerModern Data StackNoSQLOpenmetadataPower BIPythonRedashSnowflakeSQL GoGuardian

Business Intelligence Analyst

5 Days Ago Remote United States 115K-125K Annually Mid level 115K-125K Annually Mid level Edtech * Software Provide tactical and strategic BI to marketing, sales, and finance by building dashboards, defining KPIs, analyzing performance, alerting and investigating changes, and partnering with data engineering to ensure data quality and reliable tracking. Top Skills: Google AnalyticsHubspotSalesforceSQLTableau Astreya, 66K-104K Annually Mid level 66K-104K Annually Mid level Information Technology Perform quantitative and qualitative analysis, build reports and dashboards, produce datasets, troubleshoot data issues, and present findings to stakeholders. Collaborate across teams and third parties to define reporting specs, improve data quality, and recommend KPIs and best practices to support decision-making. Top Skills: BigQueryGoogle SuiteGoogle SheetsHadoopMS OfficePower BIPythonServicenowSQLSsisSsrsTableau

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

• Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
• Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
• Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
• Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
• Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
• Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute