Operation Smile UK
We are seeking a Senior Database Officer to join our Data Team in the Operations department. This full-time position reports to the Senior Database Manager and will collaborate closely with a Database Officer.
As a key member of our team, you will play a vital role in maintaining the accuracy and compliance of our Donorfy database. You will maintain and enhance our Donorfy database, clean, process, and import data from various sources, provide database support to colleagues across the organisation, and collaborate with the Senior Database Manager on database development projects. You will be flexible, able to work under pressure and manage a busy and sometimes competing workload.
Operation Smile is a global nonprofit specialising in cleft surgery and care. We provide medical training, education and mentorship to surgical teams around the world, along with expertise, research and care through our staff and volunteers, working alongside local governments, nonprofits and health systems.
Working Arrangement
: Collaborate with your colleagues in-person two days per week at our London office. Candidates must reside within a commutable distance of Greater London.
Job Purpose:
Operation Smile UK seeks a passionate Senior Database Officer to manage the front end of its Donorfy CRM system. Working with the data team, you will promote effective CRM use across the organisation, ensuring efficient, regularly reviewed data management processes. Maintaining data accuracy and integrity is crucial, as is securely importing and exporting data to support various teams and provide insights to increase fundraising potential. This position presents a potential career path towards a managerial role for high-performing individuals
.
Key Responsibilities:
1. Donorfy (CRM) Management
• Responsible for the front end day to day management of our Donorfy CRM.
• Set up and train new starters on the CRM
• Support and training existing staff to ensure effective use of the CRM
• Manage the flow of financial and non-financial data from third-party platforms and agencies, as well as direct income and data streams. This will include cleaning and preparing data, as well as importing it into Donorfy
• Undertake routine data cleansing and quality control processes to ensure the database is accurate, such as de-duplicating.
• Managing the data specifications and briefs for fulfilment agencies, including undertaking monthly quality analysis of data received from agencies
• Set up and manage Donorfy triggers, workflows and mail merges
• Liaise with Donorfy support, external agencies (MAST) and the wider team to further streamline any data-led processes
2. Financial Reconciliation
• Reconcile income processed and investigate any variances, including following up with fulfilment agencies, fundraising teams, platforms etc.
• Run monthly Gift Aid Claims for eligible single gifts and recurring gifts
• Produce various monthly reports, such as donation reports for fundraising teams and deferred income/restricted income reports to finance
• Produce and maintain the Donorfy custom accounts download
3. CRM Integrations
• Manage and maintain the custom API online income integration between Donorfy and Gravity Forms via the OSUK website
• Manage and maintain the Dotdigital email marketing integration
• Manage and maintain the Enthuse and Justgiving integrations
4. Reporting, Insight and Data Selections
• Support the Senior Database Manager to build/test reports and dashboards via SQL or Power BI to report on key performance indicators and targets
• Monitor existing Power BI reports set up each monthly to ensure they are accurate and report any fixes to the Senior Database Manager
• Run data selections for small-scale campaigns as required by the Senior Database Manager
5. Operational Support and General Tasks
• Backfill the Database Officer and Senior Database Manager roles in their absence
• Assisting the Senior Database Manager with SQL projects and automated workflows
• Keep procedure guides up to date for processes routinely undertaken
• Undertake quarterly audits on large gifts and gift aid declarations/claims
We are actively interviewing for this role on a rolling basis as suitable applicants apply. If you’re interested in this role, it is advisable to apply as soon as possible.
Operation Smile UK (OSUK) is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind: OSUK is committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions at OSUK are based on business needs, job requirements and individual qualifications, without regard to race, colour, religion or belief family or parental status, or any other status protected by the laws or regulations in the UK. OSUK will not tolerate discrimination or harassment based on any of these characteristics. OSUK encourages applicants of all ages.
As users of the disability confident scheme, we guarantee to interview all disabled applicants who meet the minimum criteria for the vacancy. At Operation Smile UK, we see people first and foremost for their performance and potential. We are committed to building a diverse and inclusive organisation that supports the needs of all. As such we will make reasonable adjustments at interview through to employment for our candidates and strongly encourage applications from a diverse candidate pool. We operate a hybrid work structure. We are proudly Disability Confident Committed employers. Disabled applicants who meet the minimum criteria for the job will be given the opportunity to demonstrate their abilities at an interview. For help with your application please contact us (further details contained within the job description).
