BI Analyst

PrePass•Phoenix, AZ

1d•Remote

About The Position

PrePass is seeking a BI Analyst to join its Business Intelligence team and report to the Manager of Business Intelligence. The role translates data into actionable insights that support company-wide business decisions, working with business and technical stakeholders to understand their goals and deliver meaningful analysis. The position is primarily remote, with occasional visits to the downtown Phoenix office. The analyst gathers, interprets, and reports on tolling, bypass, device, and customer data; develops and maintains Power BI reports and dashboards; supports data quality and troubleshooting; and documents reports, metrics, and data lineage. The role also uses AI-assisted workflows for reporting and documentation, verifies AI outputs, and contributes to process improvement and collaboration across the BI team.

Requirements

At least 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, including joins, aggregations, CTEs, and 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.

Nice To Haves

Experience with Microsoft Fabric, including lakehouses, warehouses, or notebooks, or with a medallion (Bronze/Silver/Gold) data architecture.
Experience using AI tools such as Microsoft Copilot, Claude, or 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.

Responsibilities

Gather, analyze, and interpret data to provide insights and recommendations to stakeholders.
Provide 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.
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 accuracy, reliability, and accessibility.
Document reports, metric definitions, and data lineage in Confluence.
Use AI-assisted workflows to translate business questions into reporting artifacts, including semantic model changes, DAX, and documentation, and validate outputs for accuracy and policy compliance.
Incorporate AI tools into routine reporting and documentation, write and refine prompts, and begin applying simple agentic tools to well-defined tasks under guidance.
Review AI outputs for accuracy, ask informed questions, and identify relevant AI use cases.
Gather and document business requirements for reporting and analytics initiatives.
Look for ways to improve personal workflows and reporting processes.
Collaborate across the BI team toward shared goals and mentor teammates one-on-one as opportunities arise.

Benefits

Medical, dental, and vision benefits beginning on the date of hire.
Paid time off including vacation, sick time, holidays, and floating holidays.
401(k) plan with employer match.
Company-funded lifestyle account for physical and mental well-being.
Tuition reimbursement program.
Voluntary benefits, including legal and pet discounts.
Employee Assistance Program at no cost.
Company-sponsored and funded Culture Team focused on employees’ physical, mental, and professional well-being.
Community give-back initiatives.
Employee development initiatives.