Data Analyst

Outsized; Sydney; Hybrid; AUD 90,000 - 120,000; Full time

Job summary

Outsized is seeking a Data Analyst to support the data remediation stream of a major migration program in Sydney. You will analyse customer and merchant data, identify anomalies and translate findings into business rules and system logic.

The role involves working across business, technology, operations and vendor teams to shape decisions and governance. You will automate pipelines using Python and SQL and build real-time dashboards with Power BI/Tableau/Streamlit, enabling stakeholders to track

Qualifications

• 2-4 years' experience as a Data Analyst or Analytics Specialist in financial services.
• Proven experience supporting data migrations, system transitions or remediation programs.
• Experience in regulated environments with strong data controls.

Responsibilities

• Conduct deep-dive analysis of customer, merchant, transaction and product data to support migration readiness.
• Analyse data anomalies, cluster issues, and uncover root causes and patterns.
• Lead data mapping between legacy and target systems and validate migration input files.
• Collaborate with business and technology SMEs to shape decisions and rules for exceptions.
• Produce artefacts like decision papers and remediation prioritisation.
• Automate data processing pipelines and reporting workflows using Python and SQL.
• Develop migration tracking tools and dashboards (Power BI, Tableau or Streamlit).
• Partner with product, operations, vendors, risk and data management teams for governance.

Skills

SQL

Python

Data Analysis

Data Visualisation

Job description

Experience Junior (0-5 years) | Mid Level (6-10 years)

Duration 6 Months

Hybrid

Sydney, Australia

Required Skills Merchant Acquiring SQL Data Analysis Python Data Visualisation

Project Overview

Requirement Description:

A major financial institution is seeking a Data Analyst to support the data remediation stream of a large-scale migration program. This role focuses on analysing customer and merchant data that didn't fit the standard migration process, whether due to hygiene issues, mismatches, missing values or translation rule gaps, and turning the patterns found into purposeful business rules and system logic. The analyst will play a critical role in shaping how exceptions are handled, both now and in the future.

Working across business, technology, operations and vendor teams, the Data Analyst will convert messy data into clear, actionable recommendations that support migration readiness and data governance. This is a continuously evolving role that suits someone with analytical sharpness, systems thinking and strong stakeholder skills.

Key Responsibilities

• Conduct deep-dive analysis of customer, merchant, transaction and product data to support migration readiness and identify remediation needs.
• Analyse data anomalies, cluster similar issues together and uncover root causes and recurring patterns.
• Lead data mapping between legacy and target systems, validate source-target mapping, and build and validate migration input files to support phased customer transitions.
• Collaborate with business and technology SMEs to shape decisions, business rules and system logic for exceptions.
• Produce artefacts such as decision papers, rule proposals and remediation prioritisation, and help build future-proofed logic that prevents the same issues recurring.
• Automate data processing pipelines and reporting workflows using Python and SQL, building modular, parameterised scripts for batch processing and auditing.
• Develop migration tracking tools, exception reports, risk flags and interactive dashboards (Power BI, Tableau or Streamlit) to give stakeholders real-time insight into remediation progress and migration waves.
• Partner with product, operations, vendors, risk, compliance and data management teams to ensure data integrity, accuracy and governance compliance, and translate technical outputs into clear, business-friendly documentation.

Your Background

Essential:

• 2-4 years' experience as a Data Analyst or Analytics Specialist in financial services.
• Proven experience supporting data migrations, system transitions or customer remediation programs.
• Experience in regulated environments with strong data controls (banking, insurance, telco, etc.).
• Experience working in a structured, fast-paced environment with multiple stakeholders.
• Advanced Python scripting for automation, ETL, remediation checks and data transformation.
• Expert-level SQL (Teradata, Oracle), including complex joins, CTEs, window functions and query optimisation.
• Experience building dashboards in Power BI, Tableau or Streamlit.
• Advanced Excel/Sheets skills (formulas, pivots, lookups) and proficiency in Git.
• Strong communicator who can present data-driven narratives to non-technical stakeholders, with a structured, organised and proactive approach.

Desirable:

• Exposure to AWS SageMaker.
• Comfort using Jupyter Notebooks for analysis and stakeholder storytelling.