Senior Technical Business Analyst - Banking Data & ETL

Luxoft; Adelaide; On-site; AUD 130,000 - 170,000; Full time

Job summary

Luxoft in Adelaide seeks a seasoned Technical Business Analyst to support a major banking transformation project. You will bridge business requirements with technical delivery, focusing on data reconciliation, ETL processes, and data transformation across upstream and downstream systems.

Responsibilities include eliciting requirements, creating BRDs/FRDs, mapping data flows, validating ETL logic, and ensuring data quality and traceability throughout the project lifecycle.

Qualifications

• 9+ years as Technical/IT Business Analyst in data-intensive environments.
• Strong experience in the Business Lending/Commercial Lending domain.
• Hands-on experience with data reconciliation, ETL processes, and data transformation.
• Proficient in SQL for data profiling, analysis, validation, and reconciliation.
• Knowledge of AS/400 concepts, RPG, COBOL, DB2, VSAM, and CICS.
• Experience creating Source-to-Target mappings, data rules, and data mapping specs.
• Familiar with data warehousing concepts, data models, and data lineage.
• Experience in Agile/Scrum delivery environments and stakeholder management.
• Proficient with JIRA, Confluence, Visio, and MS Office tools.

Responsibilities

• Elicit, analyze, and document business, functional, and non-functional requirements.
• Conduct workshops, interviews, and sessions to understand processes and data needs.
• Translate requirements into BRDs, FRDs, user stories, and acceptance criteria.
• Create and maintain BRDs, FRDs, process flows, and use cases.
• Liaise between business stakeholders, product owners, data teams, developers, and QA.
• Clarify requirements, resolve ambiguities, and manage stakeholder expectations.
• Perform gap analysis and recommend process improvements.
• Support impact assessments for data migrations and regulatory changes.
• Ensure end-to-end traceability of requirements throughout the project.
• Review data mappings and ETL logic against business requirements.
• Define business rules, reconciliation criteria, and data quality requirements.
• Support test planning, UAT, and defect triage activities.
• Track changes, risks, dependencies, and issues.
• Prepare status reports and communicate progress to stakeholders.
• Drive data governance and data quality discussions across teams.
• Provide production support by assisting in issue analysis and root-cause investigations.

Tools

AS/400 (IBM iSeries) applications and databases

RPG

COBOL

JCL

DB2

VSAM

CICS

SQL

ETL

data reconciliation

data warehousing

S2T mappings

Agile/Scrum

JIRA

Confluence

Visio

Microsoft Office

Job description

Luxoft in Adelaide seeks a seasoned Technical Business Analyst to support a major banking transformation project. You will bridge business requirements with technical delivery, focusing on data reconciliation, ETL processes, and data transformation across upstream and downstream systems.

Responsibilities include eliciting requirements, creating BRDs/FRDs, mapping data flows, validating ETL logic, and ensuring data quality and traceability throughout the project lifecycle.