onsite
BI and Data Analyst - City of Perth
Data Analyst
Lead the City’s data strategy as a BI and Data Analyst, driving insights through Power BI, Tableau, and advanced SQL to inform citywide decisions and improve service delivery.
About the role
Key Responsibilities
- Design, develop, and maintain robust BI solutions using Power BI and Tableau to deliver actionable insights across city departments.
- Extract, transform, and load (ETL) complex datasets from diverse sources, ensuring data quality and integrity.
- Collaborate with stakeholders to translate business requirements into technical specifications and data models.
- Perform advanced SQL queries and data analysis to support strategic planning and operational improvements.
- Document data flows, metadata, and governance practices to maintain compliance and audit readiness.
Requirements
- Proven experience in BI development with Power BI and Tableau.
- Strong SQL skills and familiarity with relational database design.
- Hands‑on experience with ETL processes and data warehousing concepts.
- Excellent analytical, problem‑solving, and communication skills.
- Knowledge of data governance and privacy standards is a plus.
Skills
data analysissqlpower bitableau