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 focused on transforming data into actionable insights.
- Benefits: Enjoy hybrid work options, competitive pay, and opportunities for skill development.
- Why this job: Be part of a collaborative culture that values innovation and data-driven decision-making.
- Qualifications: Proficiency in SQL, Python, and BigQuery is essential; experience with Excel is a must.
- Other info: This is a contract role until November 2025, perfect for tech-savvy individuals.
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 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!
Data Engineering and Reporting Specialist employer: Undisclosed
Contact Detail:
Undisclosed Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineering and Reporting Specialist
✨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 have experience with ETL processes and data warehousing. Attend industry meetups or webinars to connect with potential colleagues and learn about the latest trends.
✨Tip Number 3
Prepare for technical interviews by practising common data engineering problems and scenarios. Use platforms like LeetCode or HackerRank to sharpen your SQL and Python skills, focusing on data manipulation and ETL tasks.
✨Tip Number 4
Demonstrate your problem-solving abilities by preparing examples of past projects where you successfully managed data workflows or improved reporting processes. Be ready to discuss these experiences during interviews to highlight your expertise.
We think you need these skills to ace Data Engineering and Reporting Specialist
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 collaborated with stakeholders in the past.
Showcase Relevant Projects: If you have any relevant projects or case studies, include them in your application. This could be links to GitHub repositories or descriptions of previous work that demonstrate your technical expertise and problem-solving abilities.
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 Undisclosed
✨Showcase Your Technical Skills
Make sure to highlight your proficiency in SQL, Python, and BigQuery during the interview. Prepare examples of how you've used these tools to build ETL pipelines or automate reporting solutions, as this will demonstrate your technical expertise.
✨Understand the Role's Requirements
Familiarise yourself with the key responsibilities outlined in the job description. Be ready to discuss how your previous experiences align with tasks like data transformation, maintaining data quality, and collaborating with stakeholders.
✨Prepare for Problem-Solving Questions
Expect questions that assess your problem-solving skills and attention to detail. Think of specific challenges you've faced in data engineering and how you overcame them, as this will showcase your analytical abilities.
✨Demonstrate Communication Skills
Since collaboration is crucial for this role, be prepared to discuss how you've effectively communicated complex data concepts to non-technical stakeholders. This will show that you can bridge the gap between technical and business teams.
