Data & Reporting Analyst

Michael Page; Gold Coast City; On-site; AUD 103,000 - 117,000; Full time

Job summary

Michael Page on the Gold Coast is seeking a BI professional to design, build and maintain Power BI dashboards and reports for a Kingscliff-based role under a 6-month contract with hybrid work arrangements.

You will develop complex SQL queries, manage data in SQL Server, optimise data models, automate reporting, and respond to stakeholder requests while ensuring data quality.

Qualifications

• Advanced Power BI dashboard and report development.
• Strong SQL query writing and database analysis.
• Proficiency with SSMS and data interrogation.
• Power Query development and optimization.
• Experience with Report Builder.
• Advanced Excel skills and data manipulation.
• Data transformation, cleansing and modelling.
• Automation of reporting and scheduling processes.
• Strong analytical and problem-solving capabilities.

Responsibilities

• Design, build and maintain Power BI dashboards and reports.
• Develop complex SQL queries and work with SQL Server databases.
• Use SQL Server Management Studio (SSMS) to interrogate, validate and manage data.
• Create and optimise Power Query data models and transformations.
• Develop and maintain Report Builder reports.
• Automate recurring reporting and scheduling processes.
• Analyse large and complex datasets and identify trends, risks and opportunities.
• Respond to ad hoc data requests and stakeholder enquiries.
• Ensure data integrity, accuracy and quality across reporting outputs.
• Contribute to continuous improvement of analytics tools, systems and processes.

Skills

Power BI

SQL

SSMS

Power Query

Report Builder

Excel

Data transformation

Scheduling

Analytics

Tools

SSMS

SQL Server

Power BI Desktop

Job description

Key Responsibilities

• Design, build and maintain Power BI dashboards and reports.
• Develop complex SQL queries and work with SQL Server databases.
• Use SQL Server Management Studio (SSMS) to interrogate, validate and manage data.
• Create and optimise Power Query data models and transformations.
• Develop and maintain Report Builder reports.
• Automate recurring reporting and scheduling processes.
• Analyse large and complex datasets and identify trends, risks and opportunities.
• Respond to ad hoc data requests and stakeholder enquiries.
• Ensure data integrity, accuracy and quality across reporting outputs.
• Contribute to continuous improvement of analytics tools, systems and processes.

Gold Coast / Kingscliff based role. 3/2 hybrid environment6 month initial contract, with view to extend

Key Responsibilities

• Design, build and maintain Power BI dashboards and reports.
• Develop complex SQL queries and work with SQL Server databases.
• Use SQL Server Management Studio (SSMS) to interrogate, validate and manage data.
• Create and optimise Power Query data models and transformations.
• Develop and maintain Report Builder reports.
• Automate recurring reporting and scheduling processes.
• Analyse large and complex datasets and identify trends, risks and opportunities.
• Respond to ad hoc data requests and stakeholder enquiries.
• Ensure data integrity, accuracy and quality across reporting outputs.
• Contribute to continuous improvement of analytics tools, systems and processes.

Gold Coast / Kingscliff based role. 3/2 hybrid environment6 month initial contract, with view to extend

The Ideal Candidate

The successful candidate will be an exceptional communicator who can confidently engage with technical and non-technical stakeholders. They will be highly organised, capable of managing competing priorities and comfortable handling large volumes of data requests. The ideal person learns quickly, adapts to changing business needs, thinks proactively and takes ownership of delivering high-quality outcomes.

Technical Skills Required

• Advanced Power BI report and dashboard development
• Advanced SQL query writing and database analysis
• Microsoft SQL Server Management Studio (SSMS)
• Power Query development and optimisation
• Report Builder
• Advanced Microsoft Excel
• Data transformation, cleansing and modelling
• Report automation and scheduling
• Strong analytical and problem-solving capability

A public sector organisation based in Kingscliff, dedicated to serving the community through data-driven initiatives.

• Hourly pay rate of $75 - $85 AUD.
• Contract position offering flexibility and valuable experience in the public sector.
• Opportunity to work in Kingscliff, contributing to meaningful analytics projects.