Senior Data & Business Intelligence Analyst

Department of Planning, Housing and Infrastructure NSW

Parramatta

Hybrid

AUD 133,000 - 147,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Department of Planning, Housing and Infrastructure NSW – Parramatta is seeking a Senior Data and Business Intelligence Analyst to lead enterprise analytics design and delivery for Crown Lands. You will shape data models, warehouses, and dashboards to enable trusted insights and strategic decision-making.

The role requires deep Kimball modelling, data warehousing, cloud analytics, and stakeholder engagement, with mentoring responsibilities across multidisciplinary teams.

Qualifications

  • Extensive experience in Kimball dimensional modelling, data warehousing, and enterprise analytics solution design.
  • Strong expertise in dashboard and visualisation development using modern BI platforms.
  • Experience designing and supporting cloud-based data platforms and data engineering solutions.
  • Advanced SQL and data transformation skills, with experience developing scalable data pipelines.
  • Demonstrated ability to engage with stakeholders, gather requirements, and translate business needs into technical solutions.
  • Strong understanding of data governance, quality management, testing, and reconciliation practices.
  • Excellent communication, problem-solving, and relationship-building skills.
  • Experience mentoring others and providing technical leadership within multidisciplinary teams.

Responsibilities

  • Lead the design, implementation, and optimisation of dimensional data models using Kimball methodology and industry best practices.
  • Develop and maintain enterprise data warehouses and analytics environments that support reporting, self-service analytics, and BI requirements.
  • Establish scalable data architectures that enable trusted information across the organisation.
  • Develop and support cloud-based data platforms, including data integration, transformation, storage, and orchestration.
  • Design robust data pipelines to ensure reliable, secure, and timely delivery of enterprise data assets.
  • Champion modern engineering approaches to improve platform performance and maintainability.
  • Design, develop and support dashboards, reports, and visualisations that provide timely insights.
  • Translate complex business requirements into intuitive reporting solutions and enable data storytelling for stakeholders.
  • Mentor team members in data modelling, analytics engineering, and reporting practices.

Skills

Kimball dimensional modelling
Data warehousing
Enterprise analytics
Dashboard & visualisation development
Cloud-based data platforms
SQL
Stakeholder engagement
Data governance
Mentoring
Communication

Education

Tertiary qualifications in Information technology or relevant field

Job description

Senior Data & Business Intelligence Analyst

Department of Planning, Housing and Infrastructure NSW – Parramatta NSW

Help Shape the Future of NSW's Crown Land

  • Senior Data and Business Intelligence Analyst, Crown Lands
  • Ongoing Full Time Opportunity
  • Office location – Parramatta, with flexible working supported
  • Salary relative to experience, and ranges from $133,348 to $146,945 + super

Are you passionate about transforming complex data into meaningful business insights? Do you thrive on designing data models that become the foundation of enterprise reporting and decision-making?

We are seeking an experienced Senior Data and Business Intelligence Analyst to lead the design and delivery of enterprise analytics solutions. This is an exciting opportunity for a highly skilled data professional who combines deep technical expertise in Kimball dimensional modelling, data warehousing, cloud analytics, and dashboard development with a strong commitment to stakeholder engagement and business outcomes.

What You’ll Be Doing

Design Enterprise Data Solutions

  • Lead the design, implementation, and optimisation of dimensional data models using Kimball methodology and industry best practices.
  • Develop and maintain enterprise data warehouses and analytics environments that support reporting, self-service analytics, and business intelligence requirements.
  • Establish scalable data architectures that enable consistent, trusted, and accessible information across the organisation.

Build Modern Data Platforms

  • Develop and support cloud-based data platforms, including data integration, transformation, storage, and orchestration capabilities.
  • Design robust data pipelines that ensure reliable, secure, and timely delivery of enterprise data assets.
  • Champion modern engineering approaches to improve platform performance, scalability, and maintainability.
  • Design, develop, and support enterprise dashboards, reports, and visualisations that provide timely and actionable insights.
  • Translate complex business requirements into intuitive and impactful reporting solutions.
  • Enable stakeholders to make informed decisions through meaningful data storytelling and visual analytics.

Drive Data Innovation & Business Outcomes

  • Analyse complex datasets to identify trends, opportunities, risks, and recommendations.
  • Partner with business stakeholders to understand strategic priorities and deliver solutions that create measurable value.
  • Contribute to the development of enterprise analytics capability and continuous improvement initiatives.

Ensure Data Quality & Governance

  • Lead data quality, testing, reconciliation, validation, and governance activities.
  • Develop and maintain technical documentation, metadata, and data standards.
  • Promote trusted information assets and effective knowledge sharing across teams.

Provide Technical Leadership

  • Mentor and support team members in data modelling, analytics engineering, and reporting practices.
  • Contribute to project delivery, solution design, and enterprise data strategy initiatives.
  • Drive the adoption of modern analytics, DevOps, automation, and best‑practice delivery methodologies.

For more information read the full Role Description:Senior Data and Business Intelligence Analyst

What you will bring to the role

  • Extensive experience in Kimball dimensional modelling, data warehousing, and enterprise analytics solution design.
  • Strong expertise in dashboard and visualisation development using modern business intelligence platforms.
  • Experience designing and supporting cloud-based data platforms and data engineering solutions.
  • Advanced SQL and data transformation skills, with experience developing scalable data pipelines.
  • Demonstrated ability to engage with stakeholders, gather requirements, and translate business needs into technical solutions.
  • Strong understanding of data governance, quality management, testing, and reconciliation practices.
  • Excellent communication, problem‑solving, and relationship‑building skills.
  • Experience mentoring others and providing technical leadership within multidisciplinary teams.
  • Tertiary qualifications in Information technology or relevant field or equivalent experience.
  • Current Australian Driver’s Licence with a willingness and the ability to travel within NSW.

About us

The Department of Planning, Housing and Infrastructure (DPHI) improves the liveability and prosperity of NSW. To achieve this, we: create vibrant, productive spaces and precincts; manage lands, assets and property effectively and deliver affordable and diverse housing. We strive to be a high‑performing, world‑class public service organisation that celebrates and reflects the full diversity of the community we serve and builds the cultural capability of our department to improve outcomes with and for Aboriginal people, communities and entities.

We are an inclusive and accessible workplace, where your individual contributions are valued, and where everyone is encouraged to feel a sense of connection and belonging. DPHI supports various employee affinity groups, practices flexible working, offers job share and workplace adjustments.

Should you require further information about the role please contact Shyam Sreeramula via ***************@crownland.nsw.gov.au

We encourage and support applications from people with disability. Please reach out to us to discuss any accommodations or adjustments that may be needed during the recruitment process (including an alternate format of the application form), ensuring that you have every opportunity to showcase your talent, skills, and potential. Contact the Talent Team via ***************@dpie.nsw.gov.au or (02) 63637*** - HR Support, option 2, DPHI People Advisory, option 1 and reference 'Request an Adjustment - Job Title and Reference Number'.

Check out ourAboriginal applicants guideto assist with applying for the role or contact ourAboriginal CareerPathwaysteam for a yarn.

Please note to be eligible to apply for this position you must be an Australian or New Zealand citizen or permanentresident orhold a valid Australian working Visa for the duration of the appointment.This role is subject to standard pre‑employment checks, including a criminal record check.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data & Business Intelligence Analyst
Senior Data & Business Intelligence Analyst

NSW Department of Planning, Housing and Infrastructure • Sydney

Hybrid
AUD 133,000 - 147,000
Flexible working
Parramatta office
Senior Data Scientist
Senior Data Scientist

NSW Department of Planning, Housing and Infrastructure • Sydney

Hybrid
AUD 129,464 - 142,665
Flexible work arrangements
Career support programs
Access to wellbeing initiatives
Manager Digital Initiatives & Applications Support
Manager Digital Initiatives & Applications Support

NSW Department of Planning, Housing and Infrastructure • Newcastle

Hybrid
AUD 149,739 - 173,174
Flexibility in work arrangements
Diverse and fulfilling assignments
Work/life balance initiatives
Senior Manager
Senior Manager

Department of Planning, Housing and Infrastructure NSW • Parramatta

Hybrid
AUD 156,000 - 181,000
Senior Customer Service Officer (Talent Pool)
Senior Customer Service Officer (Talent Pool)

Department of Planning, Housing and Infrastructure NSW • Dubbo

On-site
AUD 103,000 - 114,000
Senior Natural Resource Management Officer
Senior Natural Resource Management Officer

Department of Planning, Housing and Infrastructure NSW • Ballina Shire

On-site
AUD 103,000 - 114,000
Group Leader Property Management
Group Leader Property Management

Department of Planning, Housing and Infrastructure NSW • Queanbeyan-Palerang

On-site
AUD 133,000 - 147,000
Senior Customer Service Officer (Talent Pool)
Senior Customer Service Officer (Talent Pool)

Department of Planning, Housing and Infrastructure NSW • Grafton

On-site
AUD 103,000 - 114,000
Senior Registered Surveyor
Senior Registered Surveyor

Department Of Planning, Housing And Infrastructure Nsw • Orange City Council

On-site
AUD 129,000 - 143,000
Senior Policy Officer
Senior Policy Officer

Department of Planning, Housing and Infrastructure NSW • Parramatta

Hybrid
AUD 143,000 - 153,000
Top locations