Analytics Engineer

GMCA; Manchester; Hybrid; GBP 60,000 - 90,000; Full time

Job summary

GMCA is seeking an Analytics Engineer to shape the data infrastructure and analytical products that support education, work and skills decisions across Greater Manchester. You will design and build pipelines, data models and reporting products from providers, local authorities and government data sources, leveraging SQL Server, Python, APIs, Power BI and Microsoft Fabric.

You will also lead a small team, setting priorities and establishing a shared standard of practice across the function, while

Qualifications

• Hands-on engineer who builds reliable data infrastructure and reporting products.
• Proficient with SQL Server, data modelling and ETL; comfortable automating with Python.
• Experience leading or supervising others and communicating with both technical and non-technical audiences.

Responsibilities

• Design and build pipelines, data models and reporting products from raw data to insight.
• Lead a small team of data officers and set priorities.
• Act as technical lead for the GMCA data tracker and manage integrations with the broader reporting environment.

Skills

SQL Server

Data modelling

ETL

Power BI

Python

APIs

Tools

Microsoft Fabric

Job description

Your role:

Help shape the data infrastructure and analytical products that support decisions across education, work and skills in Greater Manchester. This is an opportunity to shape the technical foundations of a data function as it is being built. The Education, Work and Skills Directorate at Greater Manchester Combined Authority is developing the data and MI capability that underpins how skills, employment and youth/technical/adult education are delivered across the city region, and we are looking for an Analytics Engineer to lead its technical delivery.

You will design and build the pipelines, data models and reporting products that turn raw data from providers, local authorities and government departments into insight that shapes policy and investment decisions. Working across SQL Server, Python, APIs, Power BI and Microsoft Fabric, you will automate reporting that is currently manual / semi-automated and build architecture that will serve the directorate for years to come.

You will also lead a small team of data officers, setting priorities, supporting their development and establishing a shared standard of practice across the function.

As technical lead for the Greater Manchester Information Tracker, our core participant data system, you will hold the day-to-day relationship with the platform and the integrations that connect it to our wider reporting environment.

About you:

You are a hands-on engineer who takes pride in building things that work reliably and are understood by the people who depend on them. You know SQL Server, data modelling and ETL, Power BI and you are comfortable automating with Python preferably, and you think carefully about how data is modelled rather than reaching for the quickest fix.

You have led or supervised others and you enjoy it. You are the person colleagues come to when something breaks, and you explain what happened. You are at ease with technical and non-technical audiences, and you can tell the difference between what someone has asked for and what they actually need.

You will bring curiosity, sound judgement and a commitment to doing things properly, alongside a genuine interest in public service. Experience of education, skills or employment data would be welcome, but we are more interested in how you think than in the sector you have worked in. We welcome applications from candidates of all backgrounds who want to apply their skills to support Greater Manchester’s mission to be a thriving, inclusive city region where everyone can live a good life.

Selection process:

Shortlisted candidates will be asked to complete a technical exercise using synthetic data and discuss their approach at interview. The assessment will test technical reasoning, data modelling, automation, reporting and judgement.

We do not expect a highly polished production solution. We are interested in clear decisions, sensible trade-offs and your ability to explain and adapt your work. Reasonable adjustments will be available throughout the process.

About us:

The Greater Manchester Combined Authority (GMCA) brings together the cityregion’s ten councils and key partners including Greater Manchester Fire and Rescue Service (GMFRS) and Transport for Greater Manchester (TfGM) - to deliver the Greater Manchester Strategy. Our shared vision is to create a thriving city region where everyone can live a good life. We work to grow an inclusive economy and ensure people have what they need to live happy, healthy lives, tackling inequalities. Our policy department include Digital, Economy, Education, Work & Skills, Environment, Place Making, Public Service Reform, and Safer & Stronger Communities - who are supported by our essential corporate functions like Finance, Legal & Governance, People Services, Procurement and Communications.

We value the diversity of our employees, and aim to recruit a workforce which reflects our diverse communities across Greater Manchester. We encourage applications from all suitably qualified individuals, irrespective of people’s age, disability, Trans status and Non-binary identity, marriage and civil partnership, pregnancy and maternity, race, religion or belief, sex and sexual orientation. We have guidance in place to ensure that all applicants are treated fairly and consistently at every stage of the recruitment process, including the consideration of reasonable adjustments for people who have a disability.

Our offer:

In return for your hard work, we offer our employees a competitive package as part of our offer that you can find out more about here:

Greater Manchester Combined Authority - Home | greater.jobs

Mandatory Information:

Artificial Intelligence (AI)

We embrace AI to enhance our operations and to innovate our services. However, we value human talent and are looking for passionate individuals to join our organisation. Please ensure you personally complete your application and read all the instructions carefully to maximise your chances of success.

Applications that rely too heavily on AI may be rejected during shortlisting, however we understand that AI may be used as a reasonable adjustment, if using AI to support your application, please give a brief explanation why to help ensure fair selection process.

Privacy Notice

Employees on the redeployment register will be given priority for any vacancies in the first instance. If employees are identified as a match from the register then the vacancy may be withdrawn or put on hold pending an outcome.

For this opportunity, you must be able to prove you have the right to work in the UK - if in doubt please visit the following link Employers' right to work checklist - GOV.UK (www.gov.uk). Please note we are not a licenced sponsor.

Hybrid working

This role is part of GMCA’s hybrid working scheme. As part of our commitment to ‘Build Back Fairer’ in Greater Manchester following the Covid-19 pandemic, we have evolved our management methods by trusting and empowering staff to deliver their work in the best way that suits the business and their individual needs, and supports health and wellbeing. Our hybrid working policy sets out a flexible approach, combining attendance at our on-site locations with remote working, typically from home; the location of work is primarily dictated by the needs of the business: ‘Do what is right for you and the business on that day’. If appointed to the role you will work with your manager to agree and regularly review the best working pattern for you, your team and your work.

ENHANCED DBS

The role holder will be subject to an Enhancedlevel check by the Disclosure & Barring Service.

This post involves working with children, young people or vulnerable adults and is therefore exempt from the Rehabilitation of Offenders Act. Failure to disclose information when asked within this application could result in dismissal but will not necessarily be a bar to employment with us. The amendments to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (2013 and 2020) provides that when applying for certain jobs and activities, certain convictions and cautions are considered ‘protected’. This means that they do not need to be disclosed to employers, and if they are disclosed, employers cannot take them into account. Guidance about whether a conviction or caution should be disclosed can be found on the Ministry of Justice website.

Safeguarding Policy and Procedure

Supporting Documents

Analytics Engineer Role Profile