Sql Jobs
£37,300 - £40,300 per annum
Permanent, full-time (37.5 hours per week)
Hybrid working with regular travel to our London Bridge Office
What the job involves
Ready to dive deep into the world of data and turn insights into action? Join our Customer Insight Team to do just that! We're not just about crunching numbers; we're about crafting innovative strategies that connect real needs with organisational goals, leading to impactful campaigns, and ensuring our audiences needs are at the heart of everything we do.
As our Senior Data Insight Analyst, you'll be at the forefront of understanding customer behaviour to steer our decision-making process. Working closely with our Data Insight and Analysis Manager, you'll devise the optimal approach to using our data to unearth valuable insights that inform our strategy and tactics.
What’s more - you'll be the driver of a variety of analyses that shape the future of our planning and review processes. Plus, you'll get hands-on in designing interactive business dashboards that bring data to life, fostering a culture of visual analytics across the organisation.
Further, you'll have the chance to expand your horizons by diving into our cutting-edge data science platform. Get ready to explore the world of machine learning and AI, building models that help us to better understand customer behaviour that will guide future campaign initiatives.
With collaboration across the organisation of high priority, you'll work closely with various stakeholders to optimise data usage, share best practice, and champion an insight-driven culture throughout the organisation. As a key member of the insight team, you'll lead the charge in prioritising data and insight in everything we do.
What we want from you
We're on the lookout for a Data Insight Analyst who's ready to dive deep into the world of data-driven decision-making.
If you're someone who gets a kick out of using data to tackle real-world challenges and shape organisational strategy, then you might just be the perfect fit for our team. You'll need to be comfortable working with large datasets, flexing your data mining and customer profiling muscles.
Experience-wise, we're looking for someone who's no stranger to analytics software like Tableau, Faststats, or similar tools. When it comes to databases, you should be fluent in SQL and have an ability to optimise the use of data from across various sources.
First-hand experience with CRM systems such as Raiser’s Edge would be advantageous, especially in the charity sector, and if you're curious about data science or even have experience in this area, even better.
Apart from excellent analytical skills, you’ll have an inquisitive mind and love solving problems. We are looking for a strong communicator, confident at delivering your analysis outcomes whether that’s to a room of colleagues or chatting with stakeholders, your ability to convey complex insights in a clear and compelling way will be highly valued.
So, if you're ready to join a team that's all about using data to drive change and make a difference, we want to hear from you!
Why work with us?
Every man needs to know about the most common cancer in men – prostate cancer. It’s a real and present danger that takes over 12,000 of our dads, grandads, brothers and friends each year.
Prostate Cancer UK is the largest men’s health charity in the UK. We have a simple ambition – to stop prostate cancer damaging lives. We invest millions in research to revolutionise testing, treatment and care. We’re blazing a trail to a screening programme that could save thousands of lives with regular, accurate tests for all men at risk. And we work tirelessly to spread the word about risk and offer specialist support to people living with the disease.
Work with us and you’ll see your efforts pay off as we give men and their families the power to navigate prostate cancer.
Our commitment to equity, diversity and inclusion
At Prostate Cancer UK, we believe that equity, diversity and inclusion are essential to building a strong and innovative workplace that represents, and can advocate for, the communities we support.
It’s our ambition to become an anti-racist organisation, and our mission to advance racial equity in the diagnosis and treatment of prostate cancer.
We’re continuously learning more about the needs of our colleagues, and have three amazing People Networks, sponsored by our Leadership team: Pride, Mind & Body and Multicultural.
Ways of working
Our hybrid working approach combines the best of flexible working – a positive work/life balance, inclusive and accessible platforms, and online information at our fingertips.
Next steps
More information on what we offer, as well as the role, can be found on our vacancies page. Please download our job profile document (job description) with our ‘How to apply’ section sharing the key points to refer to in your application and to apply, please visit the website via the apply button.
The closing date is Sunday 2nd June 2024. Applications must be submitted by 23:45 UK time.
Interviews: By arrangement. Currently scheduled for the week of Monday 17th June 2024.
Prostate Cancer UK is a registered charity in England and Wales (1005541) and in Scotland (SC039332). Registered company number 02653887.
- Job Title: Data and Insights Lead
- Closing Date: Monday 26th May
- Salary: £26,500 (plus £3,000 Inner London Weighting where applicable)
- Working Pattern: Full-time (37.5 hours per week)
- Contract: Fixed Term (Paternity Cover. 1st September 2024 - 31st December 2024)
- Reporting to: Head of Programme Quality
- Job Location: Remote (with regular travel to London Office as required)
About the organisation
We believe that every young person should have the opportunity to fulfil their potential and make the most of their education. We’re passionate about reducing the educational barriers our students face, helping them to pursue a career in their chosen field and follow their dreams.
Our mission is to support students from under resourced backgrounds to access top universities, through a unique combination of tuition and in-school mentoring. We work with them to make good applications, get the grades and transition to university.
The programme combats educational inequality and improves social mobility by raising students’ grades and supporting them to understand the pathway to a top university. Students who receive support from our programme are more than twice as likely to attend top universities as statistically similar students, according to UCAS.
The Access Project Values
Empowerment: We support students and our people to develop the skills and knowledge to accomplish their goals.
Courage: We encourage our students and our people to be authentic, innovative, and ambitious in order to reach their full potential and deliver our mission.
Impact: We evolve our programmes through an evidence-led approach, supporting our students to achieve their best outcomes.
Inclusion: We respect and value individuality and engage diverse voices to achieve our mission.
Ownership: We hold ourselves accountable in all our actions and efforts. We ask, “What can I do to improve my results?”
About the role
The Access Project is an evidence-based, data driven intervention. Central to our programme are the ways in which we use data to ensure each of our students receives the provision they need, to learn about how we can improve our delivery and to evaluate our impact on our students’ university prospects. We have developed sophisticated monitoring and evaluation systems bringing together data from a variety of sources to track students’ progress (impact management) as well as ascertain their outcomes (impact evaluation). We collect data on our students’ academic and socio-demographic background, their participation on our programme and progress on our bespoke university readiness scales, and their academic results and university destinations. We use this data to intervene in real time when delivery goes off-course but also to understand how The Access Project programmes affect student outcomes and publicize this impact externally.
As part of the Strategy and Impact Team, the Data & Insights Lead will be responsible for ensuring all teams have the right data and to deliver and monitor our programme in a timely and effective way. They will manage, analyse, interpret, and present data and information, most of it recorded on our Salesforce system, to enhance the quality of delivery, maximise the achievement of outcomes by participants and ensure that the project achieves the greatest possible social impact. They will also project manage distinct pieces of work ranging from system optimization to external reporting for impact-related projects and partnerships.
Duties and responsibilities
1) Ensure the efficacy of our monitoring & reporting systems
- Identifies required changes related to how we collect and manage data in Salesforce so that programme delivery data is available in the right format and at the right frequency to support decision making across teams and allow for accurate reporting.
- Make recommendations for changes to the Salesforce system in line with this and support the Operations Team with reviewing options.
- Support other teams to have the confidence and skills to effectively use our monitoring & reporting tools and processes for their specific needs.
- Identify required improvements to our data processes (e.g. processes for collecting/collating data, for automation, etc), and project manage their implementation.
2) Coordinate the use of data to guide tactical and strategic decision-making on programme delivery and design
- Define the key questions for our termly performance management meetings and input into the design and content of the dashboards used in these fora.
- Process and analyse data to derive useful insights about our programme delivery and present your findings effectively to various stakeholders to inform tactical conversations around programme design and delivery.
- Ensure data is understood and used effectively in decision-making.‘delve deeper’ into programme data to understand trends highlighted by staff, students, and school leaders.schedule performance management meetings at the right time, ensure the right stakeholders are involved, and capture and follow up actions from these meetings as required.
3) Lead other evaluation, research and reporting activities
- Ensure that student feedback is disseminated, analysed, shared, and used to inform ongoing performance management discussions
- Lead the data contributions throughout our annual impact evaluation process which may include the preparation of large datasets, as well as analysis and interpretation of data.
- Drive the monitoring and evaluation of pilot projects, e.g. development of monitoring tools and processes, data analysis, systems development, etc. prepare required datasets for external impact-related reporting. This includes tasks ranging from designing data collection processes, compiling the data, continuously adapting processes, and communicating effectively with all internal stakeholders.
4) Any other duties consummate with the role as required.
Person specification
Essential
- Highly numerate and analytical
- Excellent attention to detail
- Confident in data analysis, including handling large data sets using relevant software, such as Power BI, Tableau, SQL, SSRS, R, Stata, SPSS, or Excel
- Excellent database skills and confident in the use of Microsoft Excel for data analysis
- Experience in systems development and optimisation
- Ability to combine large amounts of data from a wide range of sources and to identify key points from a range of data outputs
- Ability to communicate complex information and processes in a structured and clear manner
- Experience of coordinating cross-organisational projects and processes
- A collegiate, diplomatic, and supportive approach to working with colleagues across the organisation
- A high degree of personal initiative and a solutions-focused mindset
- Ability to manage time effectively and deliver to regular deadlines for multiple audiences
- Highly efficient and able to quickly perform administrative tasks
- A commitment to delivering high quality work
Desirable
- Knowledge and/or experience of impact evaluation
- Knowledge and/or experience of Salesforce CRM
Benefits:
• 25 days annual leave p.a. (pro rata) plus Bank Holidays and Christmas closure.
• PerkBox – offering nationwide shopping discounts, gym memberships, holidays, learning and much more.
• Employee Assistance Programme, a 24-hour helpline for staff
• Online Medical assistance – access 24/7 to a qualified GP within minutes, with referrals and prescriptions available same-day.
• Interest-free travelcard loans
• Cyclescheme loans
• 3 paid Volunteering Days
• Employer’s pensions contributions (3%)
• CPD options
• The Access Project welcomes requests for flexible working arrangements
Safeguarding Statement
The Access Project is committed to safeguarding and promoting the welfare of children and young people and expects all staff and volunteers to share this commitment.
Equal Opportunities Statement
The Access Project is an equal opportunities employer and we welcome applications from people from all backgrounds. We are working towards improvements with equality, diversity, inclusion and belonging.
Disclosure of a Criminal Record
The Rehabilitation of Offenders 1974 (Exceptions) (Amendment) Order 1986 applies to posts where there is access to children. This means that applicants for employment that involves working with children and young people must disclose anything listed in their criminal record, with the exception of protected cautions and convictions. All Disclosures are carried out in the strictest confidence and are made only in connection with your application for employment and for no other purpose. The application for a DBS check at a level appropriate to the job role will be activated before your first day of work. Members of staff who are not eligible for a standard or enhanced DBS check are required to undertake a basic DBS check only in line with legal requirements. If you are selected for appointment to the role, you will be subject to this procedure.
Present or most recent employment
It is important to give full information, including the organisation you work in, or most recent employment if not currently working, full dates, address and explanation of any gaps in employment.
References
All appointments are subject to verification of employment and suitability of the candidate for the post applied for. We reserve the right to approach any previous employer for a reference and to verify their identity but will request your permission before doing so. If you have experience of working with children, please include this as one of your references.
Education, Qualifications and Training:
● Ensure you give all the information requested, including dates, establishment where you studied and make clear the level of any examinations e.g., GCSE, GCE 'O' Level or 'A' Level or equivalents etc. and the grades you obtained. Also include any skills training you have had. You will be required to produce original documentary evidence of any qualifications relevant to the job, and these will be detailed on the person specification.
● Proof of qualification is required before the appointment is confirmed.
The client requests no contact from agencies or media sales.
Psychometrician
£21,012 pa plus excellent benefits (£52,530 pa FTE)
Aldgate, London
14 hours per week
We are seeking a Psychometrician for two days per week to lead psychometric analyses and interpret the examination results of the Royal College of Pathologists.
The College is responsible for the delivery of pathology examinations for doctors, scientists, oral pathologists (dentists) and veterinary pathologists in 17 specialties – the Fellowship examinations of the Royal College of Pathologists (FRCPath). The FRCPath Part 1 is held online and is a test of knowledge while FRCPath Part 2 is held in person around the UK as well as in the Republic of Ireland and, for histopathology, in international centres such as Dubai and Egypt. The College is regulated by the General Medical Council for the medical examinations and the General Dental Council for the Oral and Maxillofacial Pathology examinations, but the examinations are open to all appropriately qualified candidates.
The FRCPath examinations are held twice a year in Spring and Autumn and attracts approximately 1,200 candidates per session across the specialties. While some examinations attract up to 200 candidates, some examinations consistently attract very small numbers of candidates, with a number of examination cohorts sitting somewhere in between. The Psychometrician will advise on the appropriate data collection methods for the examinations and undertake psychometric analyses of appropriate examination data for each examination session and will, in time, be asked to provide analysis of longitudinal data.
As the College continues to develop its examinations, the Psychometrician will possess sufficient expertise to provide advice on the appropriate psychometric tests to undertake for the specialty examinations as different formats or methods of delivery are considered.
The examinations are delivered by an examinations team in the College which sits within the Learning Directorate. Each specialty examination is supported by an appropriately qualified panel, led by a Panel Chair, all of whom are overseen by the Clinical Director of Examinations (a pathologist). The Psychometrician will be expected to communicate with a wide range of individuals regarding the College examinations, with varying levels of knowledge about psychometrics, and will provide training for examiners and staff on a regular basis.
The College is a professional membership organisation dedicated to the advancement of the science and practice of pathology. There are currently approximately 12,000 members, all of whom are pathologists based in hospitals, universities and laboratories in the UK and overseas. The College’s main tasks are to set and maintain training standards for doctors and scientists, to advice on the appointment of consultant pathologists, to ensure the membership is kept up to date with current practice through the continuing professional development scheme, and to promote the latest developments in pathology by holding scientific meetings.
The College’s mission is to promote excellence in the practice of pathology and to be responsible for maintaining standards through training, assessments, examinations and professional development.
We offer attractive staff benefits including 25 days annual leave (pro rata) rising with length of service, an employee discount scheme, and season tickets, as well as a cycle to work scheme. The College values diversity, welcoming applications from all members of society. We offer a mix of remote (home) and office working, with hybrid working arrangements currently in place.
Closing date: 9am, 3 June 2024.
Interviews: 18 June 2024.
The client requests no contact from agencies or media sales.
Closing date: 16th May
Contract: This is a fixed term contract opportunity for 6 months, covering maternity leave.
We reserve the right to close this vacancy early if we receive sufficient applications for the role. Therefore, if you are interested, please submit your application as early as possible.
The purpose of this role is to enable the migration, development and support of data integrations across The Society, within our strategic data integration tool. Integrating data from both internal and external systems, the Data Integration Engineer will play a crucial role in the evolution of our Data Integration Strategy.
Helping to build and support a well-defined data integration framework that will manage the Society’s data movements, is fundamental to the success of our Data Strategy, and will enable the Society to work efficiently and effectively.
Alzheimer's Society have recently been named on the Sunday Times Best Places to Work 2023! We have achieved excellent scores for workplace happiness, pride, and job satisfaction. This is a fantastic achievement and we're incredibly proud as this is fantastic indication of how far we’ve travelled over the past few years.
We would love to welcome more outstanding people to join our exciting journey to make the greatest difference for people affected by dementia.
About you
- Experience of ETL tools such as Azure Data Factory or SSIS
- Experience in building automated data integrations
- Experience of working with a variety of data sources (e.g. SQL Server, Salesforce, APIs, JSON, csv, Excel) and data destinations (e.g. SQL Server, Salesforce, emails, files).
- Extensive experience of data mapping and data transformation
- Experience of defining and implementing development standards and change management procedures
- Advanced SQL skills (with SQL programming experience such as T-SQL or PL/SQL highly desirable)
- Detailed working knowledge of Data Protection regulations
- Experience of cloud-based data technologies (e.g. Azure)
About Alzheimer's Society
At Alzheimer's Society, we believe passionately that life doesn't end when dementia begins. We are here for anyone affected by dementia, and we do everything we can to keep people with dementia connected to their lives and the people who matter most.
Everything we do is shaped by people affected by dementia. Their knowledge and experience are critical to bringing about real-world solutions. From choosing the most promising research through to telling their stories to raise awareness; they are the heart of this organisation.
We are excited to be working with a fantastic international charity to recruit an experienced Data Engineer within their established team, creating and developing integrations and contributing to the build and development of their warehousing, you will work in a warm and collaborative team.
As the Data Engineer, you will use your skills to define strategies for extracting data from the business systems and build optimised data pipelines for the expanding warehouse. You will be responsible for the development of centralised data solutions and work effectively with business users, analysts and internal colleagues to understand and identify requirements and the impact of changes to the data pipelines. This organisation is very flexible in their approach and happy to look at hybrid working arrangements, attending the office a couple of times a month.
As the Data Engineer you will need:
- Extensive SQL and T-SQL skills and ETL tools
- Experience in data mapping and transformations
- Strong communication skills, verbal, face-to-face and in writing
Salary: £45,000
Contract: Permanent Full time
Location: Homeworking or Hybrid in London
Closing date: Ongoing
If you would like to have an informal discussion, please call Chloe on 02030 062787 or email your interest along with your CV to [email protected].
Ashby Jenkins Recruitment is a specialist charity recruitment agency, we use our extensive sector knowledge and experience to match candidates to the most suitable roles. We take a relationship-led approach to recruitment, working ethically, and supporting people to find their perfect role within the not-for-profit sector.
We are passionate about improving equality across the sector, you can read more about our commitment to diversity here.
If enough applications are received the charity reserves the right to end the application period sooner.
Are you a Data Migration expert looking for some interim work?
We are delighted to be working once again with a prestigious health charity as they search for a Data Migration Specialist to lead the implementation of their new MS Dynamics CRM. You will be tasked with setting up all functionality for the ongoing use of this CRM including utilising SQL, Python alongside KingswaySoft tools to import and export data accurately and efficiently from various source systems. You will also manage a complex range of internal and external stakeholders so strong influencing skills will be a real asset.
You will need:
- Proven experience in SQL database development and data migration projects
- Experience of utilising KingswaySoft or similar ETL tools
- Ability to convert technical information to a range of audiences
- Strong attention to detail, analytical thinking, problem solving and internal stakeholder management skills
Salary: £50,000 – £55,000
Contract: 3- 6 months (Part time or full time)
Location: Remote or Hybrid
Deadline: ASAP
If you would like to have an informal discussion, please call Chloe on 02030 062787 or 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 roles. We take a relationship-led approach to recruitment, working ethically, and supporting people to find their perfect role within the not-for-profit sector.
We are passionate about improving equality across the sector, you can read more about our commitment to diversity here.
If enough applications are received the charity reserve the right to end the application period sooner.
We currently have an exciting opportunity for an experienced individual to join our team as a Power BI Developer. You will join us working 35 hours per week, on a permanent basis and will be based remotely. In return you will receive a salary of up to £43,003 per annum plus excellent benefits.
Since 1927, Cats Protection has helped thousands of cats each year, across the UK. As a community of volunteers, employees, supporters and partners, we’ve improved the lives of millions of cats and transformed the way millions of people see and care for cats.
The small yet busy Solution Delivery Team is expanding from six to ten employees, sitting within the IT Department. The team work within Cats Protection to identify issues and provide technical solutions, utilizing both off the shelf products or in-house developed solutions as required. Internal solutions are built using a range of technologies focused around the Azure Stack, including low code/no code solutions, the Power platform, T-SQL and other technologies as required.
Responsibilities of our Power BI Developer:
As a Power BI Developer you will be working with a number of departments within Cats Protection to understand their data and reporting requirements. You will need to identify any quality issues with their data, as well as work with the departments on how best to resolve historic data issues and improve processes to ensure future data is captured to a high standard. The data will then need to be moved in to our Power BI platform where you will create user friendly and accurate reports to show this data.
Current projects include:
- Supporting existing reports and dashboards for Neutering Finance to track processing times and backlog
- Building a number of reports for our Volunteering teams to track foster home inspections, volunteer availability, and surveys of the volunteers
- Supporting a network of Power BI Champions within the organisation, providing them with data and supporting them in finetuning reports to better inform decision-making
What we’re looking for in our Power BI Developer:
- At least 3 years of experience using Power BI and extracting data from SQL, Excel and SharePoint.
- Experience presenting data in a format that users can understand
- Knowledge of the PowerApps platform
- Knowledge of Azure Data Factory and ETL processes
- Someone with a logical, analytical approach to problem solving
- Knowledge of the appropriate professional and/or legal data standards
- A customer focussed individual
- A keen eye for detail, ensures all work is carried out to a high standard
What we can offer you:
- salary of up to £43,003 per annum plus excellent benefits
- generous annual leave entitlement
- Flexible working options
- life assurance scheme
- range of health benefits including private healthcare
- Employee Assistance Programme
- and more
Through our values and behaviours we help people see the world through cats’ eyes. Together we can make a difference.
Unfortunately, we cannot accept applications or CVs that are emailed to us directly.
Closing date: 13th May 2024
Virtual interview date: 21st & 22nd May 2024
Applications may close before the deadline, so please apply early to avoid disappointment. Please note, applications received after the closing date may not be responded to.
Please email if you require any adjustments to be made for you to complete your application or to participate in the recruitment journey.
About us
Crisis is the national charity for people experiencing homelessness. We know that homelessness is not inevitable. We know that together we can end it.
To help achieve our mission, Crisis is looking for a Data Insight Analyst to join the Data, Digital and Technology team. We are embarking on a project to change our CRM to Microsoft Dynamics and to move our Database onto Azure. To account for this changing infrastructure, the Insight team will work on updating our suite of reports, largely based in Power BI.
Contract: 12 Month fixed term contract, maternity cover
Location: London office (you will be required to work from the London office once a week or twice a fortnight in line with Crisis’ Hybrid Working policy)
About the role
As a Data Insight Analyst, you will assist in updating and creating PowerBI dashboards and apps. You will collaborate with colleagues across the organisation to gather requirements and develop reports that enable accessible monitoring of key metrics. As our current suite of dashboards need to be reworked, this role offers a good opportunity to shape a data visualisation project from start to finish, helping Crisis make evidence-based decisions in our pursuit to end homelessness.
About you
To be successful in this role you will have excellent communication skills, particularly when it comes to conveying complex, quantitative information to a non-technical audience. You will be able to identify requirements and deliver synthesised findings in an accessible and engaging manner. Additionally, you will have technical experience in PowerBI and SQL, from querying relational databases to building impactful visualisations.
You may also have experience working with Microsoft Dynamics, Azure SQL Database, website analytics, product analytics, customer analysis, digital analytics, Jira, data science, Tableau, Python/R or excel.
We believe diversity is a strength, and our aim is to make sure that Crisis truly reflects the communities we serve. We are actively working towards our organisation being a place where everyone can thrive and make their best contribution to our mission of ending homelessness for good. We know that the more perspectives, voices, and experiences we can bring to this work, the better. We particularly welcome applications from people who have lived experience of homelessness, and people from all marginalised groups, communities, and backgrounds.
Working at Crisis
As a member of the team, you will have access to a wide range of employee benefits including:
-
Interest free loans for travel season ticket, cycle to work, and deposit to secure a tenancy.
-
Pension scheme with an employer contribution of 8.5%
-
28 days’ annual leave
-
Enhanced maternity, paternity, shared parental, and adoption pay.
-
Flexible working around the core hours 10am-4pm
-
And more! (Full list of benefits available on website)
Alongside our excellent staff benefits, we will support your ongoing development to build your skills, experience, and career.
When you join us, you will have the opportunity to join our staff diversity networks, which aim to champion issues across the organisation, enable staff to be their authentic and best selves and contribute to making Crisis a truly diverse organisation.
How to apply
If this sound likes the opportunity for you, please click on the 'Apply for Job' button below.
Closing date: Tuesday 21 May 2024 (at 23:59)
Interviews will be held on W/C 3 June 2024
Accessibility
We want our recruitment process to be as accessible as possible. If you need us to make an adjustment or provide additional support as you apply for a role, please email our Talent Acquisition team to discuss how we can help.
Registered Charity Numbers: E&W1082947, SC040094
The client requests no contact from agencies or media sales.
The Web Designer / Developer will be responsible for the design, layout and coding of websites. You will be involved with the graphical and technical aspects of websites and also the maintenance and update of existing ones. You will directly report to the Directors, cooperating with the social media/marketing team.
You will design captivating and compelling work that supports and drives Al-Khair Foundation’s consistent and meaningful media coverage to continually promote greater public awareness of the organisation.
Main Responsibilities:
- Write the programming code, either from scratch or by adapting existing website software and graphics packages to meet business requirements
- Monitor the website’s performance and identify any technical problems
- Collect and analyse site analytics
- Ensure on-page SEO
- Discuss technical solutions with clients and providing innovative new ideas to solutions
- Work on future products, including creating an intranet for staff
- Maintain a high awareness of industry’s issues and trends.
For further information and to apply, please click the 'How to apply' button and follow the instructions.
We are seeking a Head of IT to lead the technical delivery in support of our IT strategy. This is a new role and will be our first standalone IT member of staff. You will shape the IT support and infrastructure for the charity, deliver an excellent day to day service, manage the relationship with our Managed Service Provider (MSP), take responsibility for cyber security and training and, alongside project teams, support the implementation of new technology to the service.
You will have strong people skills and be able to form effective working relationships with colleagues across the charity in order to deliver an excellent IT service. You will have a hands-on approach and enjoy working in partnership with a range of people. You will also have good knowledge and experience of IT infrastructure including Azure.
London’s Air Ambulance Charity continues to develop a supportive and enabling environment that gets the best out of our people. We promote a culture of progression and professional advancement offering a range of learning and development opportunities. In addition, we offer flexible working options, wellbeing packages and family friendly employment policies.
The role is offered on a full time, permanent basis. LAA offers a hybrid working arrangement, with time spent at our offices and at home.
If you think this role is for you, apply today or contact us for an informal discussion.
We pride ourselves on our dedication to being an employer that values diversity, we firmly believe that each team member can provide a unique perspective and valuable contribution to the lives of the people we serve, applications from individuals are encouraged regardless of age, disability, sex, gender reassignment, sexual orientation, pregnancy and maternity, race, religion or belief and marriage and civil partnerships.
The client requests no contact from agencies or media sales.
FULL-TIME JOB VACANCY
SENIOR MANAGER, ANALYTICS AND INSIGHT
Development and Outreach Department
Multiple Office Locations Considered
Application Deadline: 4 June 2024
The Fundraising Systems & Data Analysis (FSDA) team of the Development and Outreach Department of Human Rights Watch (HRW) is seeking applicants for the position of Senior Manager, Analytics and Insight. The Senior Analytics and Insight Manager will be responsible for instilling a data-driven and data-informed culture to make evidence-based decisions, increase efficiencies, improve overall departmental return on investment (ROI), grow new fundraising streams, and achieve long-term profitability.
The Senior Analytics and Insight Manager will generate, improve, and analyze fundraising data, both quantitative and qualitative, from internal and external sources to produce strategic information that supports data-driven and informed decisions, tactics, and strategies that consistently maximize HRW fundraising results. This role will feed into both the quarterly reforecasts and annual budget data and supporting methodology and collaborating with the Finance team as needed for the Development department.
This full-time position will ideally be based in either the United States or Europe, preferably in one of the cities where HRW has an office and will report to the Managing Director of Fundraising Systems and Data Analysis based in London. The Senior Analytics and Insight Manager will manage at least one direct report.
The successful candidate may have the option to work remotely but is expected to work from the office 1-2 times a week. We aim to be as flexible and supportive as possible in both the recruitment for and onboarding of this position.
Responsibilities:
Product Management Oversight:
1. Provide strategic, tactical, and operational planning of all Business Intelligence (BI_ Systems and tools utilized by the Development Department;
2. Implement and build the BI structure of the Development Department, working closely with CRM (Salesforce) team and working with vendors as needed to understand the desired outcomes;
3. Partner with the Training & Support team to promote user adoption of BI reports by developing and implementing communication plans, training campaigns, and incentives to encourage staff engagement and utilization;
4. Ensure effective coordination and change management with Training & Support, CRM and Digital products, IT, and fundraising teams;
5. Act as the subject matter expert for all areas of fundraising reporting and respond to escalated queries and reporting discrepancies from Data Analysis Officer;
6. Develop project management processes to support the prioritization of all analysis, data selection, integration, and reporting requests, ensuring the briefing processes are understood and developing a Service Level Agreement (SLA) framework as needed; and
7. Support on Data Integrations and Application Interface Programs (APIs), including any Extract Transform and Load (ETL) processes as needed, working with the Data Quality and Integrations Officer to develop these to meet “fit-for-purpose” requirement. Support both the CRM and Digital Product Managers as needed.
Data, Analysis and Reporting:
1. Support the development and implementation of the long-term data and insight strategy for HRW which improves data quality, deepens the department’s institutional memory, and aligns with the broader HRW data strategy;
2. Develop and present actionable insights, strategic recommendations, and business intelligence from analytical output to support strategic decisions for the Development team and on investments and benchmarking activities;
3. Deliver the data and insight strategy including activity reporting, financial forecasting, specialist report development, and ad hoc analysis projects and data selections, to increase understanding of activity, supporter and financial trends and making recommendations to leadership to deliver improvements;
4. Collaborate with the Marketing Team to create data selections including recommendations on which are the best targets for direct marketing campaigns, create segments according to strategically determined criteria, data model, and develop testing plans to yield statistically significant results;
5. Work with the Fundraising Systems and Data Analysis Managing Director to build tools and reports that allow for both the forecast and budget revenue projections to be provided with ease. Create multi-year fundraising projections per main channel and audience using historical data, statistical modelling techniques, and new initiatives;
6. Collaborate with the Finance team around both the production and validation of financial reporting, including budgeting, reforecasting, and income reporting in general for the Development D Ensure that the Marketing coding / attribution processes are clearly documented and any exceptions tracked with the Revenue Operations teams;
7. Ensure that the expenditure budget for the Development Department is managed and reported on effectively, capturing the planned spending across the different teams within the department, including reporting on the actuals and investigating any variances with finance and the budget holders as needed; and
8. Ensure that the Leadership Gift data reporting can occur, through development of advanced visualizations including dashboards and ensure that hygiene initiatives are followed by supporting both the Data Quality and Integrations Officer and Relationship Manage Work with Finance on the monthly reconciliation processes.
Leadership, Training, & Support:
1. Lead improvement projects that shape the department’s effectiveness, efficiency and data-driven decision making;
2. Serve as subject matter expert to both the CRM and Digital Product Managers as they proactively assess users’ evolving system needs, priorities, capacity, and workflows, and ensure reporting needs are well articulated to inform future technology enhancements; and
3. Teach and mentor Data Analyst and Data Integrations staff to grow their capabilities within the fundraising CRM, data, and operations field.
Other:
1. Carry out other duties as required.
Managerial Responsibilities:
1. Provide leadership, motivation, and mentorship to the Data Analysis, Quality and Integrations team, setting clear expectations, performance objectives, and providing regular and constructive feedback;
2. Foster an inclusive, creative, and positive work environment, encouraging diverse perspectives and participation in diversity, equity, and inclusion efforts, while proactively addressing bias, discrimination, and microaggressions;
3. Model inclusive behavior and consistently adhere to HRW's internal values;
4. Incorporate diversity, equity, and inclusion values and initiatives into the work of the Data Quality and Integrations team; and
5. Collaborate with staff to develop initiatives aimed at movement-building and expanding partnerships with diverse clients, donors, stakeholders, and partners.
Qualifications:
Education: A bachelor’s degree or equivalent work experience.
Experience: A minimum of five (5) years of relevant experience working in fundraising data analysis or business data analysis is required. Knowledge and experience in nonprofit fundraising and marketing, preferably in a global INGO context with country-specific fundraising operations, is highly desirable.
Related Skills and Knowledge:
1. Fluency in fundraising practices, terminology, technologies, channels, and compliance, and the ability to translate easily between fundraising end users and technology providers is required.
2. A critical thinker with the confidence to transform data and information into structured systems and reports is required.
3. Record of generating buy-in from, and exceeding expectations of, internal and external stakeholders is required.
4. Hands-on experience with data analysis, quality, cleansing, extracting, and validation (ETL) processes and tools is required.
5. Fluency in SQL or similar database query language is required. Experience with unstructured data is a plus.
6. Knowledge of both using and configuring Application Program Interfaces (APIs) to perform data integrations between multiple systems is required.
7. Strong understanding of Business Intelligence platforms, report and dashboard construction and data modelling and segmentation within the fundraising data context (Power BI or Tableau is Desirable) is required.
8. Hands on experience with working with INGO CRM systems is required. Salesforce experience is desirable.
9. Excellent verbal and written communication skills in English, and the ability to present complex issues in a clear, concise and persuasive manner to business and technical professionals, and to staff for whom English is not their first language is required.
10. Ability to work collaboratively and build trust with diverse stakeholders globally, including staff for whom English is not their first language, is required.
11. Strong understanding of nonprofit fundraising processes, strategies, and best practices is required.
12. Experience in vendor management is desirable.
13. Detail-oriented with excellent problem-solving and troubleshooting skills is required.
14. Ability to work collaboratively with diverse stakeholders and teams is required.
15. Strong project management skills and the ability to manage multiple priorities is required.
16. Demonstrated experience managing teams ensuring motivation and high-performance levels is required.
17. Demonstrated ability to manage multiple priorities and work in a fast-paced environment is required.
18. Advanced knowledge of Microsoft Office software, particularly Excel, is required.
Salary and Benefits: HRW seeks exceptional applicants and offers competitive compensation and employer-paid benefits. HRW offers a relocation assistance package and will assist employees in obtaining necessary work authorization, if required; citizens of all nationalities are encouraged to apply. If this position were to be based in the United States, the salary range would be USD 88,000-96,000. Salary ranges outside of the United States vary based on location.
How to Apply: Please apply immediately or by 4 June 2024 by visiting our online job portal at HRW official website and attaching a letter of interest and a CV or resume. No calls or email inquiries, please. Only complete applications will be reviewed and only shortlisted candidates will be contacted.
If you are experiencing technical difficulties with your application submission, or if you require a disability-related accommodation e-mail us. Due to the large response, application submissions via email will not be accepted and inquiries regarding the status of applications will go unanswered.
Human Rights Watch is strong because it is diverse. We actively seek a diverse applicant pool and encourage candidates of all backgrounds to apply. Human Rights Watch does not discriminate on the basis of disability, age, gender identity and expression, national origin, race and ethnicity, religious beliefs, sexual orientation, or criminal record. We welcome all kinds of diversity. Our employees include people who are parents and nonparents, the self-taught and university educated, and from a wide span of socio-economic backgrounds and perspectives on the world. Human Rights Watch is an equal opportunity employer.
Human Rights Watch is an international human rights monitoring and advocacy organization known for its in-depth investigations, its incisive and timely reporting, its innovative and high-profile advocacy campaigns, and its success in changing the human rights-related policies and practices of influential governments and international institutions.
The client requests no contact from agencies or media sales.
Closing Date: 10 May 2024
Position Ref: DC 1224
We have an exciting and unique opportunity for a Data Management Officer to join the Home Energy Scotland (HES) Data Team. You will assist the Home Energy Scotland team to deliver Scottish Government Programmes, by managing and reporting on the information exchange between the Energy Saving Trust and third party delivery partners.
Who we are
Energy Saving Trust is a leading and trusted organisation, dedicated to promoting energy efficiency, low carbon transport and sustainable energy use. We aim to address the climate emergency and deliver the wider benefits of clean energy as we transition to net zero.
At Energy Saving Trust we don’t just offer jobs – we offer careers. For our people, being part of the effort to address the climate emergency makes working for us truly meaningful and rewarding.
Here are some of the benefits we offer:
• We offer an outstanding pension scheme including employer contributions of up to 9%, 11% or 13% (age-linked).
• Enhanced parental leave.
• Private BUPA insurance.
• 25 days annual leave plus bank holidays, with service-linked increases as well as three goodwill days over the Christmas period.
• Staff wellbeing allowance of up to £25 per month / £300 per year.
Please see our careers page for the full list of benefits we have to offer and why Energy Saving Trust is a great place to work.
The team
Our team in Energy Saving Trust manages the national Home Energy Scotland service on behalf of the Scottish Government. Joining our team means joining an award-winning advice service that supports hundreds of thousands of households across Scotland every year to make their homes warmer, more affordable, and sustainable.
The climate emergency and the current fuel price crisis means the work of Home Energy Scotland has never been more important. Our team is making a real difference to people’s lives, and we are also growing rapidly. We need to recruit more skilled and dedicated people to join our team now.
Our team collaborates widely with colleagues in Energy Saving Trust, staff across the Home Energy Scotland network and many other partners across Scotland. You will be working with people and organisations to help tackle fuel poverty and the climate emergency, both directly, and through a network of regional advice centres covering all of Scotland.
What you’ll do
Working in support of the successful management of HES advice centre network, you will be primarily responsible for the collation, management of and reporting on external stakeholder-supplied data. You will also assist with wider HES reporting activities and provide direct support to other Energy Saving Trust staff on HES related issues as required.
What you’ll bring
You will have good data manipulation skills using varying tools and formats, including experience with SQL and Excel. Full training will be given. So, if you like a Power Pivot and know your inner join from an outer, get in touch.
To apply
Please click 'apply online' to visit our recruitment portal. We will ask for your personal details, work history and a supporting statement. Applications submitted without a supporting statement will not be considered.
Applications close 23.59, 10 May 2024. Interviews are intended to be held the week commencing the 15 May 2024.
Applications submitted via email will not be considered. In your supporting statement please explain how you meet the essential areas in the job description.
Reasonable adjustments: We are a Disability Confident Committed employer. We want to ensure that our recruitment process is inclusive of and accessible for, everyone.
If you think you may need additional support or reasonable adjustments made to any part of the recruitment process, please get in touch.
Flexible working: We offer a range of flexible working arrangements, including working from home, compressed or part-time hours, job shares and other arrangements. There is no need to justify your preferred working pattern and we encourage our people to work in whichever way helps them to perform at their best.
We will be happy to discuss this and our blended working model at the interview stage with you.
Please note, that we are unable to provide visa sponsorship for this post. To apply for this post, you must be able to demonstrate your eligibility to work in the UK.
Diversity and inclusion
Energy Saving Trust is committed to creating a diverse, inclusive and equitable workplace where everyone can be themselves, with support to be their best.
We strongly encourage applicants from a wide range of backgrounds and with different identities and experiences to apply for roles with Energy Saving Trust.
We are a Disability Confident Committed employer and offer guaranteed interviews for disabled applicants who meet the minimum criteria for a role.