Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our team to design and maintain ETL pipelines and create automated reporting solutions.
- Company: We're a dynamic analytics team based in Barnsley, focused on data-driven decision-making.
- Benefits: Enjoy a competitive day rate and the chance to work with cutting-edge technologies.
- Why this job: Transform raw data into impactful insights while collaborating with diverse stakeholders.
- Qualifications: Proficiency in SQL, Python, and experience with BigQuery are essential for this role.
- Other info: This position is inside IR35, starting ASAP until 28 November.
The predicted salary is between 60000 - 84000 £ per year.
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.
Data Engineer/Reporting Specialist (Barnsley) employer: Square One Resources
Contact Detail:
Square One Resources Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer/Reporting Specialist (Barnsley)
✨Tip Number 1
Familiarise yourself with the specific tools mentioned in the job description, such as SQL, Python, and BigQuery. Consider working on personal projects or contributing to open-source projects that utilise these technologies to showcase your skills.
✨Tip Number 2
Network with professionals in the data engineering field, especially those who work with ETL processes and data warehousing. Attend local meetups or online webinars to connect with potential colleagues and learn about industry trends.
✨Tip Number 3
Prepare to discuss your problem-solving approach during interviews. Think of specific examples where you've successfully tackled data-related challenges, particularly in building ETL pipelines or optimising data models.
✨Tip Number 4
Showcase your communication skills by being ready to explain complex data concepts in simple terms. This will demonstrate your ability to collaborate effectively with business stakeholders and ensure their data needs are met.
We think you need these skills to ace Data Engineer/Reporting Specialist (Barnsley)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL, Python, and BigQuery. Include specific examples of ETL pipelines you've built and any automated reporting solutions you've created.
Craft a Compelling Cover Letter: In your cover letter, express your passion for data engineering and reporting. Mention how your skills align with the job requirements and provide examples of how you've successfully collaborated with stakeholders in the past.
Showcase Relevant Projects: If you have worked on relevant projects, consider including a portfolio or a brief description of these projects in your application. Highlight your problem-solving skills and attention to detail in these examples.
Proofread Your Application: Before submitting, carefully proofread your application for any spelling or grammatical errors. A polished application reflects your attention to detail, which is crucial for this role.
How to prepare for a job interview at Square One Resources
✨Showcase Your Technical Skills
Be prepared to discuss your proficiency in SQL, Python, and BigQuery. Bring examples of past projects where you built ETL pipelines or automated reporting solutions, as this will demonstrate your hands-on experience and technical expertise.
✨Understand the Role's Responsibilities
Familiarise yourself with the key responsibilities outlined in the job description. Be ready to explain how your previous experiences align with tasks like data transformation, building data models, and ensuring data quality.
✨Prepare for Problem-Solving Questions
Expect questions that assess your problem-solving skills. Think of specific challenges you've faced in data engineering or reporting, and be ready to discuss how you approached and resolved them.
✨Communicate Effectively
Strong communication is crucial for this role. Practice explaining complex technical concepts in simple terms, as you'll need to collaborate with business stakeholders. Show that you can bridge the gap between technical and non-technical teams.
