BI Analyst

PrePass; Phoenix (AZ); Remote; USD 80,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, and vision benefits

401(k) plan with employer match

Tuition Reimbursement

Job summary

PrePass is seeking a BI Analyst to join the Business Intelligence team, working primarily remote with periodic visits to our Phoenix office. You will translate data into actionable insights, build Power BI reports, and collaborate across business and technical stakeholders to support decision-making.

The role emphasizes AI-assisted analytics, data quality, and continuous improvement of reporting processes while maintaining clear documentation and governance across data sources.

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.

Responsibilities

• Gather, analyze, and interpret data to provide insights and recommendations to stakeholders.
• Create and enhance Power BI reports, dashboards, and visualizations, including semantic model and DAX measure changes.
• 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.

Skills

Power BI

SQL

Stakeholder communication

Education

Bachelor's degree in a relevant field

Tools

Microsoft Fabric

Git

Python

Power Automate

AI tools

Job description

About PrePass

PrePass® is North America's most trusted weigh station bypass and toll management platform. We’re transforming how the transportation industry operates—creating solutions that keep trucks moving safely, efficiently, and compliantly. This means making bold decisions and building systems that support not only fleets but the broader economy. It all starts with enabling commercial vehicles to keep rolling with seamless toll management, weigh station bypass, and safety solutions. It’s what we do best, and we do it to meet the demands of the road every day.

That’s why people join us: our solutions are implemented in real-time, on highways and interstates across the nation, helping fleets go farther, faster. This work challenges and rewards, presenting complex problems that need ambitious answers. We hire bold thinkers with a heart for impact, a passion for progress, and the optimism to shape the future of transportation.

About the Role

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.

How We Will Take Care of You

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