Sql Jobs
About the role:
Welcome to a data analytics career where you’ll be more than just a number. We’re big enough to give you opportunity, experience and training. But small enough for you to see the difference you make.
If you’ve got an eye for detail (and we hope you do!), you’ll have spotted we’re a charity. Every one of us is focused on the outstanding care we deliver to our patients, their family and friends. The data you’ll be analysing, visualising and creating insights from makes that possible. You’ll see the difference your work makes each and every day.
About you:
Are you a “knowledge expert” with regards to analysis platforms, such as Power BI, and SQL servers and in Statistical Process Control and Application Programme Interfaces?
Excellent problem-solving, communication and multi-tasking skills?
Then you’ll find this a highly rewarding role. Working with the Head of Data, Information and Knowledge Management you’ll be preparing and compiling analysis to help support business decision making for our stakeholders.
If you’re an organised person who shares our values and are looking for a new role in a supportive and inclusive environment, then we would love to hear from you.
Our benefits:
As well as our competitive salary and the opportunity to join an organisation which puts patients at the heart of what we do, we offer a range of great benefits, which include:
- 27 days’ annual leave, plus recognised public holidays - rising to 29 days after 5 years’ service and 33 days after 10 years’ service (pro rata for part time)
- educational and professional development opportunities (we have an on-site Education Team)
- monthly group reflections via Schwartz Rounds sessions
- free on-site parking
- tranquil Hospice grounds
- subsidised meals at our on-site restaurant
- Employee Assistance Programme
- access to Blue Light Card discount card
- access to our Group Pension Scheme
- excellent changing facilities (with showers, fresh towels, and hairdryers)
- wellbeing - we provide a programme of activities, opportunities, and guidance to inspire and support our employees to live a healthy life, at home and at work.
Discover the difference you can be.
About us:
Princess Alice Hospice is one of the top ten adult hospices in the UK, providing specialist palliative care and support to a community of more than a million people living in Surrey, south west London and Middlesex.
At Princess Alice Hospice we are passionate about creating an inclusive workplace that values diversity. We are fully committed to equality of opportunities, and we warmly welcome applications from all backgrounds and cultures.
We are signed up to the Disability Confident scheme and we guarantee to interview all disabled applicants who meet the minimum criteria for the vacancy. We are a place where you can be you.
Please visit our Privacy Notices section to understand and be aware of how we use the data you provide to us.
All of our vacancies except from retail are subject to a relevant DBS check.
The client requests no contact from agencies or media sales.
Thank you!
Programme Information Analyst
Contract: Permanent, Full Time,
Location: The role will be based in the UK or one of the following countries where WaterAid works, subject to right-to-work eligibility in the respective countries. Ghana, Kenya, Nigeria, or South Africa
For the UK Location, we offer hybrid working: A minimum of 40% of working time is spent face-to-face, in a WaterAid office. For UK-based staff, WaterAid is located at Canary Wharf, London and this will be your location and contract base.
Salary & Benefits: Salaries and benefits for different countries will vary in line with the successful candidate's location and depending on experience. If UK-based: £43,668 - £45,851 (depending on experience) or equivalent established grade F in the country of employment.
About WaterAid:
Want to use your skills in data analysis and reporting to play a vital role in making clean water, decent toilets and good hygiene normal for everyone everywhere?
We need passionate, creative and dedicated people. In return, you will be encouraged and empowered to be yourself at your very best. Together, we will make a bigger difference.
Join WaterAid as our Programme Information Analyst to change normal for millions of people so they can unlock their potential, break free from poverty and change their lives for good.
About the Team:
The WaterAid Programme Operations Team team enables the effective management of the International Programmes Directorate (IPD) through the provision of robust high quality programme management policies, processes, tools, management information and systems so that programme staff are empowered to undertake effective planning and delivery of programmes and projects as well as ensure high quality reporting of programme performance to the wider organisation.
About the Role:
As our proactive and strategic Programme Information Analyst, you will identify information needs of key stakeholders, and define and develop reports and dashboards in response to these needs.
In this role, you will be responsible for improving the quality of key programme performance data through supporting the embedding of quality assurance processes, setting standards and tools, and providing training.as well as strengthening the capacity of CP and regional colleagues to systematically collect, analyse and use programme data to inform decision-making processes and organisational learning.
You'll also:
- Be responsible for the collation and analysis of operational and consolidated programme information for key audiences and reporting processes (including the Global Performance Measurement framework).
- Organise, analyse, makes accessible and promote programme data at a global level to inform global decision-making, learning and reporting
- Represent Programme Operations in organisational and cross-department data quality and data management initiatives
- In response to organisational and user requirements, define, develop, manage, maintain and update a suite of reports and dashboards that provide data for reporting, Country Programme SMT decision-making and key programme information for UK staff.
About You:
- Demonstrable experience of gathering and analysing requirements.
- Demonstrable hands-on experience of designing and building reports and dashboards using a variety of tools.
- Experience using and managing data collection and analytical platforms.
- Excellent writing skills, ability to disseminate and communicate complex information in a clear and concise manner.
Although not essential, we also prefer you to have:
- Experience and expertise at writing SQL queries within SQL Server or similar tool
- A general understanding of the WASH sector, and Programme and Project Planning, Monitoring and Evaluation.
Closing date: Applications will close at 23:59 on Sunday, 21st July 2024. Availability for an interview is required for 25 and 26 July 2024. Remote interviews will be via Microsoft Teams
How to Apply: To see the full job pack, please click 'Apply'. Please apply by submitting your CV and a mandatory cover letter answering the following three questions in one document either Word Document or PDF format. Please note that applications without a cover letter will not be accepted.
- Describe your experience of designing and developing reports and dashboards
- Explain how you have assisted with improvements to data quality
- Describe how you have identified the information needs of a variety of stakeholders
Pre-employment screening: To apply for this post, you must be able to demonstrate your eligibility to work in the respective country. All pre-employment checks will be carried out according to the applicable laws in the respective countries. All our UK-based vacancies require a basic Disclosure and Barring Service (DBS) check to comply with our Safer Recruitment policy.
Our Commitment
Our People Promise:
We will work with passion and focus to ensure safe and sustainable water, toilets and hygiene are available to everyone, everywhere. WaterAid is a place of purpose - where people have a real commitment and shared responsibility for the impact we have. We are a global community with diverse backgrounds and perspectives, motivated by inspiring, stimulating work. We are determined to put the wellbeing of our people first, to be a place where people feel safe and able to contribute their voice and truly live our values.
Equal opportunities:
We are an equal opportunity, disability-confident employer and are dedicated to achieving the highest standards of diversity, equity and inclusion. We welcome applications from people of all backgrounds, beliefs, customs, traditions and ways of life. This includes, but is not limited to, race, gender, disability, age, sexual orientation, religion, national or social origin, health status, and economic or social situation.
Safeguarding:
We are also committed to protecting everyone we come into contact with. We have a zero-tolerance approach to abuse of power, privilege or trust across our global work, and any form of inappropriate behaviour, discrimination, abuse, bullying, harassment, or exploitation. Safeguarding the people and communities we work with, our staff, volunteers and anyone working on our behalf is our top priority, and we take our responsibilities extremely seriously.
Size: More than 1000
Our vision is a world where everyone, everywhere has sustainable and safe water, sanitation and hygiene.
Thank you!
Salesforce Data Analyst Manager
Do you have extensive experience in Salesforce, Microsoft SQL, data integration and ETL processes and Microsoft PowerBI?
The charity implemented Salesforce (with Non-Profit Success Pack) with a successful roll-out in March 2023 and are now seeking to extend the scope of the CRM beyond the initial teams.
The Salesforce Data Analyst Manager is a full-time, hybrid-working role, offering flexible working.
Position: Salesforce Data Analyst Manager
Location: Hybrid/ Swindon
Hours: Full-time (flexible working available)
Salary: £40,000 to £45,000 per annum
Contract: Permanent
Benefits: Flexible Working, Pension, Employee Assistance Programme, Family Time benefits including TOIL, 25 day’s holiday (plus bank holidays) holiday trading, discounted gym membership, Health Cash Plan or Private Medical, Cycle Scheme, Life Assurance, Staff Seminars, All Staff Gatherings, Access to LinkedIn Learning platform, Tastecard, Childcare Vouchers, Loyalty Awards, Staff Events, Free tea and coffee and free car parking
Closing Date: 14 July 2024
Interviews: 18 July 2024 (1st round online) and 23 July 2024 (2nd round in our Swindon offices)
The Role
Working as part of the wider Technology department, the Salesforce Data Analyst Manager reports to the Head of Technology and will work closely with the Technical Solutions Specialist and the wider Salesforce project team.
This role is responsible for the quality of data imported and exported from Salesforce and our SQL databases.
The Data Analyst Manager will implement and oversee a data strategy to streamline ETL processes, ensure data quality and produce regular data quality reports. Additionally, they will be responsible for the administering and securing of our SQL server used for data-centric processes. You will be seen as a subject matter expert in their field, providing support across the organisation on a range of key projects.
About You
We’re looking for a hands-on manager, who can get stuck in on the daily tasks and lead a team of data analysts who are tasked with day-to-day operational duties.
You will have:
· Extensive experience of managing and developing a data analyst team
· Proven history of leadership and mentoring
· Proven experience in data management, analysis, reporting and visualisation
· Proven track record of identifying and remediating data inaccuracies to maintain high data quality
· Extensive experience of administering Microsoft SQL, SQL Server
· Strong proficiency in data analysis tools
· Strong experience of Salesforce NPSP administration
· Experience of working in the nonprofit sector is desirable
· Proven experience of collaborating with cross-functional teams and stakeholders to achieve common data-related goals
· Strong stakeholder management
If this sounds like you and you have the legal right to work and remain in the UK, we’d love to hear from you. Please provide your CV and a 250-word statement that sets out why you’re the best person for this position.
In Return…
Commitment - As a Christian organisation, the charity believe you have gifts and abilities that are all your own. So they’re willing to explore how what you have might fit what’s needed.
The checklist – There’s no such thing as the perfect candidate. You don't have to tick every box on the job description before you apply!
It's personal - You have a life outside work, and the organisation want you to be able to live it well. So are happy to talk to you about flexible working hours and working from home.
Learn and grow - When you're trained in a new skill, or learn a different perspective, it benefits everyone. The organisation is committed to making it possible for everyone to flourish, with a huge variety of learning resources available.
Together and apart - The charity believe in home working where it’s appropriate, and during lockdown they made that work really well. But know how important it is to meet face to face, too and are committed to making the office an enriching environment, where people are glad to be.
Celebrating difference - Universal acceptance for everyone, everywhere is at the heart of the organisation and it promotes diversity of thought, culture and background. Diversity is valued and this is reflected in the workforce.
Level ground - We want you to bring your best to the application and selection process. If you need any adjustments to be made for that to happen, let us know and we'll be glad to help.
About the Organisation
The organisations mission is to offer the Bible to the world. It is a vision of a world where everyone has access to the Bible and can recognise its value for them, their families and communities. Working for a Christian charity, this is a great opportunity to work for an investor in people gold employer who have won awards for their excellence in investing in people. They are committed to the development of all staff and have fantastic charity-sector benefits to help motivate and retain exceptional people.
You may also have experience in areas such as Data Analyst, Salesforce Data Analyst, CRM Data Analyst, Database, Systems Data Analyst, Software, Salesforce Analyst, CRM Data Analyst, Database Analyst, Data Analyst Manager, Salesforce Data Analyst Manager, CRM Data Analyst Manager, Database Manager, Systems Data Analyst Manager, Software Manager, Salesforce Analyst, CRM Data Analyst, Database Analyst. #INDNFP
PLEASE NOTE: This role is being advertised by NFP People on behalf of the organisation.
Thank you!
Do you have experience using a range of analysis and visualisation tools including Power BI and SQL?
Can you help us build a modern suite of BI to inform and enhance our service delivery?
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.
About the role
Location: This is a homebased role.
The Reporting Analyst in our Quality and Insight team will play a transformative role in producing engaging dashboards and reports for our Dementia Support and Partnerships directorate.
You will use your data expertise to translate requirements into compelling dashboards. You will work closely with our data teams and alongside the Insight Analyst - together underpinning our ability to make high quality, evidence-based decisions.
About you
- You thrive on bringing together data from complex datasets and presenting straightforwardly for varied audiences.
- You have great technical skills and are equally comfortable enhancing an existing dashboard in Power BI as building one from scratch.
- You are confident coding in SQL and DAX but value simplicity when solving problems.
- You understand the importance of accuracy and consistency of reported data alongside engaging content.
- Your curiosity and enthusiasm lead you to explore new techniques and seek continuous improvement.
- You can work independently and collaboratively, willing to lend a hand and knowing when to ask for help.
Closing date: 11th July 2024
Interview date: 19th July 2024
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.
Our Values
We are Determined to make a difference when and where it matters most, by being passionate, focussed and making a lasting impact for people affected by dementia.
Every one of us is a Trusted expert, listening, learning and using evidence and experience. We are Better together by being open, combining our strengths, helping us to achieve more together. We are Compassionate, we are kind and honest, and we don’t shy away from challenges.
Through our values we will make the greatest difference for people affected by dementia.
Equal Opportunities
We’re a national charity providing dementia support to a community that’s ethnically diverse, but we don’t reflect this in our senior leadership. This needs to change.
We need to ensure the voices around our table better reflect and understand the community we exist to serve. We welcome applications from people of all backgrounds, particularly those from ethnically diverse communities who are traditionally underrepresented in the charity sector leadership roles.
We want everyone we work with, as a colleague, volunteer, supporter, or someone we support, to feel included and that they belong at Alzheimer's Society.
We are committed to building a diverse organisation that represents the communities we serve and ensuring inclusion in everything we do. During your recruitment process we want to make sure that you bring your whole self and be at your best.
Thank you!
Scope is a disability equality charity in England and Wales. Together we are Disability Gamechangers. We work to a society where all disabled people enjoy equality and fairness. We campaign tirelessly for an equal future for disabled people.
We are looking for a CRM Developer to work collaboratively with the Head of Business Intelligence, the Database and Analysis lead and other teams within Scope in delivering a best in class CRM.
Fixed term 12 months, 35 hours per week
Location: Here East Press Centre, 14 East Bay Lane, London, E15 2GW with flexibility to work from the office and from home.
The role
As our CRM Developer, you will act as one of Scope’s technical leads, primarily responsible for configuring and developing our Dynamics 365 estate over time. This role is crucial in shaping CRM systems solutions architecture and design, collaborating closely with the Business Intelligence team to enhance our systems and contribute to the wider Dynamics strategy.
As a CRM Developer, you will:
- Be the go-to expert for Dynamics CRM, solving problems and helping others.
- Work with the business team to find and implement the best solutions.
- Improve the system to make it faster and more stable.
- Turn ideas into new features and update the system every month.
- Review changes and fix any issues with the CRM system.
- Manage the data coming into the system and keep everything organised.
- Stay updated with new features in Dynamics 365 and add them as needed.
- Write and update guides and documents.
- Make sure the system follows company rules.
- Lead projects and help train the team.
- Do other tasks as needed.
- Create support materials and technical documentation for IT and Database teams.
- Ensure system compliance with company policies and standards.
- Stay current with Microsoft Dynamics 365 updates and incorporate necessary changes.
- Lead project initiatives and provide training and support in collaboration with the Business Intelligence team.
- Perform other tasks as assigned within the scope of the role.
For more information about the role’s responsibilities, and the skills and experience required please use the apply link to go to the full job description on our website.
About you
To be successful in this role we are looking for someone who has:
- A Microsoft certification in Dynamics 365
- Experience with Power Apps, Power Platform, Power Pages, Customer Voice, and the basics and main features of Dynamics 365
- Experience customizing Dynamics 365 and understanding databases and cloud services
- Experience with moving and connecting data using tools like SSIS, Power Automate, REST APIs, and Azure Data Factory
- Experience in checking and testing the quality of work
- Familiarity with project tools like Visio, JIRA, and Azure DevOps
- Knowledge of Microsoft programs like Office 365, SSRS, SSIS, and SharePoint
- Experience with Azure DevOps, SQL Server, JSON, Python, R, and process control tools
- Experience with MS Power Platform (PowerApps, Power Automate)
- Experience helping users or managing a support desk
- Strong skills in Excel
- Ability to explain technical ideas in a simple way
- Problem-solving skills for data issues
- Experience hiring, managing, and developing team members according to company policies
Please make sure you explain in your application, with examples, how you can meet these important skills.
We ask you to show an appreciation of Scope’s values and our ambition of an equal future for disabled people.
Our values - pioneering, courageous, connected, open, fair
By living our values and trusting each other, we empower our colleagues to make decisions. By giving our colleagues freedom and space to spark creativity for innovation, we can push boundaries, change mindsets and be empowered to change the game with grit and determination and a sense of urgency.
Disabled candidates
We are a disability equality charity. We encourage applications from disabled people and people with impairments, conditions, and access needs. We want to create a workforce that is a true reflection of the communities we serve.
Scope will interview all disabled candidates who meet the essential criteria for the post. This is part of our commitment as a Disability Confident Leader. Just let us know in your application that you are applying under the Offer an Interview Scheme. This was previously known as the Guaranteed Interview Scheme.
Some applicants might need adjustments during the application process. If you require adjustments through your journey with us you can find out more about interview adjustments on the Scope website.
Equality, diversity and inclusion
At the heart of everything we do at Scope is Equality, Diversity, and Inclusion.
We want everyone to feel like they belong. We value each person as an individual. We will treat everyone with dignity and respect and we want to recognise all parts of a person's identity.
We are a disability equality charity. So, we will build a culture that is accessible and inclusive first. We will aim for the same high standards in all our work. We will listen, learn and keep improving.
You can find out more about our approach to Equality, Diversity and Inclusion on the Scope website.
Scope benefits
We believe hard work deserves reward and recognition. We offer a wide range of benefits including:
- 27 days holiday plus Bank Holidays
- Flexible, hybrid and remote working options
- Pay progression at 6 months and 2 years
- Company pension
- Excellent training and career development
- Strong colleague networks across disability, race and LGBTQ+
- Discounted gym membership, cycle to work scheme and much more.
If you want to become a Disability Gamechanger, we'd love to hear from you.
Click the apply button to create an account and complete your application form.
Thank you!
Role: CRM Officer
Duration: 9 months
Salary: £39,500
Hours: 37.5 per week
Location: London (Hybrid)
We are delighted to be working with a wonderful international aid organisation to recruit an experienced CRM Officer to cover maternity leave.
About the role:
Reporting to the CRM & Data Insight Manager, you will lead on the regular schedule of data imports, data selections, data cleansing, and support the CRM and Data Insight Manager with CRM Development. Additionally, you will support the Fundraising team through training, maintaining user guides, ad-hoc reporting and being the first point of contact for any CRM issues.
About you:
You will have considerable experience of CRM database systems, ideally in the not-for-profit sector. Experience of using KingswaySoft or similar ETL tool with programming skills such as SQL is essential. We are looking for an organised, flexible candidate who is used to managing a busy workload.
We are looking to move quickly with this role so if you are interested, please apply without delay.
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.
