Business intelligence analyst jobs in birmingham

SQL Insight Analyst

Salary: Up to £40,155 per annum   

Location: Remote with quarterly travel within the UK. See the “Please Note” section below for further details.

The vacancy   

We have an exciting opportunity for a SQL INSIGHT ANALYST to join our Data, Insight and Research Team working to support teams charity wide in making data-driven decisions. If you believe in the power of data, evidence and how that can help the lives of our armed forces community, this is the role for you. 

Please see below for more information on what just might be your future role.  

About The Role  

As a SQL Insight Analyst, you will be at the heart of our charity’s ambition to drive our decision making through evidence and data backed insights. Working closely with the rest of the Data, Insights and Research team to enable their access to aggregated or granular data points from our Services and Fundraising databases.

You will become an expert on the data points we collect at Help For Heroes and gain understanding of how these all play a part in achieving our overall goal of ensuring Members of the Armed Forces Community Live Well after Service.

About You  

You will be a highly motivated SQL code writer with a passion for making a difference in our community. You will need a sharp and dynamic mind that can infer the business logic that underpins the work we do. You will have the adaptability to be able to speak both in business logic and in the translated SQL language that access the data points needed to provide insight on a particular business challenge. Good organisational skills, energy and the ability to listen, build relationships and inspire both confidence and curiosity within our dataset will be essential to drive the change the Charity is looking for.

We are looking for someone with:  

• The ability to write efficient and accurate SQL code.

• An aptitude for understanding business logic and translating that into all code written.

• Strong communication skills to ensure that requirements are agreed and understood on both sides of the ask.

• Basic knowledge of BI tools, in order to implement connections and code to allow for visualisation of the aggregated data.

• Effective and efficient organisational and IT skills. 

PLEASE NOTE:  

• We meet as a team quarterly, most often in London or in Downton (near Salisbury). Travel and accommodation if required would be provided.

• The successful candidate will work 35 hours per week over 5 days, Monday - Sunday. Core working days will be Monday to Friday with core working hours of 10am-3pm. Working hours will vary to ensure a total of 70 hours is covered over a two-week period, so please take this into consideration before applying.  

• The successful candidate will be required to undergo a Disclosure and Barring Service (DBS) check   

About the Team  

You’ll be joining a dynamic team of Research and Data Analysts who are passionate about supporting people to make a difference in their lives. We amplify the strengths already present in communities, forge lasting partnerships and initiatives that empower members of the AFC to thrive. Together, the Research and Data analysts provide the insights that empower leadership across the charity to make decisions that move us towards our goal of Armed Forces Community Members living well after service.

Please see the job description for more details.  

Closing date: 14th November 2025 

Please note: We may close this vacancy early should we receive a high volume of strong applications.  

About the Role:

This is an exciting opportunity to join the Refugee and Migrant Centre, a well-established and award-winning charity dedicated to supporting refugees, asylum seekers, and vulnerable migrants. Our mission is to break down barriers to integration and empower individuals to achieve equal citizenship through holistic support services.

As a Data Analyst you will play a key role in strengthening our evidence base and improving service delivery through robust data analysis and reporting. Your insights will directly inform strategic decisions, support funding bids, and help shape services that improve lives. You will work closely with operational teams to collect, cleanse, and interpret data that enhances our understanding of beneficiary needs and outcomes. This role is a chance to use your skills to make a lasting social impact.

Main Tasks and Responsibilities:

Data Management and Analysis

· Collect, cleanse, and validate data from multiple sources, conducting regular checks to identify and resolve gaps or inconsistencies

· Maintain and improve internal databases to ensure data accuracy and consistency

· Analyse quantitative and qualitative data to identify trends, patterns, and areas for improvement

· Contribute to the design and implementation of data collection processes for new projects

· Identify inefficiencies and compare service delivery against targets to support continuous improvement

· Supplement internal data with external sources for deeper insights

· Drive innovation by exploring new tools and automating reporting systems that improve efficiency and transparency

Reporting and Insight

· Prepare regular funder and management reports, including mixed-methods analysis

· Translate data into accessible insights for non-technical audiences.

· Support the Impact and Evaluation Manager in preparing for strategic planning

· Explore and assist with building a bespoke, automated social value tool

· Produce regular reports and automated dashboards for internal and external stakeholders

· Support the development of outcome frameworks and impact measurement tools

Collaboration and Support

· Work closely with caseworkers and project leads to ensure accurate and timely data entry

· Collaborate with external partners on joint data initiatives and shared reporting

· Establish monitoring for social policy data and provide insights to support partnership work and influence policy

· Promote a culture of data driven, evidence-based practice

·      Provide training and guidance to staff on data collection and reporting requirements and build capacity across teams by supporting data literacy and embedding data into everyday decision-making

Systems and Tools

· Use Microsoft Excel and other relevant tools to manage and visualise data

· Explore, source and support the integration of new digital tools and platforms to improve data workflows

· Ensure compliance with data protection regulations and internal policies

Training

· Participate in relevant training and professional development opportunities to stay informed about sector trends and enhance personal skills

· Stay up to date with legal and policy changes relevant to the sector

· Keep accurate records of training attended and share learning with colleagues

· There is scope to further develop expertise in impact measurement, evaluation methodologies, and other monitoring skills as desired

Person Specification

Essential:

· Experience working with large datasets and producing analytical reports

· Strong proficiency in Microsoft Excel and data visualisation tools (e.g. Power BI)

· Understanding of data protection and confidentiality principles

· Excellent attention to detail, organisation, and time management

· Strong written and verbal communication skills, with the ability to explain technical information clearly to non-specialist audiences

· Proven ability to manage multiple deadlines and competing priorities within a multi-disciplinary team

· Experience in data research and using insights from a variety of external sources, such as government data, to support analysis

· Awareness of the opportunities and risks of using AI and data-driven technologies in the charity sector

· Commitment to RMC’s values of empowerment, inclusion, quality, and collaboration

Desirable:

· Experience in the charity or public sector, particularly with refugee and migrant communities

· Familiarity with case management systems and platforms

· Knowledge of impact measurement frameworks and evaluation methodologies

· Experience supporting training or capacity-building in data literacy

· Ability to work with qualitative data and contribute to mixed-methods research

· Understanding of social value and how it applies to service delivery and evaluation

· Awareness of the challenges and barriers faced by refugees and migrants in the UK

Flexibility 

In order to deliver the stated aims of this post, a degree of flexibility is needed and the post holder may be required to perform work not specifically referred to above. This could include data, administrative and/or project support to other cross-organisational departments. Such duties will fall within the scope of the job within the appropriate pay grade. The job description will therefore be subject to periodic review with the post holder to ensure it accurately reflects the duties that are being performed.

Equal Opportunities

We're an equal opportunity employer, which means we'll consider all suitably qualified applicants regardless of gender identity or expression, ethnic origin, nationality, religion or beliefs, age, sexual orientation, disability status or any other protected characteristic. We recruit and develop our people based on merit and their passion for creating better outcomes, and we're committed to creating an inclusive environment for all employees.

Join MSI UK as a Lead Analytics Engineer and make a real impact with your skills.

Are you ready to lead transformative analytics in a mission-driven organisation? At MSI Reproductive Choices UK, we’re looking for a Lead Analytics Engineer to shape the future of data-driven decision-making in one of the world’s leading providers of sexual and reproductive healthcare.

Hours: Full time, 35 hours per week
Contract: Permanent
Salary: £58,969.32 - £64,866.26 (Depending on experience)

The Role

As Lead Analytics Engineer, you’ll:

• Design and deliver impactful analytics solutions using Power BI and Azure Analysis Services.
• Lead a team of analytics professionals, mentoring and setting best practices.
• Introduce machine learning and AI to support predictive insights.
• Collaborate with stakeholders to drive data-informed decisions across the organisation.

What You’ll Bring

• Proven experience in analytics, BI, or data science with both hands-on technical delivery and leadership responsibilities.
• Expertise in Power BI, SQL, and semantic modelling.
• Experience applying ML / AI techniques (e.g., predictive modelling, NLP) to real-world problems.
• Excellent communication skills and a passion for mentoring.
• A degree in a relevant field or equivalent experience;
• Relevant certifications in Power BI, Azure, or data science are a plus.

What We Offer – More Than Just a Job
We support your wellbeing, growth, and work-life balance with a range of benefits:

Financial Benefits

• Competitive salary with clear progression
• Up to 5% employer pension contribution
• Blue Light Card discounts

Health & Wellbeing

• 24/7 Employee Assistance Programme
• GP consultations via Doctor Line
• On-site Mental Health First Aiders

Work-Life Balance

• Bank holidays and weekends off
• Birthday bonus day off
• Family-friendly policies

Career Development

• Training and development
• Accredited apprenticeship opportunities
• Clear career progression routes

Ready to lead with data? Apply now and drive meaningful change.