Data Engineer

Data Engineer

Full-Time 40000 - 50000 £ / year (est.) No home office possible
ALH Recruitment

At a Glance

  • Tasks: Develop and optimise data infrastructure, manage databases, and build robust data pipelines.
  • Company: Industry-leading client in Huntingdon with a dynamic team culture.
  • Benefits: Attractive package with opportunities for growth and development.
  • Other info: Collaborative team atmosphere with a focus on best practices in data engineering.
  • Why this job: Join a fast-paced environment and make a significant impact on data solutions.
  • Qualifications: Expertise in T-SQL, Python, and SQL Database Administration required.

The predicted salary is between 40000 - 50000 £ per year.

ALH Recruitment are looking to recruit a Data Engineer with immediate effect for our industry leading client, based in the Huntingdon area of Cambridgeshire.

Role Purpose

As part of their continued growth, we are seeking a Data Engineer with expertise in T-SQL, Python, and some SQL Database Administration (DBA) to join their dynamic team. You will play a pivotal role in the reporting, design, development, and optimisation of their data infrastructure. You will be responsible for managing and reporting on the databases, building robust data pipelines, and ensuring the integrity and performance of critical systems and data warehouses. This is an excellent opportunity for someone who is passionate about data and wants to work in a fast-paced environment where they can make a big impact.

Responsibilities

  • Develop, optimise, and maintain complex T-SQL queries, stored procedures, and functions.
  • Design and implement efficient data pipelines.
  • Support with maintaining Microsoft SSRS and PowerBI reporting.
  • Support in the management of SQL Server databases, including installation, configuration, upgrades, and performance tuning.
  • Support in monitoring database health and if necessary, troubleshoot performance issues.
  • Ensure data quality, normalisation, security, and compliance with internal and external standards.
  • Collaborate with and aid Business Stakeholders in the delivery of efficient data solutions.
  • Assist in developing best practices and standards for data engineering.
  • Adhoc tasks within the department as required.

Key Skills

  • T-SQL and SQL Server (2016 or later preferred).
  • Python for scripting, data processing, and automation.
  • Experience of SQL Database Administrator.
  • Experience of SSIS ETL concepts and data warehouse design principles.
  • Experience of Microsoft SSRS and PowerBI (or similar Reporting Technology).
  • Understanding of Data warehouse Principles.
  • Excellent problem-solving skills and attention to detail.
  • Strong communication skills and the ability to work collaboratively in a team environment.
  • Awareness of source control systems such as Git.
  • Exposure to cloud services (e.g., Azure) & DevOps principles.

If you feel you have the skills and experience to step into this exciting Data Engineer position, please apply below.

Data Engineer employer: ALH Recruitment

Join a forward-thinking company in Huntingdon that values innovation and collaboration, offering an attractive package for Data Engineers. With a strong focus on employee growth, you will have access to continuous learning opportunities and the chance to work with cutting-edge technologies in a supportive environment. Experience a vibrant work culture where your contributions are recognised, and you can truly make an impact on the data landscape.
ALH Recruitment

Contact Detail:

ALH Recruitment Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Engineer

✨Tip Number 1

Network like a pro! Reach out to people in the industry, attend meetups, and connect on LinkedIn. 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 T-SQL queries, Python scripts, and any data projects you've worked on. This will give potential employers a taste of what you can bring to the table.

✨Tip Number 3

Prepare for interviews by brushing up on common data engineering questions and scenarios. Practice explaining your thought process when solving problems, as this will demonstrate your analytical skills and attention to detail.

✨Tip Number 4

Don't forget to apply through our website! We make it easy for you to find and apply for roles that match your skills. Plus, it shows you're serious about joining our team!

We think you need these skills to ace Data Engineer

T-SQL
SQL Server
Python
SQL Database Administration
SSIS ETL concepts
Data warehouse design principles
Microsoft SSRS
PowerBI
Data quality management
Database performance tuning
Problem-Solving Skills
Attention to Detail
Communication Skills
Collaboration
Source control systems (e.g., Git)
Cloud services (e.g., Azure)
DevOps principles

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your experience with T-SQL, Python, and SQL Database Administration. We want to see how your skills match the role, so don’t be shy about showcasing relevant projects or achievements!

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. Keep it concise but engaging – we love a good story!

Showcase Your Problem-Solving Skills: In your application, give examples of how you've tackled challenges in past roles. We’re looking for someone who can think on their feet and come up with innovative solutions, so let us know how you’ve done this before!

Apply Through Our Website: We encourage you to apply directly through our website. It’s the easiest way for us to receive your application and ensures you don’t miss out on any important updates from our team!

How to prepare for a job interview at ALH Recruitment

✨Know Your Tech Inside Out

Make sure you brush up on your T-SQL, Python, and SQL Server knowledge. Be ready to discuss specific projects where you've used these skills, and think about how you can demonstrate your problem-solving abilities with real examples.

✨Showcase Your Data Pipeline Experience

Prepare to talk about your experience in designing and implementing data pipelines. Have a couple of examples ready that highlight your understanding of ETL concepts and how you've optimised data flow in previous roles.

✨Be Ready for Scenario Questions

Expect questions that put you in hypothetical situations related to database performance issues or data integrity challenges. Think through how you would approach troubleshooting and what steps you would take to resolve these issues.

✨Communicate Clearly and Collaboratively

Since the role involves working with business stakeholders, practice explaining technical concepts in simple terms. Show that you can communicate effectively and work as part of a team, as this is crucial for success in a dynamic environment.

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>