Business Intelligence Specialist

Medhealth Dba; Geelong; Hybrid; AUD 90,000 - 130,000; Full time

Benefits offered by this job

Hybrid work model

Contract till end of December 2026

Job summary

Federal Government Agency in Geelong is seeking an experienced Data Analyst to support transformation portfolios by consolidating multiple source registers into a single, validated dataset. You will work across a range of artefacts to create a consistent view of active initiatives and ensure data quality and traceability.

The role requires strong analytical capability, attention to detail, and experience with Excel-based registers, large datasets, and documenting reconciliation logic.

Qualifications

• Strong data analytics and interpretation skills.
• Advanced SQL proficiency with large datasets.
• Experience using SAS Enterprise Guide and SAS Viya.
• Ability to document data reconciliation and governance processes.
• Excellent communication of complex insights to varied audiences.

Responsibilities

• Conduct complex data analysis and investigative activities to support objectives.
• Manage day-to-day analytical tasks including reporting and ad hoc requests.
• Analyze large datasets to identify trends, risks, opportunities, and insights.
• Develop and maintain reports, dashboards, and performance metrics.
• Contribute to data governance, quality assurance, and integrity processes.
• Interpret findings and provide evidence-based recommendations to stakeholders.
• Collaborate across the agency to ensure consistent data usage and messaging.
• Present outcomes to technical and non-technical audiences.
• Support stakeholder engagement and build relationships.
• Mentor junior analysts and promote best practices.
• Support project delivery and strategic initiatives within risk and integrity functions.

Skills

Advanced SQL

Python

R

Data interpretation

Tools

SAS Enterprise Guide

SAS Viya

Job description

• What Business Intelligence Specialist Jobs ar...

Showing 170 Business Intelligence Specialist jobs in Geelong

Business/Data Analyst

3220 Geelong Davidson

Posted 2 days ago

Job Description

About the Company
Our client is a reputable government organisation.
About the Role
Seeking an experienced Business Analyst / Data Analyst to support a transformation portfolio by consolidating multiple source registers into a single, validated and traceable dataset.
ou will work across a range of portfolio and project management artefacts to create a consistent and reliable view of the organisation’s active initiatives.
The successful candidate will be highly analytical, detail-oriented and comfortable working with complex Excel-based registers and inconsistent source data. You will be expected to identify, document and upscale discrepancies for management validation, ensuring that data conflicts are clearly recorded rather than hidden or independently resolved.

Key responsibilities

• Develop a master initiative crosswalk reconciling names and identifiers across multiple source registers.
• Bring together schedule, risk, issue, benefits, status and forecast data under common initiative identifiers.
• Reconcile the initiative population against an agreed inclusion rule and document any exceptions.
• Populate initiative baseline templates for all active initiatives, including:
  • Baseline dates
  • Dependencies
  • Resource requirements
  • Key delivery information
• Validate and relink schedule dependencies, including predecessor and successor relationships.
• Review risk and issue registers for completeness, including ownership, review dates and status.
• Assess risk and issue information against the organisation’s risk framework and RAID conventions.
• Reconcile the financial reporting bases currently in use and document the basis supporting each reported figure.
• Review status and health indicators to ensure they accurately reflect underlying delivery performance.
• Identify and log data conflicts between source registers for management review.
• Maintain a data quality tracker documenting fields, sources, issues and remediation status.
• Prepare a concise handover briefing outlining residual gaps, assumptions and outstanding matters.
• Master initiative crosswalk.
• Individual-level initiative baseline template for all active initiatives.
• Re-linked master schedule with dependency integrity checked.
• Data quality tracker and reconciliation log.
• Handover briefing note summarising residual gaps and assumptions.

About You

• Demonstrated experience integrating and reconciling data from multiple, inconsistent source systems.
• Strong Excel skills, including formulas, pivot tables and data validation.
• Experience using Power Query, or an equivalent tool, to merge and manage large datasets.
• Working knowledge of project and portfolio management artefacts, including schedules, RAID logs, benefits registers and baselines.
• Strong attention to detail and a clear focus on data quality, consistency and traceability.
• The ability to identify and document discrepancies without concealing or independently resolving them.
• Strong written communication skills, particularly when documenting assumptions, gaps and reconciliation logic.
• The ability to manage commercially sensitive portfolio information with discretion.

The Benefits

• Initial contract till end of December 2026 with view to extend
• Hybrid

About the company:
This Federal Government agency works to deliver programs and services that support people with disability and their families, aiming to improve access, engagement, and outcomes across Australia. The agency collaborates closely with communities, service providers, and government stakeholders to implement initiatives that enhance social inclusion, wellbeing, and equity.
About the Team
The team plays a critical role in supporting the agency's risk and integrity functions through advanced data analysis, reporting, and evidence-based insights. Working in a highly collaborative environment, the team partners with stakeholders across business areas to identify trends, manage risks, improve decision-making, and support strategic priorities. Team members contribute to complex projects that help drive operational excellence and deliver meaningful outcomes for Australians.
About the Role
An exciting opportunity exists for an experienced Data Analyst to join the agency. This role requires a highly capable professional who can work independently on complex analytical activities, provide strategic insights, and support decision-making through data-driven recommendations.
The successful candidate will undertake detailed analytical work, manage competing priorities, and contribute to projects that influence both operational and strategic outcomes. You will collaborate with a wide range of stakeholders, present findings to diverse audiences, and provide guidance to junior team members.
This is an excellent opportunity for someone who enjoys solving complex problems, working with large datasets, and translating data into meaningful insights that drive organisational outcomes.

Key Responsibilities

• Conduct complex data analysis, reporting, and investigative activities to support business objectives.
• Manage day‑to‑day analytical tasks, including regular reporting, project work, and ad hoc requests.
• Analyse large and complex datasets to identify trends, risks, opportunities, and business insights.
• Develop and maintain reports, dashboards, and performance metrics.
• Contribute to reporting governance, quality assurance, and data integrity processes.
• Interpret analytical findings and provide evidence‑based recommendations to stakeholders.
• Collaborate with teams across the agency to ensure consistent data usage, reporting, and messaging.
• Present analytical outcomes and insights to both technical and non‑technical audiences.
• Support stakeholder engagement and build strong internal and external relationships.
• Mentor and develop junior analysts, promoting best practices in data analysis and reporting.
• Support project delivery and contribute to strategic initiatives within the risk and integrity functions.

You Must Have

• Strong experience in data analytics and data interpretation.
• Advanced SQL skills and experience working with large datasets.
• Experience using analytics and reporting tools, ideally SAS Enterprise Guide (SAS EG) and/or SAS Viya.
• Strong problem‑solving skills with the ability to identify and resolve complex data‑related issues.
• Excellent critical thinking capabilities and the ability to make evidence‑based decisions.
• Strong communication skills, including the ability to explain complex data insights to both technical and non‑technical audiences.
• Proven ability to build productive stakeholder relationships and collaborate across multidisciplinary teams.
• Experience preparing reports, presentations, and briefing materials for senior stakeholders.
• Ability to manage multiple priorities and work effectively with a high degree of autonomy.
• Experience with Python and/or R programming languages.
• Knowledge of statistical analysis and machine learning techniques.
• Experience in fraud analytics, risk analytics, or integrity‑related environments