Data Engineering and Reporting Specialist

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 Umbrellainside 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!