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