Jacob Gedney

Results-driven Data Professional and manager with over 7 years’ experience in designing, implementing and optimising data pipelines. Expert in SQL with a strong ability to handle complex queries, data warehousing and database management. Proven track record in ensuring data integrity, scalability and performance across multiple environments.

Great Ormond Street Hospital Charity – (June 2023 – Present)

Selections Manager - London

1.  Oversee, develop and mentor a team of SQL data selection executives to provide stakeholders with marketing data for complex mailing campaigns. Making sure all data provided is to a high and compliant standard.

2.  Building relationships with stakeholders and managing their expectations where necessary. Ensuring the team can meet the demands of the charity within reasonable timeframes, while being flexible wherever possible. 

3.  Creating SQL select queries to manipulate complex data structures to provide stakeholders with data for new and on-going marketing campaigns.

4.  Perform database administration tasks; creating new stored procedures, functions, optimizing current scripts while also monitoring performance.

5.  Use my knowledge to help with new developments within the charity. Most recently having involvement with the integration of the ETL platform Boomi moving all of our ETL processes from Talend.

6.  Monitoring data quality. Creating python reports to compare the data that is stored in salesforce against what is in the data warehouse to ensure that we have accurate and up to date data regularly available. While also providing reports on data quality and giving feedback on how we can improve the charities data quality.

7.  Automating manual tasks using PowerShell and task scheduler.

      ICARIS – (January 2017 – June 2023)

Software Technician - Spalding, Lincolnshire

1.  Providing technical support, maintenance, and development for over 40 clients in the not-for-profit sector.

2.  I continue to work collaboratively with a large number of stakeholders at all levels to understand their requirements from their databases. As an organisation continually evolve, I engage with stakeholders to understand their needs and offer guidance to be able to achieve positive outcomes.

3.  As part of my role, I manage the support desk to ensure appropriate customer support and problem resolution is provided in a timely manner, creating action plans, prioritising, delegating tasks and personally resolving over 5500 support calls to maintain excellent customer satisfaction.

4.  I am responsible for ensuring clients meet data protection requirements and GDPR compliance while working with highly sensitive data.  The importance of data security is paramount, therefore ensuring the Stakeholders are informed to current statutory requirements.

5.  Maintain Microsoft windows server environments to guarantee stable development and client satisfaction.

6.  Leading the development of bespoke grant management, fundraising, helpline, and animal shelter modular-based CRMs. Working on streamlining processes, creating new components, and dashboards.