Data Engineer

GMCA; Manchester; On-site; GBP 55,000 - 75,000; Full time

Job summary

GMCA is seeking a Data Engineer to lead scalable data pipelines and support the DDaT strategy on a permanent basis. You will work across cross-functional teams to deliver data-driven insights and maintain secure, compliant data landscapes.

The role requires strong SQL/ETL skills, experience with Microsoft Fabric, Power BI and related Microsoft stack tools, with a commitment to data quality and automation.

Qualifications

• Degree-level education or significant demonstrable experience in a relevant field.
• Understanding of data warehousing and data modelling concepts.
• Understanding of relational database concepts.

Responsibilities

• Lead development of stable, reusable, scalable data pipeline solutions.
• Liaise with suppliers, contractors, and service providers to implement data pipelines.
• Guide and inform the organisation on tools and methods for automation and data visualization.
• Administer data and application security; ensure compliance with standards and legislation.
• Monitor ETL performance and drive improvements.
• Coach and mentor use of data engineering tools and processes.
• Manage incidents, problems and service desk requests.

Skills

Data pipelines

Data warehousing

Data modelling

Relational databases

Transact-SQL

Power BI

SQL Server/SSIS/SSRS/SSMS

Microsoft Fabric

Dashboard design

Azure data services

Education

Bachelor's degree or equivalent experience

Tools

SSIS

SSMS

SSRS

Visual Studio

Power BI

Microsoft Fabric

Job description

Data Engineer x 2

Permanent

The role

Greater Manchester Combined Authority (GMCA) is at the forefront of innovation in digital services. We are committed to enhancing our data-driven capabilities to support our Digital Data and Technology (DDaT) strategy. As we continue to grow, we are seeking a talented and dedicated Data Engineer to join our Digital Team on a permanent contract basis.

You will be responsible for leading in and developing of stable, reusable, and scalable data pipeline solutions in line with GMCA's DDaT Strategy. Working with cross-functional teams to implement digital solutions to address data-related issues.

You will be joining an award-winning digital service that is enabling the organisation to be one of the leading Combined Authorities in the country and supporting the reform of public services across Greater Manchester in line with the Greater Manchester Strategy.

The role holder will:

• Lead the development of stable, reusable, and scalable data pipeline solutions in line with GMCA's DDaT Strategy utilising GMCA's Microsoft Fabric platform.
• Liaise with suppliers, contractors, and service providers to implement data pipelines from multiple data sources into our dedicated Fabric and SQL platforms.
• Guide and inform the organization on tools and methods for process automation and data visualization to deliver insights from our data.
• Administer the security of data and application technologies, ensuring compliance with organizational standards and legislation.
• Proactively monitor the performance and improvements of the organization’s data ETL processes.
• Coach and mentor organizational use of data engineering tools, techniques, and processes.
• Manage and resolve incidents, problems, and requests as logged on the organization’s Service Desk.

About you:

• Be educated to degree level in a relevant subject or significant demonstrable experience.
• Understand Data Warehousing and Data Modelling concepts.
• Understand Relational database concepts.
• Have experience of using the following:
  • Microsoft SQL Server Integration Services (SSIS).
  • Microsoft SQL Server Management Studio (SSMS).
  • Microsoft SQL Server Reporting Services (SSRS).
  • Microsoft Visual Studio.
  • Microsoft Power BI.
  • Microsoft Fabric.
• Have experience of writing and understanding complex Transact SQL queries.
• Creating user friendly dashboards with SSRS, Power BI and similar tools.
• Utilising Extract, Transform and Load (ETL) processes to merge multiple data sets into a database (SQL, Azure etc).
• Microsoft certification in relevant area or commitment to gaining certification at a minimum level of Microsoft Fundamentals.
• Assist in Business Continuity Planning and Disaster Recovery activities to maintain a stable, available, and secure data landscape.

About us:

As an employer, the Greater Manchester Combined Authority (GMCA) is made up of a number of key Greater Manchester strategic functions and service providers including; Greater Manchester Fire and Rescue Service (GMFRS); Waste and Resources; Environment; Work and Skills; Research; Public Sector Reform; Police, Crime and Criminal Justice; Homelessness; the Greater Manchester Ageing Hub and the Commissioning Hub.

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.

To find out more about working for us please click here: https://www.greatermanchester-ca.gov.uk/

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:

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 [Manchester city centre office / Fire and Rescue service HQ in Swinton / other location] 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.

Supporting Documents

Role Profile - Data Engineer