SQL / SSIS Engineer

SQL / SSIS Engineer

Leatherhead Full-Time 36000 - 60000 £ / year (est.) No home office possible
L

At a Glance

  • Tasks: Design and maintain ETL solutions using SQL Server and SSIS in a collaborative environment.
  • Company: Join a leading construction organisation known for innovation and teamwork.
  • Benefits: Enjoy flexible working options and opportunities for professional growth.
  • Why this job: Perfect for problem-solvers who want to make an impact in data integration.
  • Qualifications: Strong SQL Server and SSIS experience, with T-SQL proficiency required.
  • Other info: Opportunity to act as deputy to the Integrations Team lead.

The predicted salary is between 36000 - 60000 £ per year.

A leading Construction organisation is seeking a skilled SQL Server / SSIS Engineer to design, develop, and maintain robust ETL solutions within a dynamic data and reporting environment. This role is ideal for someone who thrives on problem-solving, ensuring data quality, and collaborating across teams to deliver seamless integrations. Key Responsibilities: Develop and maintain SSIS packages and T-SQL procedures to support ETL processes. Ensure data accuracy and performance across systems. Monitor and troubleshoot daily data loads and SSIS jobs. Collaborate with analysts, architects, and engineers to align integration efforts. Act as deputy to the Integrations Team lead when required. Provide expertise on best practices for SQL Server databases in BI/reporting contexts. What Youll Bring: Strong experience with SQL Server and SSIS development. Proficient in T-SQL and handling complex queries. Familiar with data formats such as XML, JSON, and CSV. Experience with source control and version management. Confident communicator with the ability to explain technical details to non-technical stakeholders. Bonus: Familiarity with Azure Integration Services (e.g., Logic Apps, Da…

SQL / SSIS Engineer employer: Lynx Recruitment

Join a leading Construction organisation that values innovation and collaboration, offering a vibrant work culture where your contributions directly impact project success. With a strong focus on employee development, you will have access to continuous learning opportunities and the chance to work alongside industry experts in a supportive environment. Located in a dynamic sector, this role not only promises meaningful work but also the chance to grow your career in a company that prioritises data integrity and teamwork.
L

Contact Detail:

Lynx Recruitment Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land SQL / SSIS Engineer

✨Tip Number 1

Brush up on your SQL Server and SSIS skills. Make sure you can confidently discuss your experience with ETL processes and how you've tackled data quality issues in the past. Being able to share specific examples will show your expertise.

✨Tip Number 2

Familiarise yourself with common data formats like XML, JSON, and CSV. Understanding these formats will help you demonstrate your ability to handle diverse data sources effectively during discussions.

✨Tip Number 3

Prepare to discuss your experience with source control and version management. Highlighting your familiarity with these practices will show that you understand the importance of maintaining code integrity in collaborative environments.

✨Tip Number 4

Practice explaining technical concepts in simple terms. Since you'll be working with non-technical stakeholders, being able to communicate complex ideas clearly will set you apart as a strong candidate.

We think you need these skills to ace SQL / SSIS Engineer

SQL Server Development
SSIS Package Development
T-SQL Proficiency
ETL Process Design
Data Quality Assurance
Performance Tuning
Troubleshooting Skills
Collaboration and Teamwork
Source Control Management
Version Control
Data Format Handling (XML, JSON, CSV)
Communication Skills
Technical Documentation
Azure Integration Services Familiarity

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your experience with SQL Server and SSIS development. Include specific examples of ETL solutions you've designed and any relevant projects that demonstrate your problem-solving skills.

Craft a Compelling Cover Letter: In your cover letter, emphasise your ability to ensure data accuracy and performance. Mention your experience collaborating with teams and how you can contribute to the organisation's goals.

Showcase Technical Skills: Clearly outline your proficiency in T-SQL and handling complex queries. If you have experience with data formats like XML, JSON, and CSV, make sure to include that as well.

Prepare for Interviews: Be ready to discuss your previous work with SSIS packages and T-SQL procedures. Prepare to explain technical concepts in a way that non-technical stakeholders can understand, as this is crucial for the role.

How to prepare for a job interview at Lynx Recruitment

✨Showcase Your Technical Skills

Be prepared to discuss your experience with SQL Server and SSIS in detail. Bring examples of complex T-SQL queries you've written or SSIS packages you've developed, as this will demonstrate your hands-on expertise.

✨Understand the ETL Process

Since the role focuses on ETL solutions, make sure you can explain the ETL process clearly. Discuss how you ensure data accuracy and performance, and be ready to share any challenges you've faced and how you overcame them.

✨Communicate Effectively

As a confident communicator, practice explaining technical concepts in simple terms. This is crucial when collaborating with non-technical stakeholders, so think of examples where you've successfully done this in the past.

✨Familiarise Yourself with Data Formats

Brush up on your knowledge of data formats like XML, JSON, and CSV. Be ready to discuss how you've worked with these formats in previous roles, as this will show your versatility and understanding of data integration.

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

L
Similar positions in other companies
UK’s top job board for Gen Z
discover-jobs-cta
Discover now
>