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
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
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.