Job Description

This role requires a strong understanding of Finance within Commercial/Investment Banking, Products, Data Quality (DQ) controls and Data Warehouse (DWH) concepts

Requirements Gathering:
- Collaborate with Finance teams (Accounting, Risk, and Treasury) to identify business requirements for the DWH (and downstream reporting)
- Work with IT architects to translate these requirements into technical specification

Data Analysis and Mapping:
- Analyze existing Ecosystem, Inventory, and other Financial Systems to identify data structures and integration points
- Document and implement Finance Data flows End-to-End (current and future)
- Define data mappings between source systems and the DWH (including lineage and data-definitions)

Documentation:
- Create detailed Business Requirement Documents (BRD), Functional Specifications, and Data Flow Diagrams
- Document and validate reconciliation rules, data transformations, and reporting requirements

Collaboration:
- Serve as a liaison between Finance and DWH architects/developers
- Facilitate workshops and meetings to align all stakeholders
- Data Quality and Reconciliation:
- Design and validate DQ control frameworks to ensure accuracy and completeness of financial data
- Collaborate on building automated reconciliation processes at granular levels

Testing and Validation:
- Develop User Acceptance Testing (UAT) scenarios and support end-users during UAT
Ensure that the implemented solution aligns with Finance's reporting needs (e.g., US-GAAP, IFRS)

Required Skills and Experience:

Finance Domain Expertise:
- Strong understanding of Finance operations within a Commercial Bank
- Familiarity with key products (e.g., Commercial Loans, Repos, Derivatives, Fixed Income, and Equities)

Technical Knowledge:
- Basic knowledge of data warehouse concepts (e.g., ETL, data modeling, metadata management)
- Understanding of DQ controls and Reconciliation processes for Financial Data

Business Analysis Skills:
- Proven experience gathering and documenting requirements in a Finance/Banking environment
- Ability to translate complex business needs into actionable technical requirements

Communication and Stakeholder Management:
- Excellent verbal and written communication skills for liaising between Finance and IT
- Experience working with cross-functional teams, including senior Finance and IT executives

Analytical and Problem-Solving Skills:
- Ability to analyze large datasets and identify patterns or discrepancies
- Strong attention to detail and critical thinking skills

Tools and Systems:
- Proficiency in Excel for data analysis, reconciliation, and reporting
- Familiarity with financial systems (e.g., General Ledger, Risk Management tools)
- Experience with SQL, Python, or other data query tools (optional but advantageous)

Regulatory Knowledge (Strong Preference):
- Knowledge of reporting frameworks like US-GAAP, IFRS, and Basel regulations

Qualifications:
- Bachelor's degree in Finance, Accounting, or a related field
- Certifications: CFA, FRM, CBAP, or similar
- Previous experience in implementing Finance Data Warehouses or Data Marts

Job Tags

Full time,

Similar Jobs