Data analyst в CRM

Royal College of General Practitioners; Greater London; On-site; GBP 35,000 - 55,000; Full time

Job summary

The Royal College of General Practitioners is seeking a Data Analyst to transform Salesforce and CRM data into meaningful insights that support decision-making and service improvement. You will design reports, dashboards and data definitions, and work with developers and product owners to ensure high data quality and governance.

Join a mission to build digital capabilities across learning, standards, policy and research, contributing to the transformation of data-driven decision making for UK

Qualifications

• Experience in data analysis, profiling, cleansing, reconciliation and resolving data quality issues.
• Strong knowledge of Salesforce data models and reporting, with experience of Lightning Reports and Dashboards, SOQL, Data Loader or equivalent.
• Experience troubleshooting data from imports, integrations or APIs and safely correcting data in live environments.
• Proficiency in Excel and Power Query, alongside experience of data visualisation or business intelligence tools.
• Ability to convert unclear business concerns into testable questions and communicate evidence-based findings to technical and non-technical stakeholders.

Responsibilities

• Analyse Salesforce and associated CRM data to identify trends, assess impact and provide clear, actionable insight.
• Investigate data inconsistencies and trace root causes across imports, integrations and APIs, and support safe remediation.
• Design and maintain reports, dashboards, data definitions, cleansing rules and reusable exception reporting.
• Provide data requirements, rules, impact analysis and acceptance criteria for agile delivery, working closely with developers, testers and product owners.
• Improve data quality, governance and reporting standards, while documenting processes and sharing knowledge across the organisation.

Skills

Salesforce data models

SOQL

Lightning Reports & Dashboards

Data analysis

Data cleansing

Excel

Power Query

Tools

Salesforce

Data Loader

Power Query

Excel

Job description

Описание:

The Royal College of General Practitioners is the professional home for UK GPs, serving over 55,000 members and trainees. We are investing in a 3-year vision to build a digital home for the profession across learning, standards, policy and research, beginning by building a fantastic Digital, Data and Technology (DDaT) team of over 30 people, balancing leadership, delivery management and technical roles, including technical capabilities in Salesforce development, data, UX, IT, AI, and security. We are currently looking for a Data Analyst to transform Salesforce and associated CRM data into meaningful insight that supports decision-making, service improvement and the development of our digital capabilities.

Задачи:

Analyse Salesforce and associated CRM data to identify trends, assess impact and provide clear, actionable insight. Investigate data inconsistencies and unexpected outcomes, trace root causes across imports, integrations and APIs, and support safe remediation. Design and maintain reports, dashboards, data definitions, cleansing rules and reusable exception reporting. Provide data requirements, rules, impact analysis and acceptance criteria for agile delivery, working closely with developers, testers and product owners. Improve data quality, governance and reporting standards, while documenting processes and sharing knowledge across the organisation.

Требования:

Practical experience in data analysis, profiling, cleansing, reconciliation and resolving complex data quality issues. Strong knowledge of Salesforce data models and reporting, with experience of tools such as Lightning Reports and Dashboards, SOQL, Data Loader or equivalent. Experience troubleshooting data from imports, integrations or APIs and safely correcting data in live environments. Proficiency in Excel and Power Query, alongside experience of data visualisation or business intelligence tools. The ability to convert unclear business concerns into testable questions and communicate evidence-based findings to technical and non-technical stakeholders.

Условия:

RCGP offers an attractive reward package and will invest in the technical skills of our team. RCGP has a collaborative culture and is committed to being an inclusive employer. We are building an amazing team! Come join us at the start of an exciting journey that will transform the digital experience of our members and staff, and through them make a real difference to the health of UK patients.