Data Engineering and Reporting Specialist

ZipRecruiter; Barnsley; Hybrid; GBP 60,000 - 75,000; Full time

Job summary

A leading company seeks a detail-oriented Data Engineering and Reporting Specialist to develop ETL pipelines and manage data quality. This hybrid role involves transforming raw data into actionable insights, leveraging expertise in SQL, Python, and data visualization tools. Ideal for professionals with a strong analytical background, this contract position runs until November 2025.

Qualifications

• Proficient in SQL for complex queries and performance tuning.
• Strong experience with Python for data manipulation and automation.
• Knowledge of BI tools like Looker, Tableau, or Power BI.

Responsibilities

• Design and maintain ETL pipelines for data ingestion and transformation.
• Build optimized data models in BigQuery for analytics.
• Collaborate with stakeholders to define data requirements and ensure data quality.

Skills

SQL

Python

BigQuery

Excel

ETL

Tools

Google BigQuery

Looker

Tableau

Power BI

Git

Airflow

dbt

Job description

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.

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!