Senior Data Analyst

Council Jobs; Geelong; On-site; AUD 113,000 - 138,000; Full time

Job summary

The City of Geelong is seeking a data analyst to partner with the HRIS program team, defining data profiles, mappings and validation logic. You will support data migration, ensure data quality, and translate business needs into technical specifications for dashboards, reports and analytics.

Applicants should have a tertiary qualification in data analytics or a related field, experience with API-based integrations, SQL, and ETL processes, and a strong Agile mindset.

Qualifications

• Tertiary qualification in Data Analytics, Information Systems, Computer Science, Engineering.
• Experience with data migration and data quality in large projects.
• Experience with APIs and data integration.
• Strong analytical and problem-solving skills.

Responsibilities

• Analyse and document data, reporting, and integration requirements with stakeholders.
• Document data flows, business rules, and technical specs for solution design.
• Maintain data mapping, transformation rules for ETL and migrations.
• Support data migration planning, data quality validation, and cutover.
• Contribute to data architecture and API-based integration design.
• Develop BI requirements and translate to dashboards and reports.

Skills

SQL

APIs

Data migration

Data quality

Data analysis

Agile methodologies

Analytical thinking

Education

Tertiary qualification in Data Analytics / Information Systems / CS / Engineering

Tools

ETL tools

APIs

Job description

Job no: 500877
Work type: Fixed Term Full Time
Classification: Band 8 - $125,701.97 pa plus super
Categories: Digital Information & Technology

About the role

In this role, you will work closely with the program team and stakeholders to analyse data, reporting and integration requirements for the HRIS implementations. You’ll define data profiles, mappings, transformation rules and validation logic, support data migration activities, and collaborate with IT teams to ensure solutions align with enterprise architecture standards.

You’ll turn business needs into clear technical specifications and maintain rigorous data quality, playing an important role in delivering accurate, integrated systems that meet business objectives.

Work type: Fixed term, full time (18 months)
Classification: Band 8 at $125,701 pa plus super

Key responsibilities include:

• Analyse and document data, reporting, and integration requirements (including API specifications) in collaboration with business stakeholders.
• Analyse system integration and data requirements, documenting data flows, business rules, and technical specifications to support solution design and delivery.
• Document and maintain data mapping, transformation requirements, and validation rules for ETL processes and data migration activities.
• Support data migration planning and execution, including data quality validation, data remediation, and cutover activities.
• Contribute to data architecture and API-based integration design, translating business needs into technical specifications for dashboards, reports and analytics solutions.
• Develop and document reporting and business intelligence requirements, translating business needs into technical specifications for dashboards, reports, and analytics solutions
• Support key service transition activities including data cutover planning, release preparation, and go-live validation; contribute to risk and issues management related to data migration and integration

About you

To be successful in this role, you will have a tertiary qualification in Data Analytics, Information Systems, Computer Science, Engineering, or similar fields, with demonstrated progressional experience in data migration, data quality, and data analysis.

• Experience working across high-profile projects or programs involving multiple enterprise-wide, integrated and interrelated systems.
• Extensive experience identifying and documenting data mappings and data requirements.
• Extensive experience analysing complex data and presenting it clearly to support key decision-makers.
• Highly developed conceptual, analytical and problem-solving skills.
• Strong understanding of Agile principles and frameworks.
• Understanding how data flows via APIs or flat-file feeds (e.g. automated CSV/SFTP batch jobs) from upstream HRIS to downstream IdAM and enterprise applications (desirable).
• Experience using SQL to analyse, validate, and reconcile data across multiple systems, supporting data migration, transformation, and validation activities (desirable).

Preferred candidates will be required to undergo a National Police Check and a pre-employment medical assessment as part of the recruitment process (funded by the City).

Child Safety Responsibilities

We are committed to being a child-safe organisation and have zero-tolerance for child abuse. We have specific policies, procedures, and mandatory training in place to support employees, volunteers, and contractors to achieve and adhere to these commitments. Please read ourChild Safe Standards Management Policy.

Diversity and Inclusion

At the City we want a workforce that reflects the community we live in. We welcome and embrace everyone, all people with their own unique experiences, and support and encourage all our employees to do their best work, have equal access to opportunities and a just working environment. For this reason, we particularly welcome and encourage applications from First Nations people, people with diverse cultural and linguistic backgrounds, from the LGBTQIA+ community, people with disability and people of all genders, ages and diverse experience.

We are the City

From parks to offices, childcare centres to works depots, leisure facilities to the Wool Museum and waterfront, our team plays a vital role in shaping our vibrant and growing community. Our community counts on us to get the essentials right while looking for ways to go beyond. By listening, collaborating, and focusing on sustainability, we strive to do the basics brilliantly and create a lasting impact. If you’re ready to be part of something bigger, join us in shaping the future of Geelong.

We support accessibility and encourage discussions about any adjustments or support you may need during the recruitment process.

Applications and Enquiries

Enquiries: Nathan Rolph (Lead Business Analyst) | ************@geelongcity.vic.gov.au

We collect demographic data to help us learn who our advertisements are reaching and how we can reach an even more diverse audience. We are committed to building a more diverse team. Your responses to our demographic questions are strictly confidential and will not be individually shared.

#LI-Hybrid