System Analyst – Retail Data Mart

Responsibilities

1. Functional specification

a. Responsible to analyse and define detailed functional specifications based on the functional and non-functional requirements document

b. Collaborate with Functional Business Analyst to clarify functional and non-functional requirements

c. Define and ensure traceability from functional specifications to business requirements

2. Technical Design

a. Responsible to create technical design

b. Ensure technical design adheres to architectural roadmap, Development practices, and security requirements

c. In case of vendor implementation: Ensure vendor resources create technical design document

d. Collaborate with developers and infrastructure teams to clarify functional specification and technical design during build, test and deployment phase

e. Collaborate with Production Support to establish IT operations procedures and document as part of Tech Design

f. Coordinate execution of threat modelling process with assistance of Security Architect to ensure implementation of safeguards is comprehensive in accordance with threats

3. Testing & Scope Management

a. Clarify test findings escalated by Test Manager and classify the findings accordingly (either as a defect or change request)

b. Provide input to impact assessment and estimation for Project Change Request

c. Work with Test Manager to review test plan and functional test scope

Requirements

• Commitment and a have a team environment mindset

• Expertise in logical and physical data modelling

• Proficient in data modelling profiling

• SQL skills and ability to work with datasets.

• Understanding of data warehousing, and data integration techniques.

Key Domain / Technical Skills

• Experience with Hadoop, SQL.

• Private Banking/Treasury (Fixed Income, Derivatives)

• Data modelling, or data management, in the banking industry.

Job Types: Full-time, Contract

Pay: $9,000.00 - $11,000.00 per month

Work Location: In person