Sql jobs
How's your job search on our site?
Location: Remotely, UK
Work pattern: 35 hours per week
Salary: Up to £36,327.99 per annum
Contract: Permanent
We are the UK’s largest cat welfare charity. All over the country, our passionate employees, volunteers and supporters are using their kindness and expertise to make life better for millions of cats and the people who care for them.
Will you join us and make life better for cats?
Responsibilities of our Data Selections Analyst:
-
Our Data Selections Analysts develop, run and maintain targeted data selections and multistage supporter journeys across a range of communication channels.
-
This role enables effective fundraising, fulfilment and engagement activity for supporters and customers across Cats Protection. Working closely with campaign owners, and colleagues across Data & Analytics, the role translates business requirements into accurate, supporter centric and compliant communications that support organisational objectives.
About the Data & Analytics team:
-
The Data & Analytics team are a department of 17 people in the Marketing & Income Generation directorate consisting of four sub-teams : data processing, data selections, data analytics and customer journeys.
-
The Data Selections sub-team manages and segments supporter and customer data to provide accurate, targeted selections for fundraising, marketing, and other charity communications and customer journeys, while ensuring data quality and compliance.
What we’re looking for in our Data Selections Analyst :
-
Substantial experience working with contact data within a CRM system or database (ideally in a fundraising context.)
-
Experience producing and adapting targeted marketing, fundraising or customer communication selections.
-
Experience interpreting business requirements and translating them into audience selections, segmentation or automated communication processes.
-
Experience using data selection, campaign management or marketing automation tools such as Apteco Faststats and PeopleStage or similar.
-
Experience writing queries using a structured language such as SQL or similar
-
Good understanding of data protection legislation and responsible data use in communications.
What we can offer you:
-
range of health benefits
-
26 days’ annual leave plus bank holidays, increasing with length of service
-
Salary Finance, which empowers you to take control of your financial wellbeing
-
and much more, which you can learn about
Interested? Here’s how to apply:
Application closing date: 31st August 2026
Virtual interview date: Mid/Late September 2026
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.
If successful, your recruitment journey will include:
1.Anonymised application form
2.Video screening round (depending on applications)
3.Virtual interview via Microsoft Teams and a pre-interview task
Making a better life for cats, because life is better with cats
The Role
At The Law Society, data plays a critical role in helping us better understand our members, improve our services, and make informed business decisions. As a Data Analyst, you will deliver high-quality insights and reporting that support strategic and operational decision-making across the organisation.
You will work with colleagues from a wide range of teams to transform complex data into meaningful recommendations, helping stakeholders understand performance, identify opportunities for improvement, and measure the impact of key initiatives. You will use a variety of analytical techniques to uncover trends, diagnose the root causes of business performance fluctuations, and provide evidence-based recommendations that drive action.
The role will involve developing automated dashboards and reporting solutions using tools such as Power BI and Databricks, enabling stakeholders to monitor key performance indicators with confidence. You will design and evaluate pilots and A/B tests, quantify the impact of service improvements and communications, and build predictive models to forecast future trends and member behaviour.
Working closely with the Data and Governance team, you will support data quality initiatives, helping to identify and resolve data issues while contributing to the maintenance of a trusted, single source of truth. You will also play an important role in increasing data literacy across the organisation by supporting colleagues to access, understand and responsibly use data and insights in their day-to-day decision-making.
This is an exciting opportunity to contribute to the successful delivery of data products across The Law Society while helping to advance our analytical maturity and data-driven culture.
What we're looking for
We are looking for an experienced analyst with a strong track record of turning data into actionable insights and business value. You will have extensive experience using Python for data analysis, particularly with libraries such as Pandas and NumPy, alongside strong SQL or Spark SQL programming skills.
You will bring proven experience of creating engaging visualisations, dashboards and reports using Power BI or similar tools such as Tableau or Qlik, with the ability to present complex information in a clear and compelling way to both technical and non-technical audiences.
You will possess excellent numeracy skills and a strong understanding of statistical analysis and modelling, combined with advanced data wrangling, data cleaning and quality assurance experience. Your analytical mindset and problem-solving capabilities will enable you to identify trends, investigate issues and provide practical recommendations that support organisational objectives.
You will be comfortable managing multiple priorities and delivering high-quality work to agreed deadlines. A collaborative approach is essential, as you will work closely with colleagues across teams and functions to understand their needs and support the successful adoption of data products and insights.
Experience of working with tools such as DevOps, Jira and GitHub would be advantageous, as would an understanding of data governance, data security and regulatory compliance. Most importantly, you will be proactive, curious and committed to continuous improvement, with a passion for helping others make better use of data.
What's in it for you
This is an excellent opportunity to work with colleagues in a progressive membership organisation. The successful candidate will join a strong brand with a reputation for excellence and legal expertise, committed to promoting equality, diversity and inclusion, and a culture of trust, clarity, excellence and respect.
We offer hybrid working, a generous flexible benefits package, a friendly working environment and the opportunity to develop your career within a professional organisation.
Please note: if you are an internal applicant, Pay Policy will apply.
The Law Society represents solicitors in England and Wales. From negotiating with and lobbying the profession's regulators, government and other decision makers, to offering training and advice, we're here to help, protect and promote solicitors.
If you would like to have an informal discussion about the role, please contact Judy Howarth on
Actively Interviewing
This organisation is scheduling interviews as applications come in. They're ready to hire as soon as they find the right person. Don't miss your opportunity, apply now!
Senior Data and Insight Scientist
Lloyd’s Register Foundation
Location: London - UK
Candidates must provide work authorization for the respective country.
Applied data and statistical skills, along with the ability to communicate insights clearly to nontechnical audiences
Applications close: 6th September 23:59 UK time
Interview to be held Week commencing 21st September
About the Role:
The Senior Data and Insight Scientist provide analytical leadership across Lloyd’s Register Foundation, ensuring that data and evidence are robust, meaningful, and usable for decision‑making and impact.
The role bridges deep technical expertise with clear insight translation, supporting flagship programmes including the World Risk Poll and the Global Safety Evidence Centre.
This is a hybrid role combining advanced data analysis, applied statistics, evidence production, and high-quality communication. It plays a central role in strengthening the Foundation’s evidence‑led approach to safety.
About the Global Safety Evidence Centre
Lloyd’s Register Foundation’s mission to engineer a safer world is underpinned by the use of robust and credible evidence to better understand the nature and scale of global safety challenges, and what is needed to address them. While we know this evidence is critical to informing decision-making and improving safety, it often does not yet exist or is not easily accessible. Responding to this need, the Foundation has established GSEC as a hub for anyone who needs to know ‘what works’ to make people safer, collating the best safety evidence from our partners and other sources and communicating it in an understandable and actionable form. GSEC also hosts the Foundation’s own evidence outputs, such as our flagship World Risk Poll.
What we offer you
- Full time – Permanent role
- Hybrid and flexible work schedules with an appreciation for work-life balance
- Working in a global company with the ability to work with different cultures and diverse people
- Competitive benefits package including 26 days holiday pro rata per annum, plus flexible bank holidays, buy/sell holidays, bonus scheme, company funded PMI, EAP, discount scheme & opportunities for learning & development (including financially supported part-time study)
- The opportunity to work for an organization that has a clear sense of purpose, is values-driven and helps colleagues to develop professionally and personally through our range of people development programs.
The Role
We do not expect applicants to demonstrate all of the specific skills outlined, and we are interested in hearing what you can bring to the role.
1. Analytical Leadership
- Perform high quality quantitative analysis across complex and large-scale datasets
- Apply appropriate, rigorous, and transparent analytical methods
- Ensure strong quality assurance across data, code, and outputs
- Develop reproducible analytical workflows that can be audited and reused
2. Insight & Visual Communication
- Translate technical findings into clear, compelling insight for non-technical audiences
- Design and maintain:
- Data visualisations
- Dashboards and data products
- Contribute analytical content to reports, briefings, and publications
3. Programme Support & Delivery
- Provide analytical leadership to major initiatives, including:
- World Risk Poll
- Global Safety Evidence Centre
- Work with programme teams to:
- Shape research questions
- Interpret findings
- Apply evidence in practice
- Support monitoring, evaluation, and learning (MEL) through effective use of data and insight
4. Collaboration & Influence
- Work collaboratively with internal teams, research partners, and advisory groups
- Present insight to senior leadership, Board members, and external stakeholders
- Act as a trusted technical adviser within multidisciplinary teams
5. Capability Building & Innovation
- Improve analytical tools, methods, and workflows across the organisation
- Champion best practice in:
- Data ethics
- Reproducibility
- Accessibility
- Mentor colleagues and contribute to a strong analytical culture
- Support the organisation’s shift toward data informed decision-making
What you bring
We do not expect applicants to demonstrate all of the specific skills outlined, and we are interested in hearing what you can bring to the role.
Essential
Technical and Data
- Solid data analysis and transformation skills, using modern analysis languages (SQL, Python, R) within a cloud-based data environment
- Experience working with both exploratory (notebook-based) and production code
- Experience with data engineering principles and cloud based data architecture
Statistical and Analytical
- Solid applied statistics, including:
- Hypothesis testing
- Regression analysis
- Confidence intervals and effect sizes
- Experience working with complex survey data, including:
- Weighting
- Sampling design
- Cross-national comparison
- Ability to develop reproducible, auditable analytical workflows
- Strong numerical judgement and attention to data quality
Communication
- Effective verbal communication, including presenting to senior and external audiences
- Clear written communication, translating analysis into clear reports and narratives
- Ability to:
- Translate ambiguous stakeholder questions into analytical problems
- Translate findings into actionable insight
Ways of Working
- Senior individual contributor mindset with end-to-end ownership of work
- Effective stakeholder management across a complex organisation
- Experience working with international partners and multidisciplinary teams
Desirable
Technical and Systems
- Familiarity with:
- GCP / BigQuery
- dbt or Dataform
- Git/GitHub workflows
- Experience integrating data from multiple systems (e.g. CRM, finance, web analytics)
- Experience using BI tools (e.g. Looker Studio, Tableau, Power BI)
Advanced and Emerging
- Experience applying AI/LLM tools within analytical workflows
- Experience developing internal analytical tools (e.g. Shiny or equivalent)
- Working knowledge of web analytics data (e.g. GA4)
Statistical / Domain
- Background in survey methodology, social statistics, or policy-relevant analysis
- Experience working with international datasets
- Use of machine learning techniques where appropriate
Leadership and Delivery
- Experience mentoring or developing others
- Experience working with research or communications partners
- Ability to support organisational change toward stronger evidence use
- Experience in building networks, relationships, and ultimately and partnerships with relevant organisations
- Experience of championing data sharing, data collection, data use internally and externally
Design and data storytelling
- Experience in static design work to ensure data led reports are accurate and accessible
- Experience in dynamic web visualisation as a narrative tool or as a lead generator
- Evidence of engaging mixed methods storytelling
Role Impact
- This role is central to the Foundation’s credibility, influence, and effectiveness.
- By ensuring that evidence is:
- Technically robust
- Clearly communicated
- Decision ready
- the Senior Data and Insight Scientist enables the organisation to:
- Shape strategy
- Improve programme delivery
- Strengthen organisational impact
- Contribute to global conversations on safety and wellbeing
#LI-KC1
#LI-Hybrid