Role Title: Data Engineer/Reporting Specialist
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