Operational Data Executive

RCNi :: Nursing Standard; London; On-site; GBP 35,000 - 55,000; Full time

Job summary

RCNi is seeking a detail-oriented Analyst to join their Strategy and Insight team. The successful candidate will support data-driven decisions through data extraction and reporting, enhancing business operations across various domains. Candidates should possess strong SQL skills and a proficiency in data visualization tools. If you are passionate about data and eager to contribute in a dynamic team, apply now to help drive impactful insights for nursing professionals.

Qualifications

• Experience in SQL and data manipulation.
• Understanding of CRM systems and data privacy regulations.
• Ability in data visualization tools like Power BI.

Responsibilities

• Generate and automate data extracts for various departments.
• Maintain processes for B2C payment processing and customer onboarding.
• Act as project lead for CRM-related initiatives.
• Keep knowledge current on data tools and best practices.

Skills

SQL

Data Visualization

CRM Management

Data Reporting

Problem Solving

Education

Degree in Data Science or related field

Tools

Microsoft Power BI

Excel

SQL Server Reporting Services

SQL Data Warehouse

MySQL

Job description

RCNi supports the work-life balance of our staff through our SMART Working policy outlining our approach to agile and flexible working

Closing date: 1st July 2025

Can you extract meaning and create visibility of customer wants, needs and experiences and looking for an opportunity to shape a business based on your expertise?

We are RCNi, part of the Royal College of Nursing Group. We aim to provide nursing professionals worldwide with easy access to our peer-reviewed content (journals, learning and more), news, opinion, jobs, events, and awards. RCNi is a small organisation with big aspirations.

This role is an integral part of the Strategy and Insight team at RCNi, supporting the market analyst in developing the data extraction, cleansing and shaping that forms our data reporting, insight and modelling. This work is key to helping business colleagues by informing data driven decisions.

Specific Aims

1. Generate data extracts that inform key commercial operations and aid stakeholders in meeting business objectives

• Create and distribute scheduled and ad hoc operational data extracts from the CRM or other platforms for marketing, finance, sales, product development or senior/executive management teams.
• Employ clear graphical data representations and visualisations where necessary.
• Amend existing or write new SQL queries and Advanced Finds where necessary.
• Help train and support any staff who provide data extract backup in the role-holder’s absence.
• Work with colleagues to identify scope for improvements to data extraction processes.
• Work with marketing and BIS to improve segmentation and targeting from CRM to optimise business activities.

2. Maintain operational and technical processes that support B2C payment processing, customer onboarding and product fulfilment.

• Coordinate changes to Business and Operational Support (BOS) systems linked to implementation of Microsoft Wave releases, CRM upgrades, product testing, defects fix testing and SilverBear sprint releases.
• Produce test scripts and scenarios for changes and upgrades.
• Support user acceptance testing to ensure end-tool software meets specification.
• Log fault bugs and re-test when fix in place.
• Maintain working relationship with the BOS team to support product changes and joint RCN/RCNi projects.
• Produce ‘how to’ documentation.
• Lead on updating product and price updates in the CRM.
• Work with stakeholders as appropriate to identify and solve problems and bugs.

3. Act as RCNi lead in CRM-related projects to optimise customer experience, as directed by a member of the executive team.

• Take an active role in all CRM (RCN or RCNI initiated) projects that impact on RCNi commercial activity.
• Collaborate with project stakeholders on requirements for group projects.
• Ensure actions are directed by a member of the executive team.

4. Maintain up-to-date knowledge of data tools, CRM, GDPR and industry best practice

• Engage regularly with the BIS team to pool knowledge, share best practice and update skills in Microsoft Power BI, Excel, SQL Server Reporting Services, SQL Data Warehouse and MYSQL.
• Gather data from various sources to produce reports for non-expert users.
• Attend RCN CRM Rapid Assessment meetings and meet regularly with RCN CRM teams to maintain up-to-date user knowledge of the CRM, as facilitated by the Associate Director of Product Management and Marketing.
• Understand GDPR best practice in relation to RCNi processes.

At RCNi we use Applied for our recruitment. Applied aims to overcome unconscious bias in recruiting. Instead of using your CV alone, we'll be asking you to answer questions to test skills needed for the role. The responses are then anonymised, and reviewed in a random order by members of our team. Responses to these questions determine whether you progress to the next stage of selection.

Should you successfully progress to the next stage of selection, this will involve a panel interview.

The Applied platform also asks some demographic questions before you start your application. We at RCNi never see the responses to these demographic questions with your application. We only see summary statistics to help us check if our candidate pool is balanced and if everyone has an equal chance to get hired irrespective of their background. If you prefer, you can easily opt out of answering these questions.