At a Glance
- Tasks: Design and maintain scalable data solutions, including ETL pipelines and data warehouses.
- Company: Join a forward-thinking company that values collaboration and innovation.
- Benefits: Enjoy competitive pay, flexible working options, and opportunities for professional growth.
- Other info: Work in a hybrid environment with a focus on continuous improvement and best practices.
- Why this job: Make a real impact by driving data architecture and mentoring future data engineers.
- Qualifications: Expertise in SQL, ETL tools, and data modelling required; mentoring experience is a plus.
The predicted salary is between 60000 - 80000 £ per year.
We are seeking a Senior Data Engineer with deep expertise in SQL, data modelling, and ETL development, alongside strong experience with modern data platforms and business intelligence tools. The ideal candidate will have a proven track record of designing, building, and maintaining scalable data solutions, including enterprise‑grade data warehouses, while ensuring data integrity and enabling advanced analytics across the organisation. This role is suited to an experienced professional who can take ownership of data architecture, mentor junior team members, and drive best practices in data engineering within a collaborative IT environment.
Responsibilities
- Design, develop, and maintain robust, scalable ETL/ELT pipelines to integrate data from multiple systems into centralised data platforms.
- Lead the design, implementation, and ongoing maintenance of data warehouses and data lake architectures.
- Develop and optimise complex SQL queries, stored procedures, and data models to support reporting, analytics, and operational use cases.
- Define and enforce data modelling standards (e.g., dimensional modelling, star/snowflake schemas).
- Collaborate with software engineers, analysts, and business stakeholders to translate requirements into reliable and performant data solutions.
- Oversee data integration processes, ensuring high performance, reliability, and security across all pipelines.
- Implement and champion data quality, validation, and governance frameworks.
- Support and optimise datasets for BI tools such as Power BI, ensuring efficient and scalable reporting solutions.
- Work closely with IT and Infrastructure teams to design secure, scalable, and cost-effective data environments.
- Mentor and support junior data engineers, promoting best practices and continuous improvement.
Preferred Skills
- Advanced proficiency in SQL (T-SQL or PL/SQL), including performance tuning, indexing strategies, and query optimisation.
- Strong experience with ETL/ELT tools such as SSIS, Azure Data Factory, or similar.
- Extensive experience with relational databases (e.g., MS SQL Server, PostgreSQL, MySQL).
- Proven expertise in data warehouse design, implementation, and maintenance.
- Strong understanding of data modelling techniques, including dimensional modelling.
- Hands‑on experience with cloud data platforms (preferably Azure, though AWS or GCP also valuable).
- Solid understanding of data governance, data quality, and security best practices.
- Experience with programming/scripting languages (e.g., Python, .NET, PowerShell) for automation and data processing.
- Familiarity with BI tools such as Power BI or Phocas.
- Experience with version control systems (e.g., Git) and modern development practices.
- Strong analytical thinking and problem‑solving skills.
- Excellent communication skills, with the ability to engage both technical and non-technical stakeholders.
- Ability to work effectively in a hybrid environment (3 days office, 2 days remote).
Data Engineer employer: GSF Car Parts LTD
As a leading employer in the tech industry, we offer a dynamic work culture that fosters innovation and collaboration, particularly for our Data Engineers. Our commitment to employee growth is evident through mentorship opportunities and continuous learning initiatives, all while enjoying the flexibility of a hybrid work environment. Located in a vibrant area, we provide access to cutting-edge technology and resources, ensuring our team can thrive and make a meaningful impact.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Network like a pro! Reach out to your connections in the data engineering field, attend meetups, and engage in online forums. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best projects, especially those involving SQL, ETL processes, and data modelling. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common data engineering questions and scenarios. Practice explaining your past projects and how you tackled challenges, as this will demonstrate your expertise and problem-solving skills.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities waiting for talented data engineers like you. Plus, it’s a great way to ensure your application gets the attention it deserves.
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your SQL expertise, data modelling skills, and experience with ETL development. We want to see how your background aligns with the role, so don’t be shy about showcasing relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about data engineering and how you can contribute to our team. We love seeing candidates who can connect their experiences to our mission.
Showcase Your Projects:If you've worked on any impressive data solutions or have examples of scalable data warehouses, include them in your application. We appreciate candidates who can demonstrate their hands-on experience and problem-solving skills.
Apply Through Our Website:We encourage you to apply directly through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensure it reaches the right people!
How to prepare for a job interview at GSF Car Parts LTD
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries, performance tuning, and indexing strategies. Practising with real-world scenarios can help you articulate your thought process during the interview.
✨Showcase Your ETL Expertise
Be ready to talk about your experience with ETL/ELT tools like SSIS or Azure Data Factory. Prepare examples of how you've designed and maintained ETL pipelines, and be specific about the challenges you faced and how you overcame them.
✨Demonstrate Data Modelling Knowledge
Familiarise yourself with data modelling techniques, especially dimensional modelling and star/snowflake schemas. You might be asked to explain these concepts or even sketch out a model, so having a solid understanding will give you an edge.
✨Engage with Stakeholders
Since collaboration is key in this role, think of examples where you've worked with software engineers, analysts, or business stakeholders. Highlight how you translated their requirements into effective data solutions, showcasing your communication skills and teamwork.
