Data Engineering and Reporting Specialist

Data Engineering and Reporting Specialist

Posted 2 weeks ago by Experis UK

Apply
£304 Per day
Inside
Hybrid
Barnsley, England, United Kingdom
Apply
Agile Methodology Airflow Apache Airflow Automation BigQuery Business Intelligence Tools Cloud Computing Cloud Technology Data Engineering Data Governance Data Integration Data Manipulation Datamodel Data Modeling Data Quality Data Transformation Data Visualisation Data Warehousing Extract Transform Load (ETL) Git (Version Control System) Microsoft 365 Microsoft Excel Performance Tuning Pivot Tables And Charts Power BI Python (Programming Language) Raw Data Scripting SQL (Programming Language) Stakeholder Management Strategic Decision-Making Tableau (Business Intelligence Software) Transparency (Human-Computer Interaction) Version Control Workflows

Summary: The Data Engineering and Reporting Specialist role involves designing and maintaining ETL pipelines, optimizing data models, and creating automated reporting solutions. The position requires strong technical skills in SQL, Python, BigQuery, and Excel, with a focus on data quality and governance. The role is hybrid, requiring two days per week on-site in Barnsley, and is classified as inside IR35. The contract is set to run until November 28, 2025.

Key Responsibilities:

  • 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.

Key Skills:

  • 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.

Salary (Rate): £303.70 daily

City: Barnsley

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

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!

Apply
Similar Jobs
Loading data...