Analyst (Public Sector Consulting)

IMPOWER Consulting; England; On-site; GBP 36,000 - 44,000; Full time

Benefits offered by this job

Competitive salary + bonus

28 days annual leave + bank holidays

Life assurance and Income Protection

Medical and Dental Insurance

Gym subsidy

Parental/guardian friendly policies

Retail discounts

Job summary

IMPOWER Consulting is seeking an entry level analyst to gather, clean and analyse data to support decision-making for public sector clients. You will generate reports, dashboards and visualisations that tell a story from the data using Excel and BI tools.

Collaborating with stakeholders across projects, you will learn IMPOWER’s EDGEWORK approach and contribute to thought leadership through data-driven insights. A Bachelor’s degree in a related field and strong communication skills are preferred.

Qualifications

• Bachelor’s Degree in a related field or relevant junior experience.
• Strong data analysis and reporting capabilities.
• Proficiency in Excel; PowerBI or Tableau desirable.
• Excellent communication and presentation skills.

Responsibilities

• Collaborate with stakeholders to determine data needs for projects.
• Identify data sources and request data using established templates.
• Perform basic data cleansing to ensure data quality.
• Create analyses using Excel and BI tools to extract insights and explain them clearly.
• Translate data insights into presentations and dashboards.

Skills

Data analysis

Excel

PowerBI

Tableau

Education

Bachelor’s degree in Data Science/Statistics/Computer Science

Tools

Power Query

Job description

Salary: starting from £40,000 + bonus + benefits

About us

IMPOWER is the country’s largest independent management consultancy, focussed exclusively on helping our public sector clients improve services for their local communities - and getting the best use of the public pound.

We understand that impactful and meaningful change cannot be solved sustainably through traditional, liner project management approaches. Our unique EDGEWORK methodology provides our clients with the skills, techniques and mindset to collaboratively solve the complex problems they face – and we have shown that IMPOWER’s way of approaching change has provided better outcomes for service users that have cost our clients less to deliver.

Our team of highly skilled consultants use applied behavioural science, insight, creativity and a talent for building strong relationships to transform public service delivery. If you have a passion for improving public services and the energy to tackle some of our clients’ most difficult challenges, we hope you will be inspired to join our team.

About the role

As an entry level analyst, your primary responsibility will be to gather, clean and analyse data from various sources to provide valuable insights to support decision-making and business operations.

You will be responsible for utilising data tools and techniques to generate reports, dashboards and visualisations that “tell a story” of the insights derived from the data.

Key responsibilities

• Collaborate with stakeholders to determine the specific data needs for projects.
• Identify and understand the data sources required to generate desired insights.
• Request relevant data from appropriate sources using established templates and controlled processes.
• Perform basic data cleansing activities to ensure data quality.
• Utilise existing tools, such as Excel models and 3rd party applications, to support analysis and diagnostic elements of projects.
• Create bespoke analyses using tools likes Excel to extract meaningful insights and explain those insights in clear language.
• Manage and configure existing models to suit the requirements of different clients.
• Monitor and audit data quality used in analyses, identifying potential biases and missing data.
• Take corrective actions as necessary to ensure the accuracy and reliability of insights.
• Collaborate with the wider business to develop broader and collective insights and ideas using existing data to support thought leadership and Value Proposition development.
• Work with cross-functional teams within IMPOWER to understand their analytical needs.
• Translate data analysis results into presentations, dashboards and visualisations using tools like PowerBI.
• Create reports and visual materials that effectively convey generated insights.

About you

• Bachelor’s Degree in a related field, such as Data Science, Statistics and/or Computer Science or relevant experience in a junior level role.
• Data analysis and reporting capabilities.
• Proficiency in data analysis tools, such as Excel, is critical, and other data visualisation software such as PowerBI or Tableau, is desirable.
• Problem-solving skills and ability to think critically and analytically.
• Knowledge of data cleansing and transformation techniques. Experience of data transformation tools, such as Power Query, is desirable.
• Familiarity with data management and data governance principles.
• Ability to work independently and as part of a fast-paced project team.
• Excellent communication and presentation skills.
• Detail-oriented and highly organised
• Local government or health knowledge (desirable)

About our offer

• Competitive salary, with a personal and company-based performance bonus
• 28 days annual leave (+ bank holidays), with buy/sell/rollover scheme
• Life assurance and Income Protection
• Medical and Dental Insurance
• Gym Subsidy contribution, including to online fitness subscriptions
• Parent, guardian, and carer friendly policies
• Discounts at a variety of high street retailers
• Regular training and development opportunities
• Regular team socials and celebrations (even virtual ones!)

About our commitment to Inclusion

At IMPOWER, whilst we are committed to being an equal opportunities employer - our commitment to facilitating a safe, inclusive working environment doesn’t just stop at an Equality and Diversity Policy.

We are an organisation that is actively working towards anti-discrimination of any kind against race, gender, gender identity, sexuality, disability, age, religious belief, parental or carer commitments, marital status or civil partnership. We do this through our D&I strategy, constant review of our policies and procedures, via our recruitment processes, and training and development of our staff.

We have signed up to the Disability Confident scheme and we are committed to ensuring our application and interview processes are inclusive for all candidates. Please email [e-mail] if you require any adjustments.