Business Intelligence Analyst

Temporary, full-time (up until August 2027) 

Turn data into insights that drive better decisions

• Develop engaging Power BI dashboards and reports used across Council

• Partner with business stakeholders to solve problems through data and analytics

• Enjoy flexible working including hybrid work, a 35-hour week and a 9-day fortnight

LET’S EXPLORE THE JOB 

Data plays a critical role in how Lake Macquarie City Council plans, delivers and improves services for our community.

We are seeking a Business Intelligence Analyst to develop and deliver reporting, dashboarding and analytics solutions that support operational and strategic decision-making across Council.

Working within our Data and Analytics Team, you will work closely with stakeholders to understand business needs, translate requirements into practical reporting solutions, and develop trusted Power BI dashboards and data models that deliver meaningful insights.

You'll be responsible for designing, developing and maintaining reporting solutions using Power BI, SQL and other analytics tools, ensuring data is accessible, reliable and supports informed decision-making.

This is an exciting opportunity to work across a wide range of business areas, helping teams use data more effectively while contributing to the ongoing maturity of Council's data and analytics capability. This role will primarily focus on business intelligence, reporting and stakeholder engagement, with exposure to broader analytics and emerging technologies where appropriate.

This exciting role will:  

• Developing and maintaining Power BI dashboards, reports and semantic models

• Working with stakeholders to gather, analyse and document reporting requirements

• Translating business needs into practical reporting and analytics solutions

• Creating clear and compelling data visualisations that support decision-making

• Developing and optimising SQL queries and data models

• Troubleshooting reporting and data quality issues

• Supporting the ongoing improvement of reporting standards, governance and data quality

• Providing advice and support to business users on reporting and analytics solutions

• Contributing to the continuous improvement of Council's analytics capability

Read the position statement here and learn more about this exciting opportunity.

LET’S HEAR ABOUT YOU 

You are an experienced business intelligence professional who enjoys working with stakeholders to understand business challenges and develop practical reporting solutions.

You combine strong technical skills with a customer-focused approach and are comfortable translating complex data into meaningful insights for technical and non-technical audiences.

You enjoy working collaboratively, solving problems and delivering high-quality reporting solutions that help drive informed decision-making.

You will bring: 

• Degree qualification in Information Technology, Data Analytics, Business Analytics or a related discipline (or equivalent experience)

• Demonstrated experience developing Power BI dashboards, reports and data models

• Strong SQL and data analysis skills

• Experience gathering and documenting business requirements

• Strong stakeholder engagement and communication skills

• Experience delivering reporting and analytics solutions in a business environment

• Strong problem-solving and analytical skills

• Experience with Microsoft Fabric, Azure Data Platform or Python will be highly regarded

LET’S REVEAL THE PERKS

This position provides:

• Competitive salary from $105,134 to $122, 182 per year + 12% superannuation

• Enterprise Agreement pay increases apply

• Commencing salary set in line with skills and experience with annual reviews available to support movement through the salary range

• 35-hour working week, across a nine day fortnight 

• Corporate fitness program from as little as $8 per week

CHOOSE THE LAKE MAC WAY 

We know it is our people that will shape the future of our city. That’s why we’re passionate about providing a workplace that empowers our staff to be creative, innovative and bold. When you join the team at Lake Macquarie City Council, you’re joining a group of people with a commitment to make our city even better. We’re proud of our city and the work we do, and we know you will be too.

We celebrate diversity and are committed to creating an inclusive workforce. We believe that a diverse network of employees, which truly reflects the people it serves and represents, is best equipped to understand and meet the needs of our community. We welcome and encourage applications from all ages and genders, Aboriginal and Torres Strait Islander peoples, people from culturally diverse backgrounds, the LGBTIQ+ community, refugees and people with disability. We understand the skills and attributes veterans can bring to our Council.

LET’S START 

• If this job sounds like you, we would love to hear from you! Get your application in by 11:59pm, Sunday 13 September 2026

• For enquiries related to the duties of the role, please contact Susanne Eggins, Coordinator Data and Analytics, on 02 •••• •107 or via email seggins@lakemac.nsw.gov.au

• If you need assistance submitting your application click here or please contact Ashlea Norris, Talent Attraction Partner, on 02 •••• •759 or via email alnorris@lakemac.nsw.gov.au

• Your experience throughout the application process matters to us. If you'd like feedback on your application or interview, don't hesitate to get in touch — we're here for you!

• To complete your online application, you will be asked to upload a copy of your resume and provide responses to questions which are based on the criteria listed in the Position Statement.

• Please note that as part of Lake Macquarie City Council’s recruitment process, prior to an offer of employment being made, recommended candidates may be subject to a medical assessment which may include alcohol and other drugs testing.