Senior Data Analyst: Data Migration & Transformation

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

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.