At a Glance
- Tasks: Design and maintain data pipelines using SQL Server and T-SQL for high-quality datasets.
- Company: Join a forward-thinking company focused on data solutions and innovation.
- Benefits: Enjoy 24 days holiday, gym discounts, and a quarterly bonus scheme.
- Other info: Flexible working hours with a 1:30pm finish on Fridays.
- Why this job: Make an impact by transforming data into valuable insights for the business.
- Qualifications: Experience in data engineering and strong T-SQL skills required.
The predicted salary is between 40000 - 50000 £ per year.
We are seeking a Data Engineer with strong hands-on experience in Microsoft SQL Server, T-SQL, and data integration to design, build, and maintain reliable data pipelines and data solutions. The role will focus on ingesting data from internal systems and third-party platforms, including REST APIs, transforming and validating data, and delivering high-quality datasets for reporting, analytics, and operational use.
Working hours are: Monday to Thursday 08:00-16:30, and Friday 08:00 - 13:30.
Key Roles and Responsibilities- Design, develop, and maintain SQL Server databases, tables, views, stored procedures, and ETL/ELT pipelines.
- Write and optimize complex T-SQL queries for data extraction, transformation, reconciliation, and loading.
- Build and support integrations with RESTful APIs, including data ingestion, pagination handling, authentication, and error handling.
- Develop and maintain data interfaces between internal applications, external partners, and third-party systems.
- Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related discipline, or equivalent practical experience.
- Proven experience in a Data Engineer, SQL Developer, Integration Engineer, or similar role.
- Advanced knowledge of T-SQL, including joins, CTEs, window functions, stored procedures, functions, and query optimization.
- Good understanding of JSON, XML, CSV, and other interchange formats.
- Strong understanding of performance tuning, indexing, execution plans, and database best practices.
- Ability to document solutions clearly and communicate with technical and non-technical stakeholders.
- Employee Assistance Program / Counselling
- On-site parking
- Training and development
- Company workwear provided
- Gym discount
- Free tea / coffee
- 1:30pm finish on Fridays
- Holidays 24 days + 8 bank holidays (FTE, pro-rated)
- Quarterly bonus scheme
- Specsavers vouchers
Data Engineer in Lincolnshire employer: Autocraft Solutions Group
Contact Detail:
Autocraft Solutions Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer in Lincolnshire
✨Tip Number 1
Network like a pro! Reach out to your connections in the data engineering field and let them know you're on the hunt for a new role. 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 projects, especially those involving SQL Server and T-SQL. 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 thought process when designing data pipelines or optimising queries, as this will demonstrate your expertise and problem-solving skills.
✨Tip Number 4
Don't forget to apply through our website! We love seeing applications come directly from candidates who are genuinely interested in joining our team. Plus, it gives you a better chance to stand out in the hiring process.
We think you need these skills to ace Data Engineer in Lincolnshire
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Microsoft SQL Server and T-SQL. We want to see how you've designed and maintained data pipelines, so don’t hold back on those details!
Showcase Your Projects: Include specific examples of projects where you’ve built integrations with RESTful APIs or worked on ETL/ELT processes. We love seeing real-world applications of your skills!
Keep It Clear and Concise: When writing your cover letter, be straightforward about why you’re a great fit for the Data Engineer role. We appreciate clarity and directness, so avoid fluff and get to the point.
Apply Through Our Website: Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role.
How to prepare for a job interview at Autocraft Solutions Group
✨Know Your SQL Inside Out
Make sure you brush up on your T-SQL skills before the interview. Be prepared to discuss complex queries, stored procedures, and how you've optimised performance in past projects. Practising some real-world scenarios can really help you articulate your experience.
✨Showcase Your Data Integration Skills
Since the role involves working with REST APIs and data ingestion, be ready to talk about your experience with these technologies. Have examples ready that demonstrate how you've handled authentication, pagination, and error management in previous roles.
✨Communicate Clearly
You’ll need to explain technical concepts to both technical and non-technical stakeholders. Practice explaining your past projects in simple terms, focusing on the impact of your work rather than just the technical details. This will show your ability to bridge the gap between teams.
✨Prepare Questions for Them
Interviews are a two-way street! Prepare thoughtful questions about their data architecture, team dynamics, or future projects. This not only shows your interest in the role but also helps you gauge if the company is the right fit for you.