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 pointsDocument 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 DiagramsDocument and validate reconciliation rules, data transformations, and reporting requirementsCollaboration :
Serve as a liaison between Finance and DWH architects / developersFacilitate workshops and meetings to align all stakeholdersData Quality and Reconciliation :Design and validate DQ control frameworks to ensure accuracy and completeness of financial dataCollaborate on building automated reconciliation processes at granular levelsTesting and Validation :
Develop User Acceptance Testing (UAT) scenarios and support end-users during UATEnsure 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 BankFamiliarity 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 DataBusiness Analysis Skills :
Proven experience gathering and documenting requirements in a Finance / Banking environmentAbility to translate complex business needs into actionable technical requirementsCommunication and Stakeholder Management :
Excellent verbal and written communication skills for liaising between Finance and ITExperience working with cross-functional teams, including senior Finance and IT executivesAnalytical and Problem-Solving Skills :
Ability to analyze large datasets and identify patterns or discrepanciesStrong attention to detail and critical thinking skillsTools and Systems :
Proficiency in Excel for data analysis, reconciliation, and reportingFamiliarity 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 regulationsQualifications :
Bachelor's degree in Finance, Accounting, or a related fieldCertifications : CFA, FRM, CBAP, or similarPrevious experience in implementing Finance Data Warehouses or Data Marts
