Data Engineer/Reporting Specialist

JR United Kingdom; Barnsley; On-site; GBP 70,000 - 80,000; Full time

Job summary

A leading company is seeking a Data Engineer and Reporting Specialist for their analytics team. The role involves designing ETL pipelines, optimizing data models, and collaborating with stakeholders to meet data requirements. Candidates should have strong technical expertise in SQL, Python, and experience with cloud data warehouses like Google BigQuery.

Qualifications

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

Responsibilities

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

Skills

SQL

Python

BigQuery

Excel

ETL concepts

Data governance

Data integration

Collaboration

Tools

Google BigQuery

Version control systems (Git)

Workflow orchestration tools (Airflow, dbt)

Job description

Social network you want to login/join with:

col-narrow-left

Client:

Square One Resources

Location:

barnsley, United Kingdom

Job Category:

Other

-

EU work permit required:

Yes

col-narrow-right

Job Views:

2

Posted:

31.05.2025

Expiry Date:

15.07.2025

col-wide

Job Description:

Day Rate: £310 per day inside IR35

Start Date: ASAP

End Date: 28 Nov

Location: Barnsley

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

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