Business Intelligence Analyst - ProVision

ProVision; City of Monash; Hybrid; AUD 90,000 - 130,000; Full time

Benefits offered by this job

On-site parking

Employee Assistance Program

Job summary

ProVision is seeking an experienced Business Intelligence Analyst to take ownership of ProIntel, ensuring reliability, accuracy and ongoing development while balancing operations with reporting improvements and analytics projects.

You will work hands-on in Power BI and SQL, translating business needs into practical reporting, dashboards and data models, and collaborating with practice owners and internal teams.

Qualifications

• At least five years’ experience in BI or data analytics in a medium to large organisation.
• Strong capability in Power BI and SQL with practical reporting and analytics delivery.
• Experience translating business requirements into reports, dashboards and data models.

Responsibilities

• Administering Power BI and Microsoft Fabric environments, including workspaces, access, refreshes and row-level security.
• Developing reports, dashboards, DAX measures and semantic models.
• Maintaining SQL-based data models, ETL processes, API connections and scheduled data loads.
• Managing monthly benchmarking, reconciling practice data and resolving data-quality issues.
• Translating business requirements into practical reporting and analytics solutions.
• Coordinating external development work and supporting testing and implementation.
• Maintaining data governance, technical documentation and well-structured datasets for future analytics and AI initiatives.

Skills

Power BI

SQL

DAX

Semantic modelling

Row-level security

ETL processes

Data governance

API integrations

Python

R

Education

Relevant tertiary qualifications or industry certifications

Tools

Microsoft Fabric

Azure

AWS

APIs

Python

R

Job description

Business Intelligence Analyst - ProVision

Good business intelligence does more than explain what happened. It helps independent businesses decide what to do next.

ProVision supports a network of independent optometry practices across Australia. Through ProIntel, our business intelligence and benchmarking platform, we help practice owners, Business Coaches and internal teams turn complex data into clearer insights and better-informed decisions.

We’re looking for an experienced Business Intelligence Analyst to take ownership of the reliability, accuracy and continued development of ProIntel, balancing day‑to‑day platform operations with reporting improvements and new analytics projects.

This is a hands‑on and highly collaborative role. You’ll need strong Power BI and SQL capability, along with the communication skills to understand business needs, explain complex information clearly and build effective relationships with both ProVision team members and independent practice owners.

The role

Your work will include:

• Administering Power BI and Microsoft Fabric environments, including workspaces, access, refreshes and row‑level security
• Developing reports, dashboards, DAX measures and semantic models
• Maintaining SQL‑based data models, ETL processes, API connections and scheduled data loads
• Managing monthly benchmarking, reconciling practice data and resolving data‑quality issues
• Translating business requirements into practical reporting and analytics solutions
• Coordinating external development work and supporting testing and implementation
• Maintaining data governance, technical documentation and well‑structured datasets for future analytics and AI initiatives

What you’ll bring

You’ll bring at least five years’ experience in a similar business intelligence or data analytics role within a medium to large organisation, including strong practical capability in Power BI and SQL.

You’ll also need the analytical judgement to question the data, investigate the cause of an issue and determine whether the answer makes sense, not simply whether the report refreshes successfully.

• Strong Power BI capability, including DAX, Power Query, semantic modelling and row‑level security
• Strong SQL Server and T‑SQL capability
• Experience with ETL processes, data pipelines and data warehouse structures
• The ability to investigate data issues and deliver accurate, defensible reporting
• Strong stakeholder communication and the ability to explain technical information clearly
• A structured approach to requirements gathering, testing, documentation and project delivery

Experience with Microsoft Fabric, Azure or AWS analytics services, API integrations, Python or R, AI data preparation, privacy obligations or the Essential Eight will be highly regarded.

Relevant tertiary qualifications or industry certifications will also be well regarded but are not essential where equivalent practical experience can be demonstrated.

Why ProVision?

At ProVision, the work has a visible connection to the businesses we support. The reports, benchmarking measures and insights you develop will be used by independent practice owners to understand performance, identify opportunities and make decisions about their future.

You’ll join a collaborative Business Systems team, work across established and emerging technologies, and have the opportunity to influence how ProVision develops its analytics and AI capabilities.

You’ll also have access to:

• A hybrid working arrangement, typically including three days in our Mulgrave office and two days from home
• On‑site parking
• An Employee Assistance Program

If you want to own more than a dashboard, and see your analysis put to work across a national network of independent businesses, this is where the numbers start to mean something.