Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and develop ETL processes using SQL Server Integration Services (SSIS) for data management.
- Company: Join a dynamic team focused on innovative data solutions and business intelligence.
- Benefits: Enjoy flexible working options, professional development opportunities, and a collaborative culture.
- Why this job: Be part of a tech-savvy environment where your skills can make a real impact on data-driven decisions.
- Qualifications: Experience with SQL Server, SSIS, and data formats like XML and JSON is essential.
- Other info: Opportunity to work with Azure integration services is a bonus!
The predicted salary is between 36000 - 60000 £ per year.
Responsibilities:
- Design and develop SQL Server Integration Services (SSIS) packages to extract, transform, and load (ETL) data from various sources.
- Develop and maintain complex ETL processes to ensure data integrity and accuracy.
- Develop T-SQL functions and stored procedures to support complex business needs.
- Manage database artifacts and provide subject matter expertise on best practices for creation, deployment, and ongoing management of databases in a reporting/BI environment.
- Monitor daily SSIS jobs and data loads, proactively resolving issues to ensure maximum uptime and availability of the database for reporting.
- Communicate clearly and confidently to Business Analysts, Project Managers, Architects and Infrastructure Engineers about the SSIS platform and the technical configuration of SSIS Interfaces, Packages and Jobs.
- Deputise for the Integrations Team line manager.
Qualifications:
- Experience designing, developing, supporting and implementing integrations using Microsoft solutions (SQL Server and SSIS).
- Demonstrated experience with SQL, proficiency in creating and maintaining complex MS SQL queries.
- Knowledge of data formats and standards such as XML, JSON and CSV.
- Ability to work independently and as part of a team.
- Ability to use Source Control using GIT and Azure DevOps.
- (Bonus) Knowledge and understanding of Azure integration Services (Logic Apps, Service Bus, API Management, Event Grid, Azure Functions, Azure Data Factory).
This role requires a blend of technical expertise, creativity, and problem-solving skills to effectively manage and utilize data for business intelligence and reporting purposes.
Integration Engineer (Data) employer: Investigo
Contact Detail:
Investigo Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Integration Engineer (Data)
✨Tip Number 1
Familiarise yourself with the latest features and updates in SQL Server Integration Services (SSIS). Being well-versed in the current capabilities will not only boost your confidence during interviews but also demonstrate your commitment to staying updated in the field.
✨Tip Number 2
Network with professionals in the data integration space, especially those who work with Microsoft solutions. Attend relevant meetups or webinars, and engage in discussions on platforms like LinkedIn to build connections that could lead to job referrals.
✨Tip Number 3
Prepare to discuss real-world scenarios where you've successfully implemented ETL processes or resolved data integrity issues. Having specific examples ready will showcase your problem-solving skills and practical experience to potential employers.
✨Tip Number 4
Brush up on your communication skills, particularly how to explain technical concepts to non-technical stakeholders. This is crucial for the role, as you'll need to liaise with various teams, so practice articulating complex ideas in a simple manner.
We think you need these skills to ace Integration Engineer (Data)
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with SQL Server Integration Services (SSIS) and any relevant projects you've worked on. Emphasise your skills in ETL processes, T-SQL functions, and database management to align with the job requirements.
Craft a Strong Cover Letter: In your cover letter, express your enthusiasm for the role and how your background makes you a perfect fit. Mention specific experiences where you've successfully designed and developed SSIS packages or managed complex ETL processes.
Showcase Technical Skills: Clearly outline your technical skills related to Microsoft solutions, including your proficiency in SQL and any experience with Azure integration services. Use examples to demonstrate your problem-solving abilities and creativity in managing data.
Prepare for Communication: Since the role requires clear communication with various stakeholders, consider including examples of past experiences where you effectively communicated technical information to non-technical team members. This will show your ability to bridge the gap between technical and business needs.
How to prepare for a job interview at Investigo
✨Showcase Your SSIS Expertise
Be prepared to discuss your experience with SQL Server Integration Services in detail. Highlight specific projects where you designed and developed SSIS packages, focusing on the challenges you faced and how you overcame them.
✨Demonstrate T-SQL Proficiency
Expect questions about T-SQL functions and stored procedures. Brush up on your knowledge of complex queries and be ready to explain how you've used them to meet business needs in previous roles.
✨Communicate Clearly
Since the role involves liaising with various stakeholders, practice articulating technical concepts in a clear and concise manner. Prepare examples of how you've effectively communicated with Business Analysts or Project Managers in the past.
✨Familiarise Yourself with Azure Services
While not mandatory, having a basic understanding of Azure integration services can set you apart. Research Logic Apps, Service Bus, and other Azure tools, and be ready to discuss how they could enhance your work as an Integrations Engineer.
