Senior Data Analyst

NSW Government; Sydney; Hybrid; AUD 133,000 - 147,000; Full time

Benefits offered by this job

Hybrid working arrangements

Talent pool

Job summary

NSW Fair Trading is recruiting a Senior Data Analyst to enable data transformation and end‑to‑end migration as part of major digital initiatives. The role collaborates with Data Architect, Product Managers, Business Analysts and Engineers, embedding in data discovery, design, development and go‑live matters.

The team focuses on robust data governance, quality, and insight, with a hybrid Sydney/Wynard arrangement and a clear path to business impact across regulation and consumer markets.

Qualifications

• Extensive experience delivering large‑scale technology data migrations.
• Deep knowledge of ETL concepts with hands‑on experience using Informatica and SSIS to design scalable pipelines.
• Advanced SQL and data analysis expertise with focus on accuracy and integrity.
• Experience with AWS services including AWS Glue and S3 for data engineering and analytics.
• Python/PySpark experience is a plus but not essential.
• Exposure to Salesforce platform migrations is advantageous.
• Commitment to data governance, security and regulatory compliance.
• Ability to manage multiple deliverables across a multi‑project environment.

Responsibilities

• Data transformation and migration: design, document, and manage end‑to‑end mappings for complex system integrations.
• Data quality, validation and assurance: model data and datasets to meet business rules and regulatory obligations.
• Analytics and insight: support performance monitoring and benefits measurement with dashboards and reports.
• Business and stakeholder engagement: translate data issues into clear impacts and recommendations for non‑technical stakeholders.
• Governance, standards and continuous improvement: maintain data quality and governance with privacy and security requirements.
• Collaboration & agile delivery: shape requirements with cross‑functional teams and support migration test phases and go‑live.

Skills

Data migrations

ETL

SQL

AWS

Python

Salesforce migrations

Tools

Informatica

SSIS

AWS Glue

Salesforce migrations

Job description

Senior Data Analyst

Clerk Grade: 9/10 - The package includes base salary ranging from $133,348 to $146,945 plusemployer superannuation contributions and annual leave loading

Employment Type: Full-time (35 hrs per week), 12-month Temporary Opportunity

Location: 4 Parramatta Square (base) and Haymarket, Sydney as required from time to time. This role offers hybrid working arrangements, subject to team needs and DCS flexible work policies.

Be Part Of The Future Of Fair Trading

At NSW Fair Trading, we’ve been on an exciting journey of transformation — re‑imagining how we deliver for the people and communities of NSW. Through our recent organisational realignment, we’ve built a new operating model designed to put customers at the centre of everything we do, strengthen our regulatory impact, and enable our people to thrive. We’re creating a more modern, responsive and risk‑based Fair Trading — one that understands the needs of people and businesses, embraces collaboration and innovation, and delivers better outcomes across the rental, strata, property and consumer markets we serve. This next phase brings new and exciting opportunities to join us in shaping “the new way” — where you can help design smarter regulation, improve customer experiences, and make a real difference for the people of NSW.

If you’re someone who:

• Thinks deeply about the needs of people and communities,
• Is motivated by great outcomes, not just processes, and
• Wants to be part of an organisation that’s transforming how regulation works —

…then there’s a place for you in our future.

Join us as we build a Fair Trading that’s fit for the future — one that’s customer‑centred, evidence‑driven, and proudly focused on public value.

About the team

NSW Fair Trading is responsible for the administration of property and consumer protection laws in NSW. The Fair Trading Digital team works collaboratively with key internal and external stakeholders to provide the best digital solutions for our customers. The team requires robust data transformation and analytical practices across the Salesforce platform and its integrated ecosystem.

About the role

The Senior Data Analyst plays a critical role in enabling successful data transformation and migration as part of major digital and platform modernisation initiatives. The role is responsible for understanding data structures, assessing data quality, defining transformation rules, and supporting end‑to‑end data migration activities to ensure data is accurate, trusted, and fit for use. The role also provides targeted analytical insights to support migration decisions, validate outcomes, and enable business confidence in transformed data.

Working collaboratively with the Data Architect, Product Managers, Business Analysts and Engineers, the Senior Data Analyst will be embedded in all data related discovery, design, development, migration and go‑live matters.

Your Responsibilities:

Data transformation and migration: Design, document, and manage end‑to‑end source‑to‑target data mappings for complex system integrations, ensuring traceability and alignment with business and technical requirements. Be involved in all stages of data migration including profiling, mapping, cleansing and reconciliation.

Data quality, validation and assurance: Design and maintain data models and datasets that ensure data outcomes meet agreed business rules, regulatory obligations, operational and analytics needs. Identify data quality issues, root causes, and remediation strategies in collaboration with business and technical stakeholders. Support defect analysis and triage related to migrated or transformed data.

Analytics and insight: Support performance monitoring and benefits measurement, and contribute to dashboards or reports that enable data‑driven decisions.

Business and stakeholder engagement: Work with business subject‑matter experts to understand how data is used in current and future processes. Translate complex data issues into clear impacts, options, and recommendations for non‑technical stakeholders. Support business readiness by helping stakeholders understand changes to data, definitions, and availability, because of migration.

Governance, standards and continuous improvement: Maintain data quality and governance, meeting privacy, security and other requirements. Provide clear data advice, insights and improvements to business and technical stakeholders.

Collaboration & agile delivery: Partner with program, product and engineering leads to shape requirements and delivery priorities. Provide end‑to‑end support across migration test phases, go‑live, and post‑implementation hypercare, ensuring service stability and structured handover to BAU operations. Participate in Agile ceremonies including sprint planning, backlog refinement, daily standups, and retrospectives.

To be successful in this role you will demonstrate:

• Extensive experience delivering large‑scale technology data migrations
• Deep knowledge of ETL concepts with hands‑on experience using industry‑leading tools, such as Informatica and Microsoft SSIS, to design and implement robust, scalable data pipelines.
• Advanced SQL and data analysis expertise, with exceptional attention to detail and a strong focus on data accuracy, completeness, and integrity.
• Experience with AWS services including AWS Glue, Amazon S3, and other cloud‑native data engineering and analytics solutions.
• Experience working with Python/Pyspark is highly regarded but not essential.
• Exposure to Salesforce platform migrations is highly favoured but not essential.
• Demonstrated commitment to data governance, security, and regulatory compliance.
• Demonstrated capability to successfully manage and prioritise multiple deliverables simultaneously across a multi‑project environment.
• Work habits that prioritise outcomes, through commitment to speed, flexibility and quality of deliverables with minimal supervision.
• Experience with, or ability to adapt to NSW Government practices and standards.

Salary Grade 9/10, with the base salary for this role startingat $133348 base plus superannuation

A talent pool may be created as part of this recruitment process and will be valid for up to 18 months. The talent pool may be used to fill future ongoing or temporary vacancies of the same or similar role.

Closing Date: Thursday, 5 November 2026 at 11:59 pm

Careers at Department of Customer Service

A career at the Department ofCustomer Service (DCS) gives you the opportunity to help improve government services and be part of reform that benefits people across NSW. We are focused on delivering excellent customer service, digital transformation, and regulatory reform. Come join us and influence the future of our great state.

Belong in our diverse and inclusive workplace

The strength of our workforce lies in its diversity and embracing difference, while the key to our success is leveraging the contributions of employees with different backgrounds and perspectives.

You can view our full diversity and inclusion statement here.

We provide adjustments to the recruitment process for candidates, including individuals with disability. If you require an adjustment during the recruitment process, including alternate formats or have questions about the support available, please contact Talent Operations on 02 8276 8130 or [e-mail].

Information on some of the different types of disabilities

Information on adjustmentsavailable for the recruitment process