Technical Business System Analyst

Technical Business Systems Analyst Lead

Are you the right applicant for this opportunity Find out by reading through the role overview below.

About the Role

We're seeking a Business Systems Analyst Lead who excels at source to target data mapping, advanced SQL, has a solid understanding of robust ETL, and has experience and understanding of data loads into an Enterprise Data Warehouse. You will translate regulatory and business requirements into scalable data designs and collaborate closely with data engineering and OFSAA (Oracle Financial Services Analytical Applications) IT and business teams to deliver reliable, auditable reporting.

Key Responsibilities

• Data Mapping & Lineage

- Lead end to end source to target mapping from banking source systems to the OFSAA staging, fact, and summary layers; document business rules, transformation logic, and lineage.

- Maintain mapping specs for facts/dimensions and ensure reconciliation & traceability through the reporting stack.

• SQL & Data Validation

- Understanding complex SQL/PLSQL to profile data, validate transformations, and troubleshoot issues.

- Build reusable validation queries and exception reports; support data quality controls and sign off.

• ETL

- Understanding ETL jobs (parallel framework, lookups, transformers, aggregators, change data capture) aligned to mapping specs and SLAs.

- Understanding job parameterization, restartability, scheduling, and operational monitoring with clear runbooks.

• Research and Discovery

- Investigating business problems, researching system capabilities, analyzing data, and identifying requirements to support solution design.

• Data Warehouse

- Strong SQL skills to query and analyze data in the Enterprise Data Warehouse.

• OFSAA Solution Alignment

- Partner with OFSAA business/tech teams to ensure data structures support required modules and calculations (e.g., risk, finance, regulatory).

- Participate in SIT/UAT, defect triage, and production readiness for OFSAA reporting.

• Stakeholder Collaboration & Documentation

- Work with Product, Risk/Finance SMEs, and Data Engineering to prioritize backlog, clarify requirements, and manage change requests.

- Produce clear artifacts: BRDs, data mapping workbooks, ETL design docs, requirements documents, test plans, and runbooks.

Minimum Qualifications

• 5+ years in data/BA roles within banking/financial services.

• Strong SQL / PL/SQL skills.

• 3+ years experience with ETL jobs.

• 3+ years working with Enterprise Data Warehouse.

• Demonstrated experience delivering source to target mappings and maintaining data lineage/traceability.

• Excellent communication skills; ability to translate business rules into executable data transformations.

Preferred Qualifications

• Experience with OFSAA 8.1.x (e.g., FSDF, OFSI, reconciliation, regulatory data sets).

• Knowledge of banking products (loans, deposits, derivatives), banking terminology, Basel/Regulatory concepts, and financial reporting controls.

• Exceptional problem-solving skills. xywuqvp

• Snowflake, DataStage.

• Familiarity with job scheduling (e.g., Zena) and Git.