Senior SSIS Developer

Role

Accelerate your development and exposure to high performance applications and cloud infrastructure. Join Faptic Technology (remote or hybrid), a fast-growing scale-up organization with an ambition to be recognized as one of the leading technology companies in Europe.

Our global client base needs builders: engineers and developers who love technology, have deep expertise in software and cloud technologies, and importantly, have a passion for culture and customers.

• We obsess about our customers
• We build outstanding technical solutions
• We create an awesome culture
• We accelerate learning and careers

This is a great opportunity for you to work in a technology driven environment in close collaboration with skilled and passionate professionals, who utilize the best practices and cutting-edge technologies.

Key Responsibilities

Lead the design, development, and optimization of ETL processes using SQL Server Integration Services (SSIS) to support complex data integration and transformation workflows. 
Gather and analyze business and technical requirements to deliver scalable and efficient data solutions. 
Monitor, troubleshoot, and maintain data pipelines, ensuring data accuracy and performance through rigorous testing and reconciliation. 
The ideal candidate will have deep technical expertise in SSIS, strong problem-solving skills, and the ability to collaborate with stakeholders to deliver high-impact data solutions. 

Your Activities Will Include

• Design, develop, and optimize complex SSIS packages, ensuring high performance and scalability in ETL workflows. 

• Apply in-depth knowledge of how SSIS optimizes workflows, balancing the use of stored procedures and inline queries for maximum efficiency. 

• Gather and analyze detailed business and technical requirements to design robust data integration solutions. 

• Oversee and manage the monitoring, testing, and troubleshooting of data pipelines, including data reconciliation and validation processes. 

• Optimize existing ETL workflows to improve performance, reliability, and data quality. 

• Collaborate closely with cross-functional teams to align data solutions with business objectives. 

• Implement best practices for data cleansing, validation, and transformation to ensure high-quality data delivery. 

• Document technical specifications, workflows, and data models for ongoing support and future development. 

• Identify and implement opportunities for automation and performance improvement in ETL processes. 

• Stay up-to-date with industry trends and emerging technologies to continuously enhance data solutions. 

Requirements

• 5+ years of hands-on experience developing and optimizing ETL solutions using SQL Server Integration Services (SSIS). 

• Expert-level understanding of SSIS workflow optimization, with the ability to strategically use stored procedures and inline queries for performance improvements. 

• Proven experience in gathering and analyzing requirements for complex data integration projects. 

• Strong knowledge of SQL Server Agent Jobs for scheduling, monitoring, and managing automated workflows. 

• Expertise in monitoring, testing, and troubleshooting ETL pipelines, including implementing reconciliation processes to ensure data accuracy. 

• Advanced SQL skills for data querying, transformation, and performance tuning. 

• Strong understanding of ETL principles, data cleansing, and data quality best practices. 

• Excellent problem-solving abilities and attention to detail. 

• Ability to lead projects independently while collaborating effectively with team members and stakeholders. 
• University degree in Computer Science, Engineering, or a related field. 

• Proficiency in English is required. 

Benefits

• Private medical insurance 
• Training on market trends and client needs 
• Continuous personal improvement - 8h/month during work hours 
• Lunch on Friday (twice per month, we pay)
• 21 days annual leave, with one day per year extra up to 25 days 
• 3 health days that can be taken without medical proof
• 1 day for your Birthday off 
• 0.5 days Christmas Shopping off 
• Competitive package
• Quarterly fun budget for team events