Analyse and organise raw financial and transactional data to meet business needs and regulatory objectives.
Perform data validation and reconciliation between source systems, Finbourne (LUSID), and downstream platforms.
Develop, maintain, and optimise SQL queries and scripts, primarily on Snowflake and relational databases.
Support trade lifecycle data analysis, including transactions, instruments, portfolios, and valuations.
Identify data quality issues, inconsistencies, or gaps and collaborate with technical teams to resolve them.
Work closely with business SMEs, BAs, and QA teams to ensure data accuracy and completeness.
Support operational reporting and analytics, enabling business and operational decision-making.
Contribute to defining data quality standards, controls, and reconciliation processes.
Support investigations related to production data issues and provide insights for root cause analysis.
Collaborate within Agile delivery teams, contributing to sprint activities and continuous improvement.

Requirements

5+ years of experience in data analysis, reporting, or data validation roles.
Strong proficiency in SQL, with hands-on experience using Snowflake.
Experience analysing large, complex datasets, ideally in financial or regulated environments.
Solid understanding of data reconciliation and data quality controls.
Ability to translate business requirements into data queries and insights.
Experience collaborating with business stakeholders and technical teams.
Strong analytical and problem-solving skills.
Experience working in Agile environments.
Fluency in English.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLdata analysisdata validationdata reconciliationdata quality controlsdata queriesanalyticsfinancial datasetsSnowflakerelational databases

Soft Skills

analytical skillsproblem-solving skillscollaborationcommunicationbusiness requirements translation