Data Engineering and Reporting Specialist

Experis - ManpowerGroup; Barnsley; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading company is seeking a Data Engineering and Reporting Specialist for a contract role in Barnsley. This position involves designing ETL pipelines, optimizing data models, and collaborating with stakeholders to create insightful dashboards. Ideal candidates will possess strong skills in SQL, Python, and BigQuery, and have a passion for data quality and governance.

Qualifications

• Proficiency in SQL for complex queries and data transformation.
• Strong experience with Python for data manipulation.
• Hands-on experience with Google BigQuery or similar.

Responsibilities

• Design, develop, and maintain ETL pipelines for data ingestion.
• Build and optimize data models in BigQuery.
• Create automated reporting solutions using Excel and SQL.

Skills

SQL

Python

BigQuery

Excel

ETL

Data Integration

Data Warehousing

Problem Solving

Communication

Tools

Git

Airflow

dbt

Job description

Role Title: Data Engineering and Reporting Specialist
Duration: contract to run until 28/11/2025
Location: Barnsley, hybrid 2 days per week onsite
Rate: up to £303.70 p/d Umbrella inside IR35

Role purpose / summary

We are seeking a highly skilled and detail-oriented Data Engineer and Reporting Specialist to join our analytics and reporting team. This role is ideal for someone with strong technical expertise in SQL, Python, BigQuery, and Excel, and a passion for building robust ETL pipelines and integrating data from diverse sources. You will play a key role in transforming raw data into curated datasets that power dashboards, reports, and strategic decision-making.

Key Skills/ requirements

• Design, develop, and maintain ETL pipelines to ingest, transform, and load data from various sources into centralized data platforms.
• Build and optimize data models and data marts in BigQuery to support analytics and reporting needs.
• Create and maintain automated reporting solutions using Excel, SQL, and Python.
• Collaborate with business stakeholders to understand data requirements and translate them into scalable datasets and dashboards.
• Ensure data quality, consistency, and governance across all reporting layers.
• Monitor and troubleshoot data workflows and performance issues.
• Document data processes, definitions, and architecture for transparency and knowledge sharing.

Required Skills and Qualifications:

• Proficiency in SQL for complex queries, data transformation, and performance tuning.
• Strong experience with Python for data manipulation, automation, and scripting.
• Hands-on experience with Google BigQuery or similar cloud data warehouses.
• Advanced skills in Microsoft Excel, including pivot tables, formulas, and data visualization.
• Solid understanding of ETL concepts, data integration, and data warehousing best practices.
• Familiarity with version control systems (e.g., Git) and workflow orchestration tools (e.g., Airflow, dbt) is a plus.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration abilities.

Preferred Qualifications:

• Experience working in agile or cross-functional teams.
• Knowledge of BI tools such as Looker, Tableau, or Power BI.
• Background in data governance, security, and compliance.

All profiles will be reviewed against the required skills and experience. Due to the high number of applications we will only be able to respond to successful applicants in the first instance. We thank you for your interest and the time taken to apply!