Senior Data Analyst

the original; Sydney; Hybrid; AUD 133,000 - 147,000; Full time

Job summary

NSW Fair Trading is seeking a Senior Data Analyst to drive data transformation and migration within major digital and platform modernisation initiatives. You will understand data structures, assess quality, define transformation rules, and support end-to-end migration to ensure data is accurate and trusted.

Collaborate with business and technical stakeholders to design end-to-end mappings, implement quality controls, and develop dashboards to enable data-driven decisions.

Qualifications

• Extensive experience with large-scale data migrations.
• Hands-on ETL with industry tools (Informatica, SSIS).
• Advanced SQL and data analysis with attention to data quality.

Responsibilities

• Design, document, and manage end-to-end data mappings for complex integrations.
• Profile, map, cleanse and reconcile data during migration.
• Support dashboards and analytics for data-driven decisions.

Skills

ETL concepts

Informatica

SSIS

SQL

Python

PySpark

AWS

AWS Glue

Amazon S3

Salesforce migrations

Tools

Informatica

SSIS

AWS Glue

Amazon S3

Salesforce

Job description

Senior Data Analyst

Clerk Grade: 9/10 - The package includes base salary ranging from $133,348 to $146,945 plus employer 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.

Are you 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 —

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.

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 starting at $133,348 base plus superannuation.

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

Careers at Department of Customer Service

A career at the Department of Customer 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].

For more information, please visit

Information on some of the different types of disabilities

Information on adjustments available for the recruitment process