Role: Business Analyst – Data
Role Purpose
To support the development and operationalisation of the Common Data Model (CDM) by mapping data from multiple source systems (e.g Core banking, Lending Systems, General Ledger etc) into the CDM, and from the CDM to various target domains including regulatory reporting, dashboards, and MI.
Key Responsibilities
* Collaborate with business SMEs, engineers, architects to analyse source system data structures and semantics
* Perform detailed data mapping from source systems to CDM entities and attributes.
* Define transformation logic and business rules required for mapping and harmonisation.
* Perform detailed data mapping from CDM to target domains
* Maintain mapping documentation and contribute to the data catalogue.
* Validate mappings through profiling, reconciliation, and test queries in BigQuery.
* Identify data quality issues and work with relevant teams to resolve them.
* Validate and achieve sign-off requirements from various stakeholders
* Conduct walk-through of requirements and data specifications with business SMEs, architects, engineers, and test teams.
Required Skills & Experience
* Strong experience in data mapping, data integration, or ETL processes.
* Familiarity with financial services data, especially lending and credit domains.
* Hands-on experience with SQL
* Experience working with cloud data platforms (preferably GCP and BigQuery).
* Ability to interpret complex data structures and translate them into business-friendly formats.
* Familiarity with various database tools and ability to navigate through complex systems landscapes
Desirable Skills
* Experience with CDM frameworks or canonical data models.
* Knowledge of regulatory reporting requirements in UK banking
* Experience with data catalogue tools and metadata management
* Product specific knowledge across lending, deposits, or treasury