About the role
Our client, a financial services organisation, is looking for an experienced Contract Data Analyst to support its Data & Integration Platform.
You’ll own source-to-target mapping, transformation rules and data cleansing requirements across platform integrations, working closely with data engineers, architects and business subject matter experts.
Key responsibilities
- Define and maintain field-level source-to-target mappings, documenting transformation logic, data types and lineage
- Use SQL to profile source data, identify quality issues and validate data across systems
- Define data quality and cleansing rules for duplicates, nulls and reference data inconsistencies
- Work with business and finance stakeholders to clarify requirements and document testable outcomes
- Collaborate with data engineers and architects so mappings fit the platform architecture
- Support source-to-target reconciliation and investigate discrepancies
- Keep clear documentation of mapping decisions, cleansing requirements and validation rules
- Work in an Agile environment using Azure DevOps or Jira
Essential
- 5+ years as a Data Analyst on data integration, migration or data warehouse programmes
- Proven field-level source-to-target mapping experience
- Strong SQL for profiling, validation and reconciliation
- Experience defining data quality and cleansing rules
- Snowflake or a comparable cloud data warehouse
- Understanding of medallion architecture (Bronze, Silver, Gold)
- Ability to turn business and finance concepts into clear, testable requirements
- Agile delivery experience with Azure DevOps or Jira
- Strong documentation and stakeholder communication skills
Highly desirable
- Background in private equity, fund administration or asset management
- Familiarity with Salesforce, Investran, Sage Intacct, Kyriba or Fenergo
- Analysing REST APIs and JSON payloads, with exposure to Fivetran or Azure integration tooling
- Master data management or canonical data modelling
- Awareness of data governance, including lineage, data residency and GDPR