[Hiring] BI Analyst @PrePass

Role Description

We’re seeking a BI Analyst to join our Business Intelligence team, reporting to the Manager of Business Intelligence. In this role, you’ll translate data into actionable insights that support business decision-making across the company. You’ll collaborate with business and technical stakeholders to understand their goals and objectives and deliver meaningful insights. This position is primarily remote, with occasional visits to our downtown Phoenix office, located directly across the street from Footprint Center.

Essential Responsibilities

• Reporting & Analysis
  • Gather, analyze, and interpret data to provide insights and recommendations to stakeholders.
  • Provide detailed quantitative and qualitative data analysis and reporting, applying statistical methods where appropriate.
  • Identify trends, patterns, and anomalies in tolling, bypass, device, and customer data.
  • Respond to ad hoc report and data requests submitted through the BI service desk across multiple business areas.
• BI Solutions & Data Quality
  • Create and enhance Power BI reports, dashboards, and visualizations, including semantic model and DAX measure changes.
  • Troubleshoot report refresh failures and data issues, partnering with data engineers on root-cause fixes.
  • Validate report outputs against warehouse and source data before release to ensure data accuracy, reliability, and accessibility.
  • Document reports, metric definitions, and data lineage in Confluence.
• AI-Assisted Analytics
  • Use AI-assisted workflows to translate business questions into reporting artifacts (semantic model changes, DAX, and documentation), validating outputs for accuracy and policy compliance.
  • Incorporate AI tools into routine reporting and documentation work, writing clear, specific prompts and refining them when the first output isn't quite right.
  • Begin applying simple agentic tools to single, well-defined tasks under guidance.
  • Review AI outputs for accuracy before use, ask informed questions, and seek out new AI use cases relevant to your work.
• Stakeholder Collaboration & Process Improvement
  • Gather and document business requirements to support reporting and analytics initiatives.
  • Proactively look for ways to improve your own workflows and reporting processes.
  • Collaborate across the BI team to reach shared goals, and mentor teammates one-on-one as opportunities arise.

Qualifications

• 2+ years of experience as a BI Analyst, Data Analyst, or in a similar reporting role.
• Hands-on experience building and maintaining Power BI reports and semantic models, including DAX.
• Intermediate SQL skills (joins, aggregations, CTEs, window functions) for querying, validating, and reconciling data.
• Ability to manage multiple requests from different stakeholders and explain findings clearly to non-technical audiences.
• Bachelor's degree (BSc/BA) in a relevant field.

Preferred

• Experience with Microsoft Fabric (lakehouses, warehouses, notebooks) or a medallion (Bronze/Silver/Gold) data architecture.
• Experience using AI tools (e.g., Microsoft Copilot, Claude, ChatGPT) in analytical work, with a habit of verifying results before use.
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600).
• Experience using Git for version control of BI assets.
• Familiarity with tolling, transportation, or fleet data.
• Exposure to Python, Alteryx, or Power Automate.
• Exceptional collaboration skills, with the ability to navigate dynamic environments and embrace change.

Benefits

• Robust benefit package that includes medical, dental, and vision that start on date of hire.
• Paid Time Off, to include vacation, sick, holidays, and floating holidays.
• 401(k) plan with employer match.
• Company-funded “lifestyle account” upon date of hire for you to apply toward your physical and mental well-being (i.e., ski passes, retreats, gym memberships).
• Tuition Reimbursement Program.
• Voluntary benefits, to include but not limited to Legal and Pet Discounts.
• Employee Assistance Program (available at no cost to you).
• Company-sponsored and funded “Culture Team” that focuses on the Physical, Mental, and Professional well-being of employees.
• Community Give-Back initiatives.
• Culture that focuses on employee development initiatives.

Join Us

At PrePass, our mission drives us. We invest in relationships. We challenge ourselves to innovate and improve. We win together. Simply put, we live our Core Values. Ready to help move the transportation industry forward? Join us and let’s drive progress—together.