Sql Jobs

Friends of the Earth has recently launched its new CRM system, using Microsoft Dynamics. This has been the result of a multi-year project to refresh processes and tools across the organisation, with Applications & Data team members at the heart of this change. We’re now looking for an excellent technology leader to enable the continuation of this work: to set the vision and enable its ongoing development and support, as well as to lead the newly formed multidisciplinary team on a day-to-day basis.

Working in an Agile manner, you will lead technology work across our business-critical systems and processes, promoting the effective use of supporter data to deliver our goal of being a data-driven organisation.  This includes our Dynamics CRM and integration, and our SUN finance system. You will also be a key contact point across the IT department for project management and, when required, be an escalation route for support incidents and requests in your area.

Key Skills and Attributes: 

With strong experience of working with data and internal business applications, and effective stakeholder management, you’ll be able to work with peers at all levels across the organisation to agree a technical roadmap for this work area and then focus on the detail to make it happen. This will include helping set the standard for the use of data across the organisation, using our new systems to enable this.

Your strong business analysis skills be put to great use in understanding the differing business processes and identifying areas for ongoing improvement, working with the specialists in your team. This will be accompanied by a prudent approach to assessing the value of each piece of work – whether a support request or a more substantial change - ensuring it represents cost effective ways to improve how we achieve our goals as a campaigning charity.

This is a complex environment, and your previous experience of supporting varied processes and applications will mean you’re able to prioritise effectively and ensure standardised troubleshooting approaches are used. Likewise, you’ll ensure we follow a robust and modern Software Development Lifecycle to promote changes through environments with appropriate testing and risk mitigation. If you have technical experience with the Power Platform, Logic Apps or SQL, will may come in handy when the team design and make these changes.

Your excellent understanding of Agile methodologies will mean you’ll fit right into leading within the team’s established Agile Scrum practices and support the ongoing improvement of their ways of working – and help shape how technology approaches project management.

Finally, you’ll be adept at working with others to tackle problems together: internal stakeholders will look to you for how to achieve technical change, and you’ll have excellent account management with our external partners who support our systems and will deliver some of the changes needed.

The team: 

The team are an excellent group of people, who’ve made a huge contribution to our work at Friends of the Earth and are well respected. They comprise two Application Specialists (one Finance, one Dynamics) and two Data Developers. All have significant expertise in different parts of our systems.

The team have recently been formally brought together following a restructure but have worked together closely for the past few years throughout the delivery of the CRM project. The team use Agile Scrum for their delivery work, for which you will be the Product Owner.

The team works a hybrid pattern: often remote, but sometimes together as appropriate; typically, this is in our London office but can vary. You will formally line manage all four team members.

Closing Date: Monday 10th February 2025 (23:59).

Interview Dates: 20th February 2025.

Location: Flexible across England, Wales and Northern Ireland 

Please note we only accept applications via the Friends of the Earth Application System.

We offer a competitive range of benefits, good work/life balance including a 4-day working week with no loss of pay, excellent learning and development opportunities and a vibrant organisational culture. 

Our staff body is currently under-representative of People of Colour, LGBTQIA+ people and people with long term conditions or impairments. We are committed to eroding these historic barriers, so as to create a movement in which people from all walks of life see themselves in, and so we particularly encourage you to apply if you belong to one of these groups or sit at multiple intersections of disadvantage. We are committed to the Disability Confident standard and will guarantee an interview to any candidates who declare a disability and who meet the essential criteria for the role.

Friends of the Earth staff who publicly represent Friends of the Earth (including all campaigners) are not allowed to also represent a political party. This is to ensure that there can be no confusion in the minds of the public about Friends of the Earth's party-political independence. Affected staff should also seek permission from the Senior Management Team if they wish to hold a non-public facing official role in a political party. If this is an issue, please do raise this with us as soon as possible.

Friends of the Earth is an international community dedicated to protecting the natural world and the wellbeing of everyone in it. We lead campaigns, provide resources and information, and drive real solutions to the environmental problems facing us all. 

Thera Trust has an exciting opportunity available for an Information System Developer to join our team based in Grantham, Lincolnshire?????. You will join us on a full time, permanent basis. In return, you will receive a competitive salary of up to £37,294.91 per annum, DOE.

About us

Thera is a charitable group of 13 companies which support people with a learning disability with a diverse range of needs.

Thera Trust is the parent of Thera Group and provides central services from its office in Grantham. This enables the companies to focus on delivering high quality support locally.

About the Information System Developer role:

You will be working in a specialist information team within IT developing and implementing the organisations information strategy.

To do this, you will work closely with various business functions reviewing their information needs and processes. You will recommend, develop and support improvements or new systems to capture and store data and manage business processes. These systems will also provide robust management reporting capabilities.

Our goal is to support evidence-based decision making throughout the organisation to deliver the best care and support possible, directly or indirectly.

We use a variety of tools to deliver information systems including a cloud-based workflow platform, SQL databases, Power BI, legacy Excel spreadsheets and business systems HR, finance etc.

Previous experience of no-code or low-code form and workflow based app development is required, but regardless of platform eg Power Apps, Dynamics, Salesforce com. Experience with Nintex K2 Cloud specifically is not expected, appropriate on-the-job training will be provided.

We are looking for an Information Systems Developer to join the team who can:

• Design and develop apps in low code cloud-based systems to collect structured and unstructured data from end users
• Develop SQL databases and stored procedures to provide data storage for the low code apps, including DB maintenance and performance tuning.
• Build data pipelines to automate ETL workloads to refresh curated data sets which support reporting and analysis of information
• Solve complex problems in creative ways and propose appropriate best fit solutions according to different needs and priorities.
• Work independently using existing technical skills including:
• SQL database development
• Writing SQL code , stored procedures for applications, views for data extraction, ad hoc queries or data updates
• Data engineering to automate the flow of data for reporting
• Power Query to extract and transform data from different sources as semantic models for reporting

Technologies you would be using to fulfill this role include:

• Low code development using the Nintex K2 Cloud SAAS platform
• Azure SQL
• Azure Data Factory for automation of data pipelines
• DAX data modelling
• Power BI for analysis and presentation of data, controlling access to data based on user roles.
• Built-in reporting tools to extract data from core business systems
• Demonstrate excellent organisation and a methodical approach.
• Adopt a culture of continuous improvement for the systems we maintain, and the processes by which we work as a team.
• Apply a solid understanding of information management and data governance principles, and data related legislation to all of our work.

What are the Benefits?

• 33 days holiday including bank holidays
• Contributory pension
• Cycle to work scheme
• Employee support line to support you
• Support in gaining professional qualifications
• Continuous on the job training is provided
• Access to early pay , T&Cs apply.
• Blue light card

Please click "apply" now to become our new Information System Developer - we would like to hear from you!

We reserve the right to close this advert before the closing deadline if we interview and offer the right candidate. Apply now to avoid disappointment.

We are an equal opportunities employer.

Interested in data and looking for an opportunity in a sector leading CRM and data team? 

We're recruiting for a Data Executive to join us and support the ongoing marketing and membership activities of British Heart Foundation (BHF). 
 
About the role

As a Data Executive you'll be responsible for managing marketing data selections; taking responsibility for a campaign to advise on segmentation, building selections in Blackbaud Enterprise CRM, and using SQL to write output scripts. 

You'll work on a range of imports and will be involved in testing and improving existing import processes as well as be responsible for identifying, fixing, and improving issues in the database. You'll also get involved in other projects as required such as testing software upgrades.

Working arrangements

This is a 12 month fixed term contract covering family leave.

This is a blended role, where your work will be dual located between your home and our London office. 
 
At BHF we believe in the power of being together, so our colleagues on blended contracts can expect to spend some time in their office, at least one day each week, on average. The use of our office spaces is driven in part by your role and the activities you need to do. This may vary from time to time, so you will need to work in a flexible way to unlock your best work for our cause. 
 
About you

With previous experience of working with CRM systems, knowledge of SQL and working within a busy fundraising environment, you’ll have excellent problem solving skills, able to take the initiative on tasks. You’ll also have previous experience of planning and prioritising your own workload to tight deadlines.
 
To be successful in this role you'll have the following skills and experience:

• IT literate; fully conversant with standard Microsoft packages particularly Excel
• Good degree of data literacy with familiarity of data querying and manipulation
• Understanding of, and experience in, writing & working with SQL queries
• Experience of carrying out imports and exports of data to & from external agencies/3rd parties
• Experience using Blackbaud CRM, Raiser’s Edge or similar CRM application
 
You'll have excellent attention to detail as well as a strong standard of numeracy. With an aptitude to find solutions to achieve better ways of working, you'll have strong communication skills able to interact with internal and external stakeholders at different levels.
 
Our work is fundamental to the health of the nation with an impact globally, so we require a world-class data function. If you have the skills and experience we're looking for, and you want to roll up your sleeves and help fund life-saving research, then we want to hear from you.

Interview process 

The interview process will be held virtually over MS Teams, with first stage interviews being held week commencing 3/2/25.

About The Role
At Alzheimer’s Society, data plays an important role in our mission to create a world where dementia no longer devastates lives. Are you ready to turn raw data into insights that drive real change? Do you want to be part of a mission where your data skills directly contribute to improving lives?

We’re looking for a Reporting Analyst to play a central role in our Technology Directorate. You'll be helping teams across the society make evidence-based decisions that truly matter.

In this role, you’ll unlock the stories hidden within our data. From operational reports that keep the day-to-day running smoothly, to Commissioner reporting that shapes our future. Using tools like Power BI for data visualisation, SQL for data manipulation, and even advanced techniques with R and GIS. You’ll create clear, user-friendly reports that empower teams to make a difference.

Beyond building reports, you’ll be a trusted partner and problem-solver. You'll be gathering requirements, defining reporting standards, and providing support to help colleagues confidently use data to achieve their goals.

How you’ll make an impact

- Design, develop, and maintain high-quality reports and dashboards using tools like Power BI, SQL, R, and GIS to provide actionable insights.
- Collaborate with teams to gather and prioritise reporting requirements, ensuring solutions meet organisational needs and support evidence-based decisions. 
- Define and enforce reporting standards and governance, maintaining consistency and accuracy across datasets.
- Use Agile practices to quickly prototype, refine, and deliver impactful reporting solutions. 
- Support data quality by developing integrity scripts and validating reports to ensure accuracy and compliance.
- Deliver support and guidance to help colleagues confidently interpret and utilise reports in their work. 

You’ll work with the following stack

- Power BI for creating engaging, interactive dashboards. 
- SQL scripting for data analysis and transformation. 
- Advanced analytics tools, including R and GIS. 
- Agile methodologies for iterative development and collaboration. 
- CRS (case management), RADAR (incident management) systems, and other key datasets.

Why join us?

Your wellbeing and work-life balance are central to our success. Joining our team means making a meaningful impact while enjoying a range of benefits designed to support your personal and professional wellbeing. 

We offer flexible working options, including homeworking and arrangements like 9-day fortnights, to help you balance your life and career. You'll also enjoy 27 days of annual leave (plus flexible bank holidays), dedicated wellbeing days, a cash health plan, access to a virtual GP, life assurance, enhanced parental leave, and many more benefits that prioritise you. 

At Alzheimer’s Society, we’re committed to investing in our people. If your role would benefit from training or certifications, we’ll support your professional development to help you achieve your career goals. 

About you

Must-haves:

- Proven experience designing and delivering Business Intelligence and Management Information reports.
- Proficiency in Power BI, SQL scripting, and data manipulation.
- The ability to create dashboards and visual reports that are intuitive and actionable. 
- Experience working collaboratively with stakeholders to gather and interpret requirements. 
- A strong awareness of data governance and reporting standards. 
- Excellent problem-solving skills, attention to detail, and a proactive approach to ensuring data accuracy. 
- Strong communication skills to engage with technical and non-technical audiences alike.

About Alzheimer's Society

Dementia is the biggest health and social challenge of our time.

There are currently estimated to be 900,000 people in the UK with dementia. Many are undiagnosed and facing the realities of their condition alone.

At Alzheimer’s Society we’re working towards a world where dementia no longer devastates lives. We do this by giving help to those living with dementia today and providing hope for the future. We’re here for everyone living with dementia.
 
As a Society, we are made up of people with dementia, carers, trusted experts, campaigners, researchers and clinicians. We are the UK’s largest collective force of people with unparalleled knowledge and over 40 years of experience addressing the biggest challenges facing people living with dementia.

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 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.

The General Optical Council utilises Microsoft Dynamics 365 CRM software (not Business Central/F&O) to manage operations and store operational data. We are looking for an experienced CRM Support Analyst to support the current software, coordinate future enhancements of the application, enhance and deliver reporting and undertake minor configuration/customisation/development work. 

Key Accountabilities:

- Ownership of the Dynamics 365 environment (approx. 60 users) including advising on storage requirements, strategic direction and licencing.
- Provide application support for users including systems training, data queries and other administrative tasks.
- Data management (including data imports/exports), synchronisation and integration with other business applications, systems testing, configuration, troubleshooting and planning enhancements.
- Report data in the predefined structures - modify tables, views, charts, dashboards, SSRS reports and forms.
- Maintain application access rights, security settings, and user privileges.  
- Collaborate with developers and third-party vendors to drive successful implementation of enhancements/integrations and maintenance of appropriate service levels.
- Create and update training manuals, policies and procedures, build custom reports, workflows and dashboards as requested.
- Review the MS Dynamics platform and solutions. Identify and address any architectural deficiencies and flag opportunities for improvement.

Essential Skills/Experience/Qualifications:

- Minimum of three years working with Microsoft Power Platform including Dynamics CRM 365 (cloud version).
- Experience with Microsoft Dynamics CRM configuration/ customisation / development skills including model driven apps, permissions, views and dashboards and power automate flows
- Must have experience working with sensitive data and have a sound knowledge of GDPR practices. 
- Excellent communication skills. 
- Excellent external and internal stakeholder management skills
- Excellent business analyst and problem-solving skills 
- Excellent data analysis, management and reporting skills
- Experience in user acceptance testing, training, producing guidance documentation and implementation support 
- Experience of other Microsoft Technologies including Azure, SharePoint, Exchange, Teams, Office 365 and other Power Platform/Dynamics 365 related applications (ideally also Microsoft SQL).
- Power Platform, Dashboard, API and SSRs Report development experience.
- Management of different Dynamics user licence types and storage to minimise costs.

Closing date for this role is 20 January 2025, please note we reserve the right to close this role early dependant on number of applications.

Please note your application will not be accepted without a covering letter exampling how you meet the essential criteria of this role, no more than 2 A4 pages.

Location: London
Contract Type: Permanent
Hours: Full time
Salary: £36,060- £41,769

You may also have experience in the following: IT Manager, IT Support Manager, Networking Manager, IT Technical Support Manager, IT Service Support Manager, Microsoft, MSCE, VMware, Senior Systems Analyst, Infrastructure Manager, Network Manager, IT Support Analyst etc

REF-218 797

Prospectus is delighted to be supporting an international environmental charity he position will be offered on a permanent, hybrid contract.

The organisation’s hybrid working model enables employees to enjoy the benefits of both office based and remote working. They ask that staff work from the office in Islington 40% of their time, with 20% required as a minimum. Reasonable adjustments as well as specific office-based needs will be considered for those with long term health conditions and disabilities.

The Head of Insight and Analytics will lead a team of five to develop data-driven initiatives that will contribute to the organisation’s mission to halve emissions and restore biodiversity by the end of this decade in a fair and equitable way.

You will expand the organisation's insight and analytics work across all areas, ensuring that the organisation is at the forefront in using data and insights to inform campaigning, fundraising, digital initiatives, and volunteer organising. Your efforts will enhance the quality and comprehensiveness of insights available to inform decision-making across departments, supporting the development of cohesive strategies.

You will work closely with the Head of Data, who leads a team of five dedicated to data operations and development. Together, you’ll ensure seamless integration and alignment between your areas, driving progress towards shared objectives. Your leadership will cultivate new business partnerships and an environment of agility and innovation, inspiring creativity and collaboration as we work together towards a sustainable future.

The successful candidate will be an experienced insights or analytics leader, ideally with experience of supporting within a campaigning organisation. You be a collaborative leader, with the ability to drive change and transformation whilst inspiring and influencing those around you. Finally, you will bring analytical expertise and proficiency in SQL and BI platforms, such as Tableau and Power BI.

First Stage Interviews: 11th and 12th Feb.

As a specialist Recruitment Practice, we are committed to building inclusive and diverse organisations, and welcome applications from all sections of the community. We invest in your journey as a candidate and are committed to supporting you in your application. Should you require any support with your application, please don’t hesitate to reach out to Matt at Prospectus.

In order to apply please, submit your CV in the first instance. Should your experience be suitable, we will send you the full job description and will arrange for a call to brief you on the role.

Are you experienced in the use of PowerBI or other data visualisation tools for developing reports and dashboards and used to manipulating data using complex formulas or programming? Then join Shelter as a Business Intelligence Analyst and you could soon be playing an important role at the heart of our Data Management & Insight team.

About the role
To provide management information and insight across Shelter, through the design and development of datasets, reports and systems using Microsoft Power BI and other tools.

To develop business intelligence reports and dashboards based on Shelters performance framework supporting an empowered self-service environment for colleagues.

About you
To succeed, you’ll need proven experience of analysing, interpreting and presenting datasets using PowerBI and working with CRMs and other systems. You’ll also need excellent Excel skills and familiarity with database structures such as SQL. Comfortable working with colleagues at all levels across an organisation, you enjoy nothing more than collating, analysing and disseminating business intelligence or helping others develop intelligence from reports and dashboards. What’s more, you’re keen to get involved in a variety of projects as part of a strategic programme aimed at improving the way we work.

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
Part of our Strategy Enablement Directorate, the Data & Insight Team delivers high quality data and database management, administrative services and business insight to the department and other teams across Shelter. Custodians of supporter data for its full life cycle, running through everything we do is a commitment to maintaining the highest standards of data quality and embedding a culture of standards, both in terms of compliance and best practice across the department. We work closely with the wider team including our Head of Data and Insight, Data Architects, Data Engineers and Insight Analysts to help Shelter achieve its organisational strategy in helping the fight to end homelessness.

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.

Location: National Support Centre, MSSC NSC, 200B Lambeth Road, London, SE1 7JY (Hybrid Working)

Contract: Full time, permanent

Salary: £37,000 gross per annum

Closing Date: 27 January 2025

Application: CV & Covering Letter

Are you a data analyst, charity evaluator or social researcher looking for a new opportunity?

The Marine Society & Sea Cadets (MSSC) is the leading maritime charity for youth development and lifelong learning. We are a vibrant and growing charity inspiring young people to achieve their potential through challenge and nautical adventure and also enabling seafarers and maritime professionals to realise their potential through learning and career development. Working with our employees, cadets, and volunteers, we have built a strong vision and five-year Future Ready strategy to meet the growing demand for what we provide, both for young people, seafarers and maritime professionals – and the thousands who aspire to be the sea cadets and marine professionals of the future. It is also about equipping them to achieve their potential and thrive in a rapidly changing world, while growing our charity to benefit even more people – including those from under-represented or marginalised groups.

We are currently looking for a Data Analyst to join our team.

About the role

Reporting to the Head of Policy and Insight this role is a central part of MSSC understanding its impact and driving change across the youth and maritime sectors.

The Data Analyst leads on the coordination and delivery of organisation wide key performance indicators (KPIs) while working to support the organisation’s wider evaluation and research work. The Data Analyst is embedded into the wider organisation and there are exciting opportunities to support other staff and volunteers to access and use data, as well as understanding how to transform data recommendations into practical change. The role suits a keen analytical thinker, who revels in opportunities to collect and understand data and then see their recommendations bear fruit.

Responsibilities

The following is a list of the principal tasks of the Data Analyst and is not intended to be an exhaustive list:

· To gather correlate, and monitor relevant data from across the organisation (e.g. Westminster) and from external sources (e.g. ONS)

· To evaluate our existing data processes and make recommendations regarding the streamlining of data collection and presentation

· To develop and implement new data collection, and analysis systems and processes where required

· To lead on regular KPI reporting

· To support the head of policy and insight in developing evaluation processes across the organisation

· To support the head of policy and insight, in identifying, and collecting (including leading on elements of research independently) appropriate data for influencing work

· To provide practical upskilling, training, and support to teams and directorates who need to engage in self-serve data analysis and research

· To develop and utilise new ways to present MSSC data to engage key internal and external stakeholders

Requirements

· Experience of handling diverse datasets of varying quality

· Experience of translating findings from a range of different audiences both internal and external

·Understanding of how to process and analyse quantitative data

· Experience of appropriate processes around data security

· Experience of developing processes and procedures to collect and present data

· Experience of training in upscaling non-data experts

· Confidence in engaging with service users where required for data collection and analysis

· Confidence general database management

· Confidence in database administration

For further information, please download the Recruitment Pack attached. 

Benefits

• 25 days annual leave per annum, increasing with length of service
• Hybrid working
• Volunteering Leave
• Life assurance (4x salary)
• Private medical insurance
• Generous pension (employer contribution up to 10%)
• Cycle to work scheme
• Wellbeing portal and EAP with 121 counselling
• Employee development: We are investing in our employees' development and have an annual calendar of learning and development opportunities, designed to support employees to develop into their roles and stretch them to achieve their full potential.

Additional Information

MSSC positively encourages applications from suitably qualified and eligible candidates from all backgrounds. Equity, diversity, and inclusion really matters to us, so we can best serve our beneficiaries from every community. We work to ensure a fair and consistent recruitment process and aim to be a charity where diversity of experience, identity and skills are valued and welcomed. MSSC is an equal opportunities employer.

We recognise our responsibilities to safeguard and protect the young people and vulnerable adults with whom we work. We do all we can to promote their health, safety and wellbeing, and we expect our staff to share this commitment and work in line with safeguarding policy, the MSSC’s values and ethos of inclusivity. We adhere to safer recruitment practices and therefore employment is subject to detailed pre-employment checks for successful candidates, including references and criminal disclosure checks and the completion of a disclosure questionnaire. 

All successful applicants are required to attend safeguarding training and undergo pre-employment checks including a criminal record check.