Business Intelligence Consultant

Kaizen Global Technologies; Cooma; On-site; AUD 120,000 - 170,000; Full time

Job summary

Kaizen Global Technologies is seeking a Senior BI & Reporting Analyst to own data extraction, validation, and consolidation across SAP, SharePoint Online, and project systems. You will design and maintain Power BI dashboards and executive scorecards for weekly to quarterly reporting, driving data-driven insights.

The role requires 10+ years in BI/analytics, advanced Excel, strong Power BI skills, and experience with SAP/SharePoint data sources.

Qualifications

• 10+ years of experience in reporting, BI, data analytics, project controls or related field.
• Experience in a project-based enterprise environment is preferred.
• Advanced Excel with Power Query, PivotTables and data models.
• Strong Power BI skills including data modelling, DAX and dashboards.
• Experience extracting/reporting data from SAP and SharePoint Online.
• Strong data validation, reconciliation, analytical and stakeholder management skills.
• Excellent communication and process improvement capabilities.

Responsibilities

• Extract, validate, and consolidate data from SAP, SharePoint Online, Primavera P6, Aconex, Contruent, Revit, Excel, and other systems.
• Develop and maintain Power BI dashboards, executive scorecards, and periodic reports.
• Analyse project, financial, resource, quality, and schedule data to identify trends and risks.
• Reconcile data across systems to ensure accuracy and consistency.
• Maintain reporting documentation, data definitions, and access controls.
• Collaborate with business and IT teams to automate reporting using Power Query, Power Automate, SQL, Microsoft Fabric, and related tools.
• Drive reporting process improvements and support data-driven decision-making.

Skills

BI analytics

Reporting

Data analytics

Project controls

Power BI

Excel (Advanced)

Data validation

Stakeholder management

Tools

SAP

SharePoint Online

Primavera P6

Aconex

Contruent

Revit

Power Query

SQL

Microsoft Fabric

API integrations

Job description

We’re Hiring: Senior BI & Reporting Analyst

We are looking for an experienced Senior BI & Reporting Analyst with strong expertise in Business Intelligence, Data Analytics, Reporting, and Project Controls.

Location: Cooma, NSWRoster: 5/2

FIFO: Open to candidates willing to FIFO from Sydney, Melbourne or Brisbane

Experience: 10+ years

Key Responsibilities

• Extract, validate, and consolidate data from SAP, SharePoint Online, Primavera P6, Aconex, Contruent, Revit, Excel, and other business systems.
• Develop and maintain Power BI dashboards, executive scorecards, and weekly, monthly, and quarterly reports.
• Analyse project, financial, resource, quality, and schedule data to identify trends, risks, and opportunities.
• Reconcile data across systems and ensure data accuracy and consistency.
• Maintain reporting documentation, data definitions, and access controls.
• Collaborate with business and IT teams to automate reporting using Power Query, Power Automate, SQL, Microsoft Fabric, and related tools.
• Drive reporting process improvements and support data-driven decision-making.

Required Skills & Experience

• 10+ years of experience in reporting, BI, data analytics, project controls, or a related field.
• Experience in a project-based enterprise environment is preferred.
• Advanced Excel, including Power Query, PivotTables, and data models.
• Strong Power BI skills, including data modelling, DAX, and dashboard development.
• Experience extracting and reporting data from SAP and SharePoint Online.
• Strong data validation, reconciliation, analytical, and stakeholder management skills.
• Excellent communication and process improvement capabilities.

Good to HaveExperience with Primavera P6, Aconex, Contruent, ECTR, Revit, SQL, Microsoft Fabric, or API integrations will be highly desirable.