Data Cleansing Support Officer

We are recruiting for a Data Cleansing Support Officer who will be responsible for ensuring the accuracy, consistency and integrity of data within the organisation’s CRM and associated systems.

The role will focus on identifying, analysing and correcting data quality issues, supporting CRM optimisation, and working closely with internal stakeholders and external IT partners to improve data standards across Microsoft Dynamics CRM and related databases.

Key responsibilities will include:

• Perform data cleansing, validation, deduplication and enrichment activities across CRM and related systems
• Use SQL queries to extract, analyse and correct data issues in databases
• Support ongoing maintenance and improvement of data quality within Microsoft Dynamics CRM
• Identify data inconsistencies, gaps and errors and implement corrective actions
• Work with CRM & Data Product Owner to define and apply data quality rules and standards
• Assist in data migration, integration and transformation projects where required
• Develop and maintain SQL scripts and procedures for recurring data quality checks
• Support reporting accuracy by ensuring clean and reliable datasets
• Liaise with external IT support partners to resolve technical data-related issues
• Maintain documentation of data cleansing processes, rules and workflows
• Support CRM & Data Product Owner to administer the database and ensure the teams and business processes obtain maximum value to deliver objectives

General Duties

• Maintain high standard of personal presentation and represent the Society in a professional manner at all times.
• Liaise with other members of the Society to actively promote opportunities, exchange information and increase professionalism.
• Undertake all responsbilities with reference to Society procedures.
• Undertake any reasonable duties as requested by Line Manager and Senior Leadership Team.

• Educated to Level 3 or above.

Desirable

• Bachelor degree or above.

Competencies

Essential

• Strong analysis, trouble shooting, problem solving skills
• Good organisational and time-management skills with an ability to multi-task and prioritise
• Ability to liaise with and build positive relationships with stakeholders through interpersonal skills

Desirable

• Data analysis skills
• Negotiating skills

Previous Experience

Essential

• Knowledge of equipment provision and the ability to manage the end to end provision process from purchase to delivery.
• Experience working with CRM systems;
• Supplier management and/or relationship management;

Desirable

• Experience of working with Microsoft Dynamics CRM;
• Experience of working in a membership association and with volunteers;
• Experience of providing end-user technology support.

Special Aptitudes

• Positive, energetic and proactive approach to tasks
• Highly effective and engaging communications and interpersonal skills - written and verbal
• Availability to work outside of usual pattern of working hours when required.
• Highly focused work ethic

IT and Media

Essential

• Fully IT and database literate (in Microsoft Office 365, CRM and CMS systems)

Desirable

• Experience of working with Microsoft Dynamics CRM
• Experience of Umbraco

The Royal Aeronautical Society is a professional body dedicated to aerospace communities. We exist to further the advancement of aeronautical art, science, and engineering around the world.