Data and Reporting Analyst

As a Data and Reporting Analyst, you'll help our clients unlock the value of their data by designing, building and optimising business intelligence reports and dashboards that enable smart decision-making. You’ll work across a diverse range of digital projects and corporate applications, delivering new insights and enhancing existing systems.

Key Responsibilities

• Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
• Proficient with inspecting, cleansing, transforming, and analysing raw data to discover useful information, inform conclusions, and support effective decision-making.
• Responsible for designing and building scalable data models and enabling advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations.
• Ability to collaborate with key stakeholders to deliver relevant insights based on identified business requirements.
• Ability to work independently through unstructured tasks.
• Strong analytical skills, excellent attention to detail, strong interpersonal skills as well as written and verbal communication skills.

Qualifications / Experience

• Strong hands-on experience with Microsoft Power BI, including data modelling, DAX, and report development
• Familiarity with modern Microsoft data platforms, such as Microsoft Fabric and Azure Synapse / Data Lake
• Minimum 2 years’ experience in a data-specific role (e.g. business intelligence, analytics, reporting, or data engineering)
• Tertiary qualification in a relevant field (e.g. Data Analytics, Computer Science, Information Systems) or industry-recognised certification (e.g. Microsoft Certified: Data Analyst Associate)

Highly Desirable:

• Exposure to data integration tools (e.g. Azure Data Factory, Power Platform)
• Experience working within government, utilities, or regulated environments
• Understanding of data governance, security models, and self-service BI best practices
• Proficiency in SQL or scripting languages used for data prep and automation
• Strong communication skills and stakeholder engagement experience, especially in cross-functional teams
• NV1 Security Clearance.

About us

RPS is a market-leading consultancy delivering innovative digital solutions across Australia and beyond. Our Digital team is at the forefront of data transformation, partnering with government and enterprise clients to turn complexity into clarity through meaningful data and actionable insights.

We offer more than just a job, we offer a place to grow, be heard, and make a tangible impact.

What You Can Expect:

• Flexible and remote work options to support work–life balance and individual needs
• Competitive salary package aligned to experience and capability
• A genuinely collaborative team culture where curiosity, initiative and innovation are encouraged
• Ongoing professional development, with access to industry leaders, certifications and cross-disciplinary learning
• Opportunities to work on diverse, high-impact projects across digital, infrastructure, sustainability and the built environment
• Involvement in a team actively investing in Microsoft Fabric, AI and modern data platforms as part of its digital evolution