Sql Jobs

We are looking for a hands on Head of Data and BI to develop organisation-wide reporting capabilities, providing strategic-level insights to the executive team, and ensuring the smooth integration of data from multiple sources, for a wonderful health charity offering home working.

The Charity
A warm and collaborative charity, dedicated to supporting people through the most difficult times of their lives from palliative and bereavement care to supporting familys with the loss of a loved one.

You will be joining a highly respected organisation, with an inclusive working culture, offering fantastic benefits including structured induction programme and learning and development opportunities to aid career progression, 27 days holiday - rising to 33 with length of service plus bank holidays and a company pension scheme as well as much more.

The Role
The role of Head of Data and Business Intelligence is a hands-on technical role that will lead data warehouse development and associated services provided by the Data Team.

The Head of Data and Business Intelligence will be responsible for leading the development and execution of the charitys data strategy, ensuring data-driven decision-making across the organisation. The role is responsible for the strategic oversight and management of the charitys centralised data warehouse, ensuring that data is collected, stored, and managed to support effective reporting and analysis across the organisation.

In a devolved model, where data analysts sit within various departments, this role does not involve direct line management of analysts. Instead, the role focuses on collaborating with these teams to support their data needs and operational objectives.

The role is crucial in developing organisation-wide reporting capabilities, providing strategic-level insights to the executive team and SLT, and ensuring the smooth integration of data from multiple sources.

The Candidate
Key experience and proven ability in Power BI, SSIS, SASS, SSRS
Comprehensive understanding of SQL and Data warehousing principles with experience of working with cloud-based data warehousing, data engineering, and CRM systems.
Demonstratable experience of SQL Server and T-SQL with strong SQL skills in MS SQL.
Strong understanding of data governance, GDPR, and data compliance standards.
Experience in leading data strategy development and implementation.
Experience of developing data warehouse capabilities in Microsoft Azure
Experience of working in a matrix management environment

IMPORTANT NOTE

Our aim is to respond to all successful applications within 5 days. If you havent been contacted within 5 days your application has been unsuccessful and your details will not be held further but we positively encourage you to apply for any other positions that you may see in the future.

Third Solutions encourages applications from individuals of all ages & backgrounds. Appointment will be made on merit alone but candidates must be able to demonstrate their ability to work in the UK. Third Solutions acts as an employment agency for permanent recruitment & an employment business for temporary recruitment as defined by the Conduct of Employment Agencies & Employment Business Regulations 2003.

Data Warehouse Manager 

Salary: £55,000 - £60,000 per annum

Hours: 37.5 hours per week 

Location: Remote, with occasional face-to-face meetings (travel expenses covered) 

About the Role

We are seeking an experienced and driven Data Warehouse Manager to join a dynamic charity’s Information Systems & Technology (IS&T) department. This is a pivotal, hands-on technical position, responsible for leading and developing the charity’s data warehouse and overseeing associated data services provided by the Data Team. You will play a key role in shaping the organisation's data architecture, analytics, and reporting capabilities to support data-driven decision-making and enhance organisational impact.

This is an exciting opportunity for someone with a strong background in data management and a passion for innovation, data quality, and strategic insight. You will lead several roles, including BI Development, Data Engineering, and Information Systems Development, working with internal stakeholders across various departments to ensure accurate and effective data access and reporting.

Key Responsibilities

• Manage day-to-day operations of the Data Team, including line management responsibilities and partnership with internal and external stakeholders.
• Oversee the design, development, and migration of the data warehouse to a cloud-based infrastructure, enhancing data interoperability and driving innovation.
• Lead the development of dashboards, visualisations, and data extracts to empower the charity’s departments with real-time insights.
• Drive key data improvement projects aligned with the charity's strategy, supporting data accuracy, security, and accessibility.
• Develop and enforce data governance standards, facilitating effective data use across devolved analyst teams within the organisation.
• Act as technical lead for data projects, providing guidance on best practices for data modelling, integration, and ETL processes.
• Produce documentation for data projects, including technical specifications, data flows, and requirements documents.

Required Skills and Experience

• Degree-level education (or equivalent) in a relevant field.
• Proven experience in data warehouse management, ideally with Microsoft Azure, SQL Server, and T-SQL.
• Expertise in Microsoft Business Intelligence tools (Power BI, SSIS, SSAS, SSRS) and data visualisation techniques.
• Strong SQL skills and familiarity with integration technologies (e.g., SOAP, REST).
• Knowledge of data modelling, diagramming (UML), and experience in producing technical documentation.
• Demonstrable experience in developing data governance standards and working in a matrix management environment.
• Ability to manage complex projects and work with large, varied datasets.
• Skilled in translating technical data insights for both technical and non-technical audiences.
• Excellent communication, relationship management, and problem-solving skills.

How to Apply

If you’re a data professional with a strategic vision and a commitment to harnessing data for social good, we’d love to hear from you.

As leading charity recruitment specialists and a certified B Corp™, Harris Hill is committed to high and ever-improving standards of equitable and inclusive recruitment. We actively welcome applications from all sections of the community regardless of age, disability, gender, race, religion, sexuality and other protected characteristics.

Head of Data and Business Intelligence (Remote)

Salary: £60,000 - £65,000 per annum

Hours: 37.5 hours per week 

Location: Remote, with occasional in-person meetings (travel expenses covered) 

Employment Type: Temporary or Fixed Term Contract

Duration: 3-6 months

About the Role:

We are seeking a dynamic and experienced Head of Data and Business Intelligence to lead a data-driven transformation for a respected charity. This hands-on, strategic role will involve overseeing data warehouse development, enhancing data integration, and driving the charity’s data strategy forward. This position requires a visionary leader with a strong technical background who can inspire a data-centric culture and enable impactful, data-informed decision-making across the organisation.

Key Responsibilities:

- Lead the Data Team and manage BI development, data engineering, and data analysis functions.

- Develop and execute the charity’s data strategy to support effective decision-making and performance measurement.

• Oversee the design, development, and maintenance of the centralised data warehouse, ensuring data quality and accessibility for analysis and reporting.
• Partner with cross-functional teams to meet their data needs, including the Executive team, SLT, and operational teams, to enhance reporting and impact measurement.
• Spearhead the migration of data warehousing and reporting capabilities to a cloud-based solution, improving data interoperability.
• Establish data governance policies, ensuring compliance with GDPR and other data protection standards.
• Design and implement dashboards, metrics, and KPIs to provide meaningful insights that align with the charity’s objectives.

Required Skills & Experience:

• Bachelor’s degree (or equivalent experience), preferably in a relevant field.
• Proven expertise in data governance, GDPR, and data compliance.
• Extensive experience with BI tools (e.g., Power BI, Tableau) and data visualisation.
• Advanced SQL skills and experience with Microsoft SQL Server, T-SQL, and data warehousing.
• Experience with Microsoft Business Intelligence stack (Power BI, SSIS, SSAS, SSRS) and Microsoft Azure.
• Strong understanding of cloud-based data warehousing and integration technologies (SOAP, REST, SOA).
• Demonstrated ability to translate complex data insights for non-technical audiences.
• Excellent communication, interpersonal, and organisational skills, with a track record of collaborating with diverse teams and stakeholders.

Key Attributes:

• Strategic thinker with a passion for data, capable of motivating and leading a team to achieve excellence in data solutions.
• Exceptional problem-solving skills, detail-oriented, and able to manage multiple priorities effectively.
• Able to work collaboratively with internal teams and external partners, aligning data initiatives with broader organisational goals.

Benefits:

• Flexible, remote working arrangement.
• Opportunity to make a meaningful impact within a charity-driven environment.
• Travel expenses covered for in-person meetings.
• Supportive, collaborative culture with a commitment to personal development and growth.

Application Process:

you’re ready to lead data-driven transformation within a charity environment, we’d love to hear from you. Apply today to take on a rewarding challenge that aligns data with purpose and impact.

Note: All applicants must have a valid driver’s license and be willing to travel as required.

As leading charity recruitment specialists and a certified B Corp™, Harris Hill is committed to high and ever-improving standards of equitable and inclusive recruitment. We actively welcome applications from all sections of the community regardless of age, disability, gender, race, religion, sexuality and other protected characteristics.

Data Insight Officer  
£26,813.56pa (FTE)

37.5 hours per week

About us:

At Bluebell Wood Children’s Hospice, we care for children and young people whose lives are just too short. Our aim is to reach every family that needs our help and to offer them the very best choice of care. Did you know that every year we need to raise £6.5m to keep our doors open and only around 16% of our income comes from government sources, the rest has to be raised through fundraising activity.

Our services include short overnight stays and community breaks at home or in the hospice. We also support the whole family from diagnosis with our multi-disciplinary Family Support team who provide counselling, sibling support groups, music therapy and much more. Our care team support these families in our modern, purpose-built building. All our rooms bedrooms have a homely feel. We have a sensory room, spa pool, cinema room and six acres of gardens.

We support families from a large geographical area, including South Yorkshire, North Nottinghamshire, North Derbyshire and parts of North Lincolnshire. The hospice is easily accessible from Barnsley, Rotherham, Doncaster, Sheffield and North Notts. We have free secure on-site parking for families and staff to use.

The role:

Are you passionate about using data to drive strategic decisions and make a real difference? Join our team as a Data Insight Officer!

At Bluebell Wood Children’s Hospice, we’re committed to making a meaningful impact, and data plays a critical role in achieving our ambitious goals. We’re looking for a Data Insight Officer to support our Income Generation team by providing data-driven insights, helping us optimise our fundraising and marketing efforts, and identifying opportunities for growth.

 

As the Data Insight Officer, you will:

· Analyse donor data to identify trends, patterns, and income-generation opportunities.

· Provide actionable insights to inform fundraising strategies and campaigns.

· Develop and maintain dashboards and reports to monitor key performance indicators (KPIs).

·         Generating income by collaborating with fundraising teams to design and evaluate initiatives.

· Manage and maintain the integrity of our CRM system (Donorflex), ensuring accurate data segmentation for targeted campaigns.

· Conduct market research to benchmark against industry standards and inform strategic planning.

· Prepare and present detailed reports and insights to senior management and board members.
 

What We’re Looking For:

Essential:

· Minimum 1 year of experience in data analysis, preferably within a fundraising or marketing environment.

· Proficiency in data analysis software and tools (e.g., Excel, SQL).

· Experience working with CRM systems (e.g., Donorflex, Raiser’s Edge) and data visualisation tools (e.g. Tableau,                Power BI).

· Strong analytical and problem-solving skills with the ability to interpret complex data sets.

· Excellent written and verbal communication skills.

· Strong organisational skills and attention to detail.
 

Desirable:

· Experience working within the charity or nonprofit sector.

· Familiarity with SEO strategies to support marketing and fundraising campaigns.

· Advanced knowledge of data visualisation and reporting tools.

Why Work With Us?
 

At Bluebell Wood Children’s Hospice, you’ll be part of a passionate team dedicated to making a positive impact. We offer a supportive work environment where your insights can directly influence our success. In addition to making a difference, we offer opportunities for professional development, flexible working arrangements, and the chance to be part of a mission-driven organisation.

We can offer the following benefits:

· 33 days’ annual leave with the option to buy and sell

· Sick pay

· Health Care Cash Back Scheme

· Free counselling sessions

· Enhanced maternity pay

· Enhanced paternity pay

· Enhanced parental bereavement leave

· Compassionate leave

· Salary sacrifice scheme

· Training & Development

· Investment in your wellbeing

· Volunteering & shadowing days

· Free parking on main site

· Free drinks and subsidised meals

· Time off in lieu

· Uniform

· Eligible for NHS Blue Light Card

· Eligible for The Company Shop

How to apply:

If you think you have what we are looking for, follow the link to our website where you can download and complete an application form.

Closing date: 2nd December 2024

Interviews:          11th December 2024

previous applicants need not apply

Your new company

Sussex Community Foundation Trust, the largest provider of community healthcare services in Sussex, is seeking to recruit two Data Engineers to join an established team of Data professionals in Digital Technology, based in Brighton, East Sussex.
Your new role

Working under the remit of the Head of Data Engineering as part of the Digital Directorate, the Data Engineers will be key members of the Data Engineering team working primarily on day to day ETL operations, as well as working with the wider Performance Team and Digital Team to meet the data management needs of the Trust.

As a Data Engineer you will be fundamental in developing and constructing data models for our services data warehousing needs as well as integrating them into systems and business processes to support self-serve reporting, compliance reporting and third-party data integrations.
You will provide specialist advice across a range of IM&T areas e.g. applications, information interpretation, data analysis, information reporting, information governance.

What you'll need to succeed

As an experienced Data professional with proven skills of managing and maintaining a data warehouse within a large organisation, you will have expertise in writing ETL scripts and code and ensuring that the ETL process performs optimally. The role requirement will involve implementing data flows to connect operational systems, data for analytics and business intelligence (BI) systems.

A key responsibility will be to re-engineer manual data flows to enable scaling and repeatable use in an automated way and to support the build of data streaming systems. You should have a thorough understanding of the concepts and principles of data modelling and metadata management, and you will need to be able to design, code and execute test scripts to support ETL processes defined within our platforms.

You should possess strong in-depth knowledge of Database Administration with MSSQL Server and expert knowledge of Microsoft Azure / AWS Platforms (Specifically Cloud Storage, Compute and Databases).

Applicants should have demonstrable experience in the following essential and desirable skills:
Essential:

Python 3.x with pandas, numpy, sqlalchemy, argparse and logging as a minimum
MS SQL Server (2019 and later)

Desirable:

Linux server technologies (Redhat 8+, Ubuntu 22.04+)
Qlik Data Movement Gateway (linux based)
Airflow orchestration across multiple technologies (e.g. powershell, python, t-sql) and server types (windows and linux, plus SQL server databases)
Airbyte data movement, including API driven data loading pipelines to dynamically construct the airbyte flows based on metadata concerning the data sources and destinations
Qlik Data Movement Gateway (linux based)
Qlik Cloud / Qlik Sense Data Architecture certification

What you'll get in return

This role is available for hybrid working and when a hospital office presence is required for technical workshops and other face-to-face purposes, it will include working in Brighton and Hove particularly, and other NHS premises across East and West Sussex. Being close to the sea and the South Downs, with close links to London, it is a vibrant, thriving part of the country in which to work and enjoy that all-important work-life balance through the generous annual leave and flexible working arrangements available. Amongst the unrivalled range of employee benefits includes membership of the renowned and industry respected NHS Pension scheme, and a choice of salary sacrifice discounts to supplement the competitive salary available for this role.

What you need to do now

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV in word doc format.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at hays.co.uk

Salary: £30,000 - £32,000
Contract: Full-time, permanent
Location: Home based (ideally in the UK)
Closing date: Weds 4^th December
Benefits: 32 days annual leave, flexible working, pension, health and wellbeing platform

We have a new opening for a Data Officer to join Animals Asia, working within their Data, Technology and Insight Team and reporting to the CRM and Data Manager.

Animals Asia is an animal welfare charity which is on a mission to make significant and lasting improvements to the welfare of animals across Asia. Last year the fundraising team raised a record breaking $18m globally and by continually improving their data capabilities they can continue to achieve their ambitious targets.

In the role of Data Officer you will create and deliver regular data marketing selections across email, mail and telephone campaigns. This includes importing data from a range of online and offline income streams and adhering to best practice and compliance guidelines. You will also manage the help desk for the Data, Technology and Insight team.

To be successful as the Data Officer you will need:

• Experience using a Fundraising CRM (Blackbaud CRM is preferred)
• Experience delivering data marketing selections and creating data imports from a range of sources
• Knowledge of SQL

If you would like to have an informal discussion, please email your interest along with your CV to [email protected].

Ashby Jenkins Recruitment are a specialist charity recruitment agency, we use our extensive sector knowledge and experience to match candidates to the most suitable charity jobs. We are passionate about improving equality across the sector, you can read more about our commitment to diversity here.

We take a relationship-led approach to recruitment in the charity sector and partner with you as the leading charity recruitment agency.

If enough applications are received the charity reserve the right to end the application period sooner.
 

Our partner is a well-respected advocacy INGO. They are seeking to recruit a Project Accountant to provide financial management support to project managers and their oversea offices.

Responsibilities

• Finance business partner to project teams and country offices, offering financial management support.
• Prepare project budgets, monitor expenditure and cashflows, and prepare management accounts, including variance analyses and supporting narrative reports.
• Grant management, compliance and reporting – preparing financial reports to donors, ensuring that these meet their requirements.
• Review the capacity of overseas offices, and support with capacity building as required.

• Ensure the integrity and operational effectiveness of project accounting procedures, developing, and maintaining these as required, and supporting and coaching junior staff as required.
• Supporting the broader finance team, including junior finance staff, in any ad hoc analysis, reporting and project work as required

Person Specification

• Accountant, qualified or QBE, with at least 5 years of experience in accounting, an understanding of accounting & finance principles and management accounting & reporting.
• Experience of project accounting, grant compliance & management is desirable; an understanding of the grant compliance & reporting requirements of the EU and German government grants is desirable.
• Strong IT skills, including advanced MSExcel skills. Competence in SQL an advantage.
• Strong communication (verbal and written) and interpersonal skills, including ability to communicate financial matters to non-finance staff.
• Quick learner, organised and flexible, able to meet tight deadlines.
• Fluent in English, with excellent spoken and reporting writing skills. Working knowledge of French or Spanish is highly desirable. Knowledge of German is not essential or required.
• Culturally sensitive
• Willingness to travel abroad.

This is an excellent opportunity for an accountant looking to get good grounding in project accounting & grant management within a large, complex INGO. For the right candidate, the organisation will offer sponsorship For those candidates outside of Germany, some relocation costs, including the cost of obtaining a permit (if required) will be covered.

Role Title: Reporting and Analysis Manager

Salary: £46,537 to £47,822

Location: London

Tenure: Permanent Full time

ActionAid UK is a member of the ActionAid Federation, an international charity that works with women and girls living in poverty. As part of the ActionAid Federation, we work with women and girls, our partners, and dedicated staff in 43 countries to end violence and fight poverty so that all women, everywhere, can create the future they want.

Are you a keen advocate of women and girls’ rights in emergencies?

Are you ready to revolutionise the way data shapes strategy and decision-making in the non-profit sector?

Then we'd love to hear from you!

ActionAid UK is seeking an innovative and analytical Reporting and Analysis Manager to lead the charge in transforming supporter insights into actionable outcomes that empower our mission to create a fairer, more equal world.

This is a role for someone who thrives on turning complex data into compelling narratives and actionable insights. With a focus on innovation and collaboration, you’ll lead the Reporting and Analysis function, harnessing the power of data to strengthen ActionAid’s fundraising performance and supporter engagement strategies. This role will be heading up the Reporting and Analysis Team part of the Data Team, this consists of  three sections: Data Warehouse, Data Management & Reporting and Analysis. Championing informed decision making based on analytical insight and evidence as well as proactively engaging with staff to make the best use of the insights provided by reporting and analysis, challenging employees to seek improvement in performance identified through analysis

Why This Role Is Exciting:

-Innovate with Impact: Use cutting-edge tools like SQL, Python, and Power BI to create dynamic reports and forecast models that inform strategic decision-making.

-Lead with Purpose: Manage and coach a Reporting Analyst to deliver high-quality insights, ensuring our fundraising strategies are driven by evidence and expertise. 

-Collaborate to Transform: Work cross-functionally with teams across ActionAid to influence and improve supporter engagement, while maintaining a digital-first, supporter-centric approach.

-Shape the Future: Use your data expertise to challenge, inspire, and guide colleagues, embedding a culture of data-driven decision-making across the organisation.

What We’re Looking For:

-Advanced knowledge and experience with SQL, Power BI, and Python to deliver impactful reporting and analysis (DAX to build dynamic reports in Power BI including semantic model design)

-Expertise in using data to influence fundraising and marketing strategies in a non-profit or similar environment.

-Exceptional communication skills, with the ability to bridge the gap between technical teams and non-technical stakeholders.

-A proactive and collaborative mindset

-Strong statistical knowledge and experience developing model-based analyses (regression, survival, clustering etc)

 

The successful candidate will have strong statistical knowledge and experience developing model-based analyses (regression, survival, clustering etc), playing a crucial role in developing and maintaining a suite of supporter data reports, analysis and models to help build our understanding of ActionAid’s supporters and fundraising performance, and to use this insight to influence, improve and challenge fundraising and supporter engagement strategies. 

Due to the nature of this role, the successful candidate will be asked to participate in criminal records checks at the point of offer.

Additional Information:

Diversity, Equality, Inclusion and Belonging:

Diversity, Inclusion and Belonging are key to our organisational culture. We are on a journey to become not only an anti-racist organisation but one that proudly

celebrates the diversity of all applicants and employees. We look forward to you bringing your full self to work, proudly sharing your unique perspective and helping us to shape our combined future. We especially welcome applications from those from underrepresented/marginalised communities.

AAUK is a disability Confident Committed organisation and as such any candidate that declares a disability will be shortlisted for interview if they meet the essential criteria for the role.

Referencing and Safeguarding:

All offers of employment will be subject to satisfactory references and appropriate screening checks, which can include safeguarding, criminal records and terrorism

 

finance checks. By submitting an application, the job applicant confirms their understanding of these recruitment procedures.

ActionAid UK is committed to preventing any form of sexual harassment, exploitation, and abuse (including child abuse and adult at-risk abuse) and responding robustly when these harms take place. We expect all ActionAid UK Staff and ActionAid UK Representatives to share this commitment. We will not tolerate our Staff or other representatives carrying out any form of sexual harassment, exploitation or abuse towards anyone we come into contact with through our work.

Working practices:

ActionAid is committed to supporting flexible working. If you would like to discuss flexible working options, including the possibility of a job share for this role, there will be space to do so during the interview process.

ActionAid UK has a hybrid working policy for many of our roles. The requirement will vary from team to team and the responsibilities of individual roles. As a minimum, all colleagues are expected to attend the office 12 days per year, plus additional time for induction, training, and “Company Connection days.” Some roles may require in- office attendance on all days and if so, these will clearly be marked as in-office

roles.

Please note that ActionAid UK does not offer fully remote working

options. We encourage you to discuss hybrid working expectations at interview.

Recruitment Processes:

Please note that ActionAid UK may review, shortlist and interview candidates prior to the closing date so we encourage all candidates to apply as soon as possible.

If we receive a very high response, we may close the vacancy early and will not accept further submissions.

Deputy Head of Strategic Planning (Statutory Reporting and Data) | £55,000 - £60,000 + benefits

For a large, London-based University, we are recruiting a Deputy Head of Strategic Planning (Statutory Reporting and Data) to lead the delivery of statutory reporting, and the data governance and data quality required to ensure accurate data submissions. This is a key role in compiling, completing and assuring data quality on Higher Education Statutory Returns such as HESA Student, Initial Teacher Training (ITT) returns and Unistats. The role will provide oversight to the entire University data lifecycle, ensuring it informs internal analysis and external returns via robust governance and accurate completion and submission of all data returns.

Main Duties:

• Lead the University statutory data returns processes
• Act as the champion for data quality, ensuring process redesign and quality assurance are robust
• Own the start-to-finish cycle of statutory returns including HESA Student, Initial Teacher Training (ITT) returns and Unistats
• Oversight of other statutory data returns e.g., HEBCI and EMR
• Support further implementation of HESA Data Futures for future returns and shift to in-year reporting
• Lead, motivate and manage a team of highly performing staff

Person Specification:

• Expert knowledge of UK Higher Education statutory data submissions including data collection and manipulation
• Track record of improving data governance and data quality
• Excellent knowledge of the Higher Education sector, its data, policy and regulations and requirements of statutory reporting
• Experience of the Individualised Learner Record (ILR) and external data requirements including OFS, HESA, HESES, TEF, SLC, EFSA
• Staff management, leadership and development
• Strong experience of data preparation, extraction and visualisation i.e., Alteryx, SQL, Power BI or tableau

________

As an employer, we are committed to ensuring the representation of people from all backgrounds regardless of their gender identity or expression, sexual orientation, race, religion, ethnicity, age, neurodiversity, disability status, or any other aspect which makes them unique. We welcome applicants from all backgrounds to apply and would encourage you to let us know if there are steps, we can take to ensure that your recruitment process enables you to present yourself in a way that makes you comfortable.

Job Summary
Return Fundraising is looking for an experienced Data Manager to lead the team responsible for overseeing all data services within the business. In this role, you will ensure that data is collected, stored, processed, and reported accurately and efficiently to support exceptional telephone fundraising.

The Data Manager plays a critical role in data compliance, processing, and analysing client data. During campaigns, the team produces exports to clients and third party suppliers, including payment processors and fulfilment houses, and supports the fundraising team to improve the fundraising results using data analysis and segmentation.

You’ll need to be experienced in data management, proficient with databases and Excel, and it would be advantageous to have familiarity with reporting tools and processing software.

Our preference is a hybrid role, working from home with 2 days a week in our London office, however consideration will be given to candidates who live further afield and are looking for a fully remote based position.

Consideration will also be given to a part time role of pro rata 32 hours per week over four days.

Return Fundraising

We were founded in 2015 by former charity employees, and today, we’re proud to be one of the UK’s largest telephone fundraising agencies.

Our team of specialised career fundraisers deliver sector-leading results, and we provide insight, strategy and tailored support to maximise the impact of our charity client’s campaigns.

Main Responsibilities

Data Processing

• Oversee data processing, ensuring data integrity, storage, and secure transfer practices align with industry standards.
• Manage data formatting, ensuring data is accurately prepared and uploaded for clients, suppliers, and our dialer system.
• Implement and maintain rigorous data quality checks, guaranteeing accuracy, completeness, and consistency across all data records.
• Ensure adherence to data handling best practices.

Compliance

• Oversight of data protection and GDPR / DPA2018 practices across the business, with the support of the Director of Data & Operations.
• Understanding of the Fundraising Regulator’s Code of Practice and making sure that day-to-day practices meet our high standards.

Analysis

• Analyse current and historic fundraising data to provide clear segmentation strategies which improve campaign effectiveness.
• Develop and monitor SQL-based dialling rules, adjusting based on performance metrics.
• Produce insightful reports for internal stakeholders, assisting in data-informed decision-making and operational improvements.

People Management

• Manage, develop, and support the Data Assistant, conducting regular performance reviews and one-on-ones.
• Provide training and guidance on data protection, data handling, and operational standards, promoting continuous learning and growth within the team.

Administration

• Maintain comprehensive data logs and prepare up-to-date process documentation.
• Identify and implement process improvements to streamline data operations and support overall business objectives.

Skills

Essential

• High-level proficiency in Excel and experience with structured data schemas.
• Proficient in data segmentation and analysis
• Understanding of data protection best practices
• Understanding and application of basic SQL
• Ability to thrive under pressure, manage conflicting priorities, and take ownership of responsibilities.
• Adaptable and positive approach to change.

Desirable

• Experience working with databases and project management.
• Understanding of fundraising and/or telemarketing sectors.
• Familiarity with reading dialler reports and making informed operational adjustments.
• Knowledge of the Fundraising Regulator’s Code of Practice.
• Experience with APIs and/or automation software such as Zapier.
• Line management experience, including training and development.

Travel

Occasional travel within London and the UK may be required for client meetings, conferences, and training events.

Offer

• Annual salary of £37,000 to £40,000 depending on experience and location
• Full time permanent contract of 37.5 hours per week Monday to Friday,
• Consideration will be given to a 32 hour week over Monday to Thursday, with a pro rata salary
• Hybrid working with flexible working from home and office days
• Consideration will be given to a fully remote position with a salary adjustment
• 25 days of annual leave (plus bank holidays), rising 1 day per year up to 30 days after five years of service
• Laptop, plus home working equipment including chair, desk and monitor
• Pension contribution of 3%
• A small business environment where you can make quick decisions and interact with everyone from managing director to fundraisers
• Being able to support some of the UK’s best charitable causes and raise vital funds they need to keep funding their projects

Do you have proven experience of data integration and ETL tools, strong Python, SQL and ETL knowledge and a good understanding of Data Lake and Microsoft Fabric and Synapse? Then join Shelter as a Data Engineer and you could soon be playing a crucial role at the heart of our Data and Insight team.

About the role

Right now, we’re looking for a technical expert with experience of developing and maintaining ELT pipelines to move data between enterprise applications (a mix of both in-house and external and on-prem and in the cloud). Day-to-day, you’ll be responsible for developing ETL processes using Fabric and Synapse linking from a variety of data sources to a wide variety of targets on-prem, cloud platforms and in Azure. We’ll also rely on you to ensure business requirements for new data feeds or changes are understood and translated into efficient and effective technical solutions. Exploring new ways to improve the efficiency and effectiveness of data management across Shelter will be important too, as will transforming and centralising raw data from multiple platforms into user friendly reporting data. Writing, validating and executing test plans, troubleshooting performance issues and supporting Shelter’s wider data management initiatives – all are aspects of this interesting and varied role.

Apply to be part of our team and be the change you want to see in society.

Benefits 

We offer a wide range of benefits, including 30 days of annual leave, enhanced family friendly policies, pension and interest free travel loans. Our employees also have access to a tenancy deposit loan, payroll giving, cycle to work scheme and an employee assistance programme.

Shelter helps millions of people every year struggling with bad housing or homelessness through our advice, support and legal services. And we campaign to make sure that, one day, no one will have to turn to us for help. We’re here so no one has to fight bad housing or homelessness on their own.

We are happy to talk about flexible working, personal growth, and to promote a workplace where you can be yourself and achieve success based only on your merit.

About the team

Our vision is for Shelter to have the high-quality data and insight required to describe the housing emergency, the impact we have fighting the crisis and the internal performance and health of the organisation. We want all of Shelter to have the skills and knowledge to use data as part of their everyday activities and make informed, transparent decisions with robust evidence, in an organisational culture that treasures its data because it recognises the value of it. This particular role sits within a Data and Insight team that’s been formed to bring together the skills and experience to achieve this vision as part of a  wider Technology and Data team within our Strategic Enablement directorate.

About Shelter

Home is a human right. It’s our foundation and where we thrive. Yet everyday millions of people are being devastated by the housing emergency.

We exist to defend the right to a safe home. Because home is everything.

We need ambitious, passionate people to join us. This is your chance to play a part in the fundamental change we are striving to achieve.

Our enemy is the social injustice at the core of the escalating housing emergency. To win this fight, we must be representative of the people we are here to help and those who support our movement. In all our people decisions, we take pride in being inclusive, equitable and transparent. We are committed to combating racism both within and outside Shelter. We welcome you on our journey to becoming truly anti-racist.

Safeguarding statement

Safeguarding is everyone's business. Shelter is committed to protecting the health, wellbeing and human rights of those we support, and enabling them to live free from harm, abuse and neglect. All our staff will be expected to observe professional standards of behaviour and conduct their work in line with our Safeguarding Policies. 

Shelter does not accept unsolicited CVs from external recruitment agencies nor accept the fees associated with them.

About Us: The Woodland Trust is the UK's leading woodland conservation charity and is dedicated to creating a world where trees and woods thrive for both people and nature. Our mission involves engaging and inspiring individuals to contribute toward tackling the nature and climate crisis through the protection, restoration, and creation of essential woodland habitats.

The Role: 

• As Infrastructure Architect you will be accountable for the specification, delivery, and assurance of all technology infrastructure, including data centre, network services, telephony, workstation management, servers, storage, and related software.
• This role is responsible for ensuring availability, integrity, and security of all IT infrastructure in collaboration with the Co Supply Partner, specifically their Solutions Architect.
• Working with colleagues across Digital Enablement, you will oversee the Co-Supply Partner's deployment of technology for various projects and any technological change impacting the infrastructure. 
• You will be pivotal in shaping and delivering our technology infrastructure. This role is not just about managing systems; it's about leading a team to create robust, scalable, and secure solutions that support our organisation's evolving needs. 
• A key focus will be to develop the team’s capabilities and ensure that infrastructure and security roles within the team are aligned with the need to support our ongoing transformation.
• This role includes a mix of working from home and at our main office in Grantham, Lincolnshire. Visits to Grantham would be required no more than once or twice a month on average, but may require out of hours project working.

The Candidate: 

• We are looking for a visionary leader in technology infrastructure who thrives in complex, dynamic environments and has a passion for driving transformation.
• You will have a hands-on management approach to ensure solution scalability, reliability and efficiency.
• You’ll be an experienced technical team leader with sound negotiation and influencing skills effecting a wide range of internal and external stakeholders
• You will be an architect of complex projects and programmes, designed in an inclusive and participatory manner.
• You will have experience in the following - Microsoft 365, Azure, SQL, Citrix, DevOps, Email Authentication and AWS
• Experience of other Cloud-based solutions would also be beneficial and you will be a strong advocate for Cloud-based ways of working across the organisation. 

Benefits & Wellbeing: Joining our team means you'll be a big part of tackling environmental and climate issues. We take good care of our staff, offering support and training opportunities. We also offer:

• Enhanced Employer Pension
• Life Assurance
• Flexible & Hybrid Working Options
• Generous Annual Leave
• Enhanced Parental Pay
• Employee Assistance Programme

Commitment to Diversity & Inclusion: The Woodland Trust embraces diversity and inclusion. We want our team to reflect the UK's diverse community. We support people from all backgrounds to apply, especially those who are under-represented.

Application Advice: Even if you don't meet every requirement of the role, we would encourage you to apply. Your enthusiasm for the environment and our core values—Grow Together, Explore, Focus and Make it Count—are what matter most. We also keep our candidates’ personal details hidden from the hiring managers, so they do not see your CV until shortlisting is completed. Make sure that your Personal Statement clearly shows your experience and passion for the role.

Apply Now: If you're ready to make a difference and grow with us, send in your application today. We might close the job opening early if we get a lot of applications, so it's a good idea to apply soon. We look forward to hearing from you and working together to make a positive impact on our planet.

Summary

• Provide administrative and logistical support.
• Ensure that details are up-to-date in the ministry discernment portal, maintaining records and providing reports using the people-related data with attention to current GDPR and NCIs policies.
• Act as the first point of contact and responding to enquiries received via the shared inbox for the discernment process from stakeholders and colleagues.
• Handling requests from work colleagues and stakeholders to give one-to-one advice and to resolve problems.

• An instinctive team player, able to work collaboratively whilst being able to use your own initiative to work individually.
• A positive, proactive attitude to all tasks approached.
• Highly professional approach grounded in graciousness, care and sensitivity to ensure consistency of tone in our engagement with internal and external stakeholders.
• Supportive of the work and Christian ethos of the Church of England.
• Very good IT skills with experience of working with web-based applications such as portals, SQL databases and virtual learning environments, as well as using MS Office and effective use of Teams and Zoom.

• A salary of £19,459 per annum (FTE £38,918) plus age-related pension contributions between 8-15% of salary. We will also match any pension contributions you make up to an additional 3% of salary.

• 25 days annual leave (increasing to 30 days within 5 years) plus three additional days
• Flexible working hours and location, with an expectation of just 1 day per week in our office in Westminster
• Structured induction programme and access to a range of development opportunities including apprenticeships
• Access to Occupational Health, and an Employee Assistance Programme
• Opportunity to the Civil Service Sports & Social Club, and get involved in a range of staff networks, groups and societies

• Strive for Excellence
• Show Compassion
• Respect others
• Collaborate
• Act with Integrity

Supporter Insight Analyst

Fixed term contract until Feb 2026 (12 months dependent on start date)

35 hours per week

£34,837.08 per annum (national weighting +travel into London office paid for) / £37,646.16 per annum (London weighting)

Location: Home based, with occasional travel into our London office

The Children's Society (TCS) has been helping children and young people for over 140 years. Everything we do is to create positive change in young people's lives. Our annual Good Childhood Report has shown that children and young people's wellbeing is declining. It's our organisational goal to reverse this decline by 2030.

The Audience Insight team is a key function to help us on this journey. We help the organisation to understand opportunities to grow support, deepen engagement with existing supporters and optimise our communications and fundraising products. We have an exciting opportunity in our team: we are looking someone exceptional to join as our supporter insight analyst for 12 months, while the permanent post holder goes on maternity leave. In this role, you will be responsible for generating actionable insight into supporter engagement to help us optimise our activities and communications; ensuring that we are talking to our supporters about the things that they're interested in, in the right media and with the right frequency and evaluating responses in order to continually improve and deepen our supporter engagement.

You will become an insight partner for colleagues across the social impact domain and will help to upskill colleagues to become confident data users to help create an insight culture at TCS.

To succeed in this role, you will have previous experience in an analyst role and be highly technical with strong SQL skills. You will have the curiosity and capability to use the wealth of data TCS has access to, to help us deepen engagement with existing and new supporter audiences. You must be go-getting and proactive, with strong communication and problem-solving skills.

You will be inquisitive and curious; always interrogating briefs to ensure we are asking the right questions of the data; and using your knowledge of data to go beyond the brief and add extra value.

This role sits within our Enabling Domain and reports into the Senior Supporter Insight Analyst. Our focus is on elevating young people's voices; challenging public perceptions of the challenges young people face; and attracting, retaining, and mobilising support through voice, time, and money. 

Essential Skills

-Minimum of 3 years' experience as a data analyst in a commercial or not for profit organisation

-Advanced excel user

-Proficient in using data to effectively tell stories to stakeholders, through clear and informative data visualisations in PowerBi or other dashboard software such as Tableau, as well as through PowerPoint.

-Strong communication skills and the ability to explain complex data findings to non-technical stakeholders and influence their decision making.

-Ability to build and maintain stakeholder relationships

-Ability to work autonomously and prioritise project and personal workload

Desirable Skills

-Knowledge and experience of the charity sector and/or fundraising data

-Experience of an additional programming language.

What we offer you in return:

-Opportunity to develop your skills as a data analyst and acquire/deepen your knowledge of fundraising data

-The chance to work in a small, supportive, team on projects with a big impact

-Space to bring creative ideas and approaches to how we use our data to influence supporter engagement

-Flexible and remote working from anywhere within the UK

-Enhanced Annual Leave: 28 days

The closing date for applications is at midnight on Thursday 28th November 2024.

We are hoping to hold interviews week commencing 9th December.

The Children's Society is committed to safeguarding and protecting the children and young people that we work with. As such, all posts are subject to a safer recruitment process, including the disclosure of criminal records and vetting checks. We ensure that we have a range of policies and procedures in place which promote safeguarding and safer working practices across our services.