Data Analyst – Finance Transformation Programme

LE010 Antares Global Management Limited; Greater London; On-site; GBP 55,000 - 75,000; Full time

Benefits offered by this job

Career development opportunities

Global exposure

Job summary

Antares is seeking a data analyst to support finance data transformation, reconciliation and analytics reporting. You will define data attributes, map source to target structures, and ensure data quality for downstream journal creation and reporting pipelines.

You will collaborate with business and technical teams to validate datasets, support ingestion, and maintain robust data lineage for Workday and Prism Analytics within the London market context.

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.

Responsibilities

• 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.

Skills

SQL

Data analysis

Workday Prism Analytics

Power BI

Data mapping

Tools

Qlik

Excel

Workday

Job description

At Antares, our success starts with our people. We’re a collaborative and an inclusive organisation where every voice is valued, and every individual can grow and thrive. We combine deep expertise with a supportive culture to deliver outstanding results for our clients and a fulfilling experience for our colleagues. Whatever stage of your career you'll find a place to belong, contribute, develop and we’d love to hear from you.

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

• 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”.
• Takes responsibility for their own and colleagues’ Health & Safety at all times.
• To ensure customers are treated fairly at all times, in accordance with the Conduct Risk Policy and other relevant policies and procedures.
• To be aware and adhere to all obligations under GDPR, ensuring that the business complies with these requirements.

KPIs

• KPI: Source‑to‑target mappings and data definitions are complete, accurate, and approved, enabling successful downstream processing, minimal defects, and full audit traceability.
• KPI: Contracts and dataset specifications are defined, agreed, and maintained, ensuring alignment with business requirements and no critical post‑go‑live issues.
• KPI: Controls are established and effective, with high data accuracy and timely resolution of issues in line with agreed standards.
• KPI: Reconciliation processes are defined and operating effectively, with minimal variances and timely investigation and resolution of exceptions.
• KPI: Data retention and history tracking are in place, enabling reliable point‑in‑time reporting and compliance with audit requirements.
• KPI: Testing artefacts are delivered to a high standard, supporting successful test outcomes and readiness for deployment with no data‑related blockers.

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.

At Antares, 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 Antares?

• 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!