Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join our tech team to build and maintain scalable data solutions using SQL and AWS tools.
- Company: Be part of a dynamic company focused on data-driven decision-making and innovative technology.
- Benefits: Enjoy opportunities for remote work, skill development, and collaboration with diverse teams.
- Why this job: This role offers hands-on experience with cutting-edge technologies and the chance to solve real-world data challenges.
- Qualifications: Strong SQL skills and experience with data integration tools like SSIS are essential; AWS knowledge is a plus.
- Other info: Ideal candidates are curious, detail-oriented, and eager to optimize data solutions.
The predicted salary is between 28800 - 48000 £ per year.
Role Overview
We are looking for a Data/BI Engineer to join our technology team and contribute to the development and maintenance of scalable data solutions. This role involves working with structured and unstructured data, integrating new sources, and optimizing data pipelines to support reporting and analytics.
The position focuses on SQL Server as the primary database technology, with an increasing emphasis on cloud-based services , including AWS tools such as Athena, Glue, and SageMaker .
This role will play a key part in enabling data-driven decision-making by ensuring efficient data processing and high-quality insights.
Key Responsibilities
- Collaborate with stakeholders to define and scope data processing requirements.
- Develop and maintain data pipelines using SQL, SSIS, AWS Glue, and Athena .
- Optimize and debug SQL Server procedures, functions, and queries for performance and efficiency.
- Work with internal teams to integrate data from various sources into a centralized data platform.
- Ensure data quality, consistency, and reliability for business intelligence and analytics.
- Stay updated on cloud-based data pipeline tools and big data technologies to enhance scalability and performance.
Skills & Experience
Required:
- Strong proficiency in SQL Server (T-SQL, Query Optimization, Indexing, Partitioning) .
- Experience with SSIS for data integration and ETL processes.
- Scripting knowledge using PowerShell .
- Familiarity with data modeling and designing efficient database structures.
- Strong problem-solving and analytical skills.
Preferred:
- Experience with AWS services (Glue, Lambda, Redshift, Athena).
- Knowledge of big data technologies and scalable data architectures.
- Proficiency in Python for data processing and automation.
Ideal Candidate Traits
Successful candidates typically:
- Have a passion for working with data and solving complex challenges.
- Are curious, detail-oriented, and proactive in optimizing data solutions.
- Demonstrate strong time management and prioritization skills.
- Adapt well to changing requirements and business needs.
- Communicate effectively and collaborate across teams.
- Take ownership of their work and seek continuous improvement.
Data Engineer employer: Haystack
Contact Detail:
Haystack Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Make sure to familiarize yourself with SQL Server and its optimization techniques. Understanding T-SQL, indexing, and partitioning will give you a solid foundation to discuss your technical skills during the interview.
✨Tip Number 2
Brush up on your knowledge of AWS services, especially Glue and Athena. Being able to demonstrate how you've used these tools in past projects can set you apart from other candidates.
✨Tip Number 3
Showcase your problem-solving skills by preparing examples of complex data challenges you've tackled. Be ready to discuss your thought process and the impact of your solutions on business outcomes.
✨Tip Number 4
Highlight your ability to collaborate with different teams. Prepare to share experiences where you worked cross-functionally to integrate data sources or improve data quality, as this is crucial for the role.
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Understand the Role: Before applying, make sure you fully understand the responsibilities and requirements of the Data Engineer position. Familiarize yourself with SQL Server, AWS tools, and data pipeline optimization.
Tailor Your CV: Highlight your experience with SQL Server, SSIS, and any relevant AWS services in your CV. Use specific examples to demonstrate your proficiency in data integration and problem-solving skills.
Craft a Strong Cover Letter: In your cover letter, express your passion for data and how your skills align with the company's needs. Mention your experience with cloud-based services and your ability to collaborate with stakeholders.
Showcase Relevant Projects: If you have worked on projects involving data pipelines, SQL optimization, or AWS tools, be sure to include these in your application. This will help illustrate your hands-on experience and technical capabilities.
How to prepare for a job interview at Haystack
✨Showcase Your SQL Expertise
Be prepared to discuss your experience with SQL Server in detail. Highlight specific projects where you optimized queries or improved performance, and be ready to demonstrate your knowledge of T-SQL, indexing, and partitioning.
✨Demonstrate Your Data Integration Skills
Discuss your experience with SSIS and how you've used it for ETL processes. Provide examples of how you've integrated data from various sources and the challenges you faced during these integrations.
✨Stay Updated on Cloud Technologies
Since the role emphasizes cloud-based services, make sure to mention any experience you have with AWS tools like Glue, Athena, or SageMaker. Show your enthusiasm for learning new technologies and how you've applied them in past projects.
✨Emphasize Problem-Solving Abilities
Prepare to discuss specific instances where you've encountered complex data challenges and how you approached solving them. Highlight your analytical skills and your proactive attitude towards optimizing data solutions.
