Data Analyst

Cambridgeshire County Council; Huntingdonshire; Hybrid; GBP 36,000 - 48,000; Full time

Benefits offered by this job

Wellbeing package

Additional annual leave (salary sac)

Flexible bank holidays

Pension with AVCs

Development opportunities

Volunteering hours

IDEAL network access

Employee Recognition Awards

Cambs Rewards discounts

Job summary

Cambridgeshire County Council is seeking a data analyst who can turn complex information into clear insights to shape services and decisions. You will support development of the modern data platform, champion Power BI reporting, and work with colleagues to implement new data solutions across the organisation.

The role offers hybrid working and opportunities to grow technical skills with real impact. You'll need a strong background in data analysis, experience with Power BI, SQL-based

Qualifications

• Strong data analysis skills with ability to turn data into clear insights.
• Experience with Power BI reporting and data governance best practices.
• Knowledge of SQL-based technologies and data platforms.

Responsibilities

• Prepare and cleanse data, develop data models and dashboards.
• Develop Power BI reports that tell clear data stories for stakeholders.

Skills

Power BI

SQL

Data analysis

Data governance

Education

Two A levels

HNC / HND / NVQ4

Degree or equivalent qualification desirable

Tools

Azure Synapse Analytics

SQL Server Reporting Services

SQL Server Integration Services

Job description

Do you enjoy turning complex data into something people can understand and use? Are you looking for a role where your analysis can help shape services and support better decisions?, It's a great opportunity to work across a varied range of data and technology. You'll contribute to the development of our modern data platform, support our use of Power BI and work with colleagues to introduce new data solutions and technologies. You'll also support important areas of work such as the Supporting Families programme. You'll be joining a team where you can continue developing your technical skills while seeing the practical impact that good data and insight can have across our services. This is a hybrid role and appointment will be subject to the outcome of a Standard Disclosure obtained through the Disclosure and Barring Service. What will you be doing? No two pieces of analysis are exactly the same. You could be working with colleagues to understand what they need from their data, preparing and cleansing information, creating a data model or developing a Power BI report that turns a complex set of information into a clear story. You'll analyse research data and bring findings together, helping colleagues understand what the information is telling them. You'll use different approaches to visualisation to communicate those findings clearly to both technical and non-technical audiences. A key part of the role will be helping us make sure our data can be trusted. You'll contribute to data governance, quality assurance, validation and data linkage, as well as supporting the collection, preparation and cleansing of data. You'll also contribute to the development and implementation of Power BI across the organisation and work alongside other data professionals developing our modern data platform. Depending on the work, you could use technologies including SQL, T-SQL or PL/SQL, Azure Synapse Analytics, Microsoft SQL Server Reporting Services and SQL Server Integration Services. Alongside your day-to-day analysis, you'll contribute to Data Services projects and help integrate new data solutions and technologies. This gives you the opportunity to build your technical knowledge while working on projects with a clear organisational impact., Our Equality, Diversity and Inclusion Strategy, along with our employee network 'IDEAL' and self‑organised peer support groups help us to foster an inclusive, supportive and safe working environment where people feel valued, respected, and empowered. We collect relevant diversity data for monitoring as part of the recruitment process to understand the diversity of our applicants and monitor any trends throughout the recruitment processes so that we can take meaningful action.

You don't need to know every technology we use. We're looking for someone with a strong understanding of working with data and demonstrable knowledge of one or more of the technical areas relevant to the role, such as Power BI, SQL/T-SQL/PL/SQL, Azure Synapse Analytics, SQL Server Reporting Services or SQL Server Integration Services. You'll enjoy solving problems and be curious about what sits behind the numbers. Just as importantly, you'll be able to take what you find and communicate it clearly. You'll be comfortable working with technical colleagues as well as people who may have little experience of working with data. You'll be able to manage competing demands, take responsibility for your work and use your own initiative. We're also looking for someone who wants to keep learning and developing their experience in new technical areas. An understanding of data security, data protection and confidentiality is essential. Experience of working on small to medium‑sized projects is also required, while previous experience of an IT environment, local government data, Early Help or Supporting Families would be useful. You'll need two A levels, an HNC, HND, NVQ Level 4 or equivalent. A degree or equivalent professional qualification and relevant technical certification are desirable rather than essential. Above all, we're looking for someone who is interested in data, keen to develop and wants to use their skills to help people make better‑informed decisions.

Cambridgeshire is a great place to work and live with a diverse population, an urban centre in Cambridge, historic Isle of Ely, Huntingdon and St Ives as well as more rural landscapes. We value our colleagues in Cambridgeshire County Council and have developed a number of benefits in addition to the basics like annual leave, sick pay, pension and mileage…

• A comprehensive wellbeing package to cover all aspects of wellbeing, both in and out of work, which can also be accessed by your family
• Buy up to 4 weeks additional annual leave (pro‑rata) through our salary sacrifice scheme
• Take your bank holidays flexibly to better suit your personal circumstances
• Make Additional Voluntary Contributions (Shared AVCs) to your pension with tax and National Insurance savings
• Access to development opportunities, apprenticeships and qualified coaches to support your personal and professional growth
• Paid volunteering hours each year so you can make a positive impact on our community during your normal working day
• Access to Peer Support Groups through our IDEAL staff equality, diversity and inclusion network
• Opportunities to nominate and receive Employee Recognition Awards
• An Our Cambs Rewards account, giving you access to in‑store and online discounts as well as our Car Lease and Cycle to Work schemes