Data Analyst

Role Title: Data Analyst Location: London, UK Work Model: Hybrid (2 days onsite per week) Contract Duration: 6 months (extendable) Project Overview The RCMS project supports front-line business units operating on the Salesforce platform. The initiative focuses on simplifying data and technology landscapes to enhance platform reliability, reduce errors, and lower support costs. The data workstream plays a critical role in improving data models, accuracy, and standardisation—enabling the client’s data-driven strategy. Key Responsibilities • Collaborate with business analysts, architects, and technical teams to align business needs with target data models. • Reverse-engineer and simplify complex Salesforce object/field landscapes, identifying redundancies and inefficiencies. • Conduct workshops with both technical and non-technical stakeholders to gather and refine data requirements. • Define target data models, perform gap analysis, and assess business impacts of proposed changes. • Develop and maintain data dictionaries, taxonomies, and reference/master data repositories with governance controls. • Support data lineage documentation and ensure consistency across upstream and downstream systems. Must-Have Skills • Strong experience in data modelling (3NF, Star/Snowflake, Data Vault 2.0). • Hands-on experience with data modelling tools such as Erwin, PowerDesigner, or Sparx EA. • Knowledge of Salesforce data architecture and data remediation. • Proven track record in creating and maintaining data dictionaries, taxonomies, and reference data. • Strong communication and stakeholder management skills across technical and business teams. Good to Have • Experience with data warehouses/lakehouses, ETL/ELT tools, and data governance frameworks (e.g., DAMA DMBOK). • Experience documenting data lineage (e.g., Solidatus) and performing impact analysis. • Knowledge of privacy-by-design and data security practices (handling PII, RBAC, data minimisation). • Familiarity with business analysis and translating requirements into data design. • Exposure to financial services or enterprise-scale Salesforce implementations. Screening Questions 1. How many years of experience do you have in Salesforce data analysis or architecture? 1. How many years of experience do you have in data modelling (3NF, Star, Snowflake, or Data Vault)? 1. Which data modelling tools have you worked with (e.g., Erwin, PowerDesigner, Sparx EA)? 1. How many years of experience do you have with data lineage or data governance frameworks?