Finance Data Analyst

Key Responsibilities - Serve as a Finance Accounting SME for banking-related data, reporting, and transformation initiatives. - Analyze existing and target-state Finance Accounting business processes, systems, data flows, and reporting requirements. - Perform detailed analysis across: * Profit & Loss (P&L) structures and reporting * Cost and expense allocation methodologies * Funds Transfer Pricing (FTP) * General Ledger (GL), chart of accounts, and accounting hierarchies * Financial management and regulatory reporting data - Engage Finance stakeholders to understand business objectives, pain points, reporting requirements, and data dependencies. - Translate business and functional requirements into Data requirements, Source-to-target mappings, Business rules, Data definitions, Logical data models, and Reporting specifications. - Work closely with data modellers, data engineers, architects, and developers to ensure Finance requirements are accurately represented within enterprise data models and platforms. - Use SQL to perform data profiling, reconciliation, validation, root-cause analysis, and investigation of Finance data issues. - Analyze data lineage from source systems through accounting and reporting platforms to downstream Finance reports. - Support reconciliation between source systems, sub-ledgers, GL, management reporting, and analytical data platforms. - Define and validate Finance KPIs, measures, dimensions, hierarchies, and calculation methodologies. - Support the design, enhancement, and validation of Finance Accounting reporting suites and dashboards. - Identify data quality issues and work with business and technology teams to define remediation approaches and controls. - Produce business process flows, data mappings, functional specifications, and other analysis documentation. - Support UAT by defining test scenarios, validating financial calculations, reconciling results, and coordinating issue resolution. - Communicate complex Finance and data concepts clearly to both technical and non-technical stakeholders. Required Experience and Skills - 5+ years of experience as a Finance Accounting SME, Finance Data Analyst, Business Data Analyst, or similar role within the banking or financial services industry. - Strong domain knowledge of P&L, financial performance reporting, cost allocation, Funds Transfer Pricing (FTP), General Ledger structures, Chart of Accounts, accounting hierarchies, and Finance reporting processes. - Demonstrated experience performing business process analysis, not limited to technical data querying. - Strong hands-on SQL skills for data analysis, profiling, reconciliation, and validation. - Proven ability to translate business requirements into data models, mappings, business rules, and reporting requirements. - Experience working with Finance Accounting data models, data warehouses, data marts, or enterprise data platforms. - Experience with Finance Accounting reporting suites and management reporting solutions. - Advanced Microsoft Excel skills, including complex formulas, PivotTables, data reconciliation, and analytical modelling. - Comfortable working closely with data modellers to define entities, attributes, relationships, dimensions, hierarchies, and financial measures. - Strong analytical and problem-solving skills with the ability to investigate complex financial data issues. - Strong stakeholder management, communication, and documentation skills. Preferred Qualifications - Degree in Accounting, Finance, Business, Economics, Information Systems, Data Analytics, or a related discipline. - Professional accounting qualification such as CPA, ACCA, CIMA, CA, or equivalent would be advantageous.