Data Analyst – Finance Transformation Programme

🔒 Confidential Employer
Posted 10 October 2026
LOCATION
London
TYPE
Full-time
LEVEL
Mid-Senior level
CATEGORY
Finance & Accounting
This employer holds a UK Home Office sponsor license — sponsorship for this specific role is at the employer’s discretion

SKILLS

SQL Data Mapping Reconciliation Workday Financials Power BI Qlik Data Quality Analysis Finance Data Transformation

FULL DESCRIPTION

Data Analyst – Finance Transformation Programme

[Employer hidden — sign up to reveal] is seeking a Data Analyst for the Finance Transformation Programme to define data attributes, map sources, reconcile datasets, and support reporting in Workday.

Key Aspects of the Role

  • Define required finance data attributes, field definitions, and dataset requirements to support reporting, reconciliations, and downstream journal creation.
  • Analyse and document source-to-target mappings so that finance data is aligned to agreed structures, Workday-required values, and reporting needs.
  • Support data ingestion activities by validating incoming datasets, checking completeness, and confirming that records are fit for downstream processing.
  • Design and execute reconciliation logic across source data, outputs, Prism datasets, Accounting Centre outputs, and reporting results.
  • Identify data quality issues, investigate root causes, and work with business and technical teams to improve data accuracy and control effectiveness.
  • Define point-in-time and snapshot requirements so period reporting remains traceable, explainable, and auditable over time.
  • Prepare analytics-ready datasets and report specifications for Workday and approved downstream reporting tools.
  • Produce validation evidence to support SIT, UAT, production readiness, and ongoing finance control requirements.
  • Look at historical data to check its fit for the rules in Financial & Actuarial (F&A) module
  • Analyse and document finance data structures and reporting requirements, maintaining robust data lineage and controls.

Accountabilities and KPIs

  • Create Source-to-target mapping documents and field-level data definitions for the finance data stream.
  • Create data contracts and dataset specifications aligned to Actuarial, Ceded, F&A, Prism and reporting requirements
  • Create data quality rules, validation outputs, and issue logs showing how completeness, validity, and consistency are assessed.
  • Create reconciliation and validation requirements covering Source to F&A, F&A to Ceded, Ceded to F&A, F&A to Actuarial, Actuarial to F&A, F&A to Prism and report to general ledger checks.
  • Develop snapshot and history-tracking requirements to support point-in-time reporting and audit traceability
  • Assist with creating test scripts, evidence and production readiness artefacts supporting SIT, UAT, and business sign-off to “Go Live”.

Knowledge and Qualifications

  • Proven experience in data analysis, finance data transformation, reconciliation, or analytics delivery within finance, ERP, or enterprise reporting programmes.
  • Strong capability in data mapping, validation, reconciliation, and audit traceability across multi-system data environments.
  • Good understanding of finance data structures, controls, reporting requirements, and the importance of data lineage in regulated reporting environments.
  • Practical analytical skills using SQL and structured data analysis techniques; experience with reporting datasets and BI concepts.
  • Ability to work confidently with both business and technical stakeholders and translate requirements into robust, usable data outputs.
  • Exposure to Workday Financials concepts, including an understanding of how Prism Analytics and Accounting Centre support reporting and journals, is advantageous
  • Experience with large scale Finance transformation projects, London Market insurance or regulated financial services is desirable

Skills and Demonstrated Experience

  • Experience with Workday Prism Analytics or similar data preparation and reporting platforms.
  • Experience with subledger, journals or accounting-hub style solutions in high-volume finance environments.
  • Familiarity with Power BI, Qlik, Excel-based reporting packs, or other enterprise reporting tools used alongside ERP platforms.
  • Practical analytical skills using SQL and structured data analysis techniques
  • Experience in insurance, technical accounting, reinsurance, actuarial, IFRS 17, or other regulated data environments.
  • Exposure to controlled testing approaches, including SIT/UAT evidence preparation and defect investigation.
  • Ability to work confidently with both business and technical stakeholders and translate requirements into robust, usable data outputs.

About [Employer hidden — sign up to reveal]

At [Employer hidden — sign up to reveal], we empower our talented team members through active involvement and collaboration, driving strategic and business goals whilst delivering exceptional services to our customers and partners.

Our unique organisational structure fosters unparalleled sharing of information, knowledge and expertise, creating a vibrant and innovative working environment.

Our culture of excellence is fuelled by continuous learning and development opportunities across all areas of our international operations. We believe in nurturing your potential and helping you grow with us.

Why [Employer hidden — sign up to reveal]?

  • Empowerment: Be a part of decision-making processes that shape our future.
  • Collaboration: Work with a diverse team of experts who share their knowledge and insights.
  • Growth: Access to continuous learning and development programs to enhance your skills.
  • Innovation: Thrive in an environment that encourages creativity and forward-thinking.

Join us and be a part of a team that values your contributions and supports your professional journey. Together, we can achieve greatness!

Sign up free — access 45,000+ UK sponsor-licensed jobs