Data Analyst

Job Title: Data Analyst Location: London, UK Work Mode: Hybrid – 2 days onsite per week Contract Duration: 6-12 Months Project Overview The RCMS project supports frontline business units on the Salesforce platform, with a focus on simplifying data and technology to create a more robust, cost-effective, and scalable solution. The Data Workstream plays a critical role in remediating a core data model, improving accuracy, reducing data-related errors, and standardizing data structures to enable faster, lower-risk delivery while supporting data-driven decision-making and strategic objectives. Role Overview As a Data Analyst, you will join a data remediation team focused on simplifying and improving the underlying data model of a heavily customized Salesforce implementation. You will work closely with technical and business stakeholders to understand the current state, define the target data model, and support the delivery of a cleaner, more reliable data foundation. Key Responsibilities • Join a data remediation team responsible for simplifying Salesforce data models. • Participate in workshops with technical and non-technical stakeholders to understand requirements, drivers, constraints, and business impacts. • Collaborate with Business Analysts and Architects to ensure business needs align with target data models, lineage, and metadata. • Reverse-engineer existing Salesforce objects, fields, usage patterns, and data flows. • Identify data duplication, anti-patterns, and unnecessary complexity. • Define target (“to-be”) data models aligned to business processes. • Perform gap analysis between current (“as-is”) and target states, considering business impact. • Establish and maintain data lineage, data dictionaries, taxonomies, and reference/master data. What You’ll Gain from the Role • Opportunity to work on complex data problems within a business-critical Salesforce platform. • Direct engagement with senior business stakeholders to translate strategic change into data concepts. • A key role in improving data reliability, usability, and governance across upstream and downstream systems. • A challenging and rewarding position with high visibility and long-term impact. Required Skills & Experience (Minimum Criteria) • Strong proficiency in data modelling techniques, including: • 3NF • Star/Snowflake schemas • Data Vault 2.0 • Hands-on experience with modern data modelling tools such as Erwin, Power Designer, or Sparx EA, including version control. • Experience creating and maintaining: • Data dictionaries • Taxonomies • Reference and master data • Experience working with internal stakeholders to define data-related use cases and success criteria. • Excellent communication and stakeholder engagement skills, with the ability to communicate effectively with both technical and non-technical audiences. Desirable Skills & Experience • Exposure to relational and non-relational data stores. • Understanding of data warehouse and lakehouse concepts. • Experience with ETL/ELT patterns and tools. • Background in business analysis and requirements elicitation for data-centric initiatives. • Experience documenting and implementing data lineage and impact analysis (e.g., Solidatus). • Knowledge of data architecture best practices. • Proven ability to document “as-is” and define “to-be” processes. • Exposure to data governance frameworks (e.g., DAMA DMBOK). • Understanding of data quality rules and governance practices. • Familiarity with privacy and security-by-design principles (PII handling, data minimisation, RBAC).