Business Analyst – Finance/IT

TSG Risk Management•New York, NY

17h

About The Position

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)

Requirements

Strong understanding of Finance operations within a Commercial Bank
Familiarity with key products (e.g., Commercial Loans, Repos, Derivatives, Fixed Income, and Equities)
Basic knowledge of data warehouse concepts (e.g., ETL, data modeling, metadata management)
Understanding of DQ controls and Reconciliation processes for Financial Data
Proven experience gathering and documenting requirements in a Finance/Banking environment
Ability to translate complex business needs into actionable technical requirements
Excellent verbal and written communication skills for liaising between Finance and IT
Experience working with cross-functional teams, including senior Finance and IT executives
Ability to analyze large datasets and identify patterns or discrepancies
Strong attention to detail and critical thinking skills
Proficiency in Excel for data analysis, reconciliation, and reporting
Familiarity with financial systems (e.g., General Ledger, Risk Management tools)
Bachelor’s degree in Finance, Accounting, or a related field

Nice To Haves

Experience with SQL, Python, or other data query tools (optional but advantageous)
Knowledge of reporting frameworks like US-GAAP, IFRS, and Basel regulations
Certifications: CFA, FRM, CBAP, or similar
Previous experience in implementing Finance Data Warehouses or Data Marts

Responsibilities

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
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)
Create detailed Business Requirement Documents (BRD), Functional Specifications, and Data Flow Diagrams
Document and validate reconciliation rules, data transformations, and reporting requirements
Serve as a liaison between Finance and DWH architects/developers
Facilitate workshops and meetings to align all stakeholders
Design and validate DQ control frameworks to ensure accuracy and completeness of financial data
Collaborate on building automated reconciliation processes at granular levels
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)