JobCubby JobCubby
Sign up
XPT Software Australia Pty Ltd

ETL Technical Business Analyst

XPT Software Australia Pty Ltd Sydney, New South Wales, Australia

IT Services and IT Consulting · 51-200 employees

8 h ago
business-analyst Principal (10+ yrs) Contractor Australia
Log in to apply, save this posting, or score it against your profile with AI.

About the role

The role involves gathering and analyzing business data requirements to define transformation logic and ensure high-quality integration. You will act as a liaison between stakeholders and engineering teams while maintaining documentation like data dictionaries and mapping specifications.

What they look for

Data Analysis ETL Stakeholder Engagement Informatica MDM PowerCenter Talend DataStage SSIS Data Warehousing EDW Data Marts Star Schema Snowflake Schema Source-to-Target Mapping Data Profiling Data Lineage

Requirements

The ideal candidate must have at least 8 years of experience in data analysis and ETL processes. Strong expertise in data warehousing concepts and proficiency with ETL tools such as Informatica, Talend, or SSIS is required.

Full description

Must Have Skills:

The role involves analysing data requirements, defining transformation logic, and ensuring high-quality data integration across systems. The ideal candidate must have strong expertise in data analysis, ETL processes, and stakeholder engagement

Nice to Have Skills: Understanding of ETL concepts (Extract, Transform, Load)

Experience with ETL tools such as Informatica MDM, PowerCenter, Talend, DataStage, SSIS, or equivalent

Data Warehousing concepts (EDW, Data Marts, Star/Snowflake Schema)

Data Mapping and Source-to-Target Mapping (STM) documentation

Detailed Job Description We are seeking a skilled Onshore ETL Technical Business Analyst to bridge the gap between business stakeholders and data engineering teams. The role involves analysing data requirements, defining transformation logic, and ensuring high-quality data integration across systems. The ideal candidate will have strong expertise in data analysis, ETL processes, and stakeholder engagement.

Key Responsibilities

Requirements & Analysis

  • Gather and analyze business and data

requirements from stakeholders

  • Translate business needs into

functional and technical specifications

  • Define and document Source-to-Target

Mapping (STTM)

Data Analysis & Profiling

  • Analyze source systems, schemas, and

data flows

  • Perform data profiling, validation,

and quality assessment

  • Identify data issues, gaps, and

inconsistencies

ETL & Data Integration Support

  • Collaborate with ETL developers to:
  • Define data transformation rules
  • Support data cleansing and

enrichment requirements

  • Ensure data lineage and

traceability

  • Support integration across multiple

systems

Documentation

  • Create and maintain:
  • Source-to-Target Mapping documents
  • Data dictionaries and metadata
  • Process and data flow diagrams
  • Document business rules and

transformation logic

Testing & Validation

  • Develop test scenarios, test cases,

and expected results

  • Support SIT and UAT cycles
  • Validate ETL outputs against

business requirements and data rules

Stakeholder Management

  • Act as a liaison between business,

data engineers, and QA teams

  • Facilitate discussions, clarify

requirements, and resolve issues

  • Provide regular status updates and

documentation

Minimum Years of Experience : 8 Years

Similar roles