SSIS Developer

• Develop and maintain SSIS packages for data
• Optimize ETL processes to improve performance and robustness
• Participate in the design and evolution of the Warehouse
• Collaborate with business and technical teams to understand needs and propose tailored solutions
• Ensure compliance with internal standards
• Write and optimize T-SQL queries (stored procedures, views, functions)
• Deploy and monitor SSIS packages in production environment
• Perform unit tests to ensure the quality of developments
• Develop custom solutions in .NET / Java / Kafka if necessary
• Analyze and correct incidents related to ETL flows

Technologies:

• ETL
• Java
• Kafka
• SQL
• SSIS
• ASP.NET

More:

At Assura, we are evolving in a dynamic environment where everyone plays an essential role and contributes to a meaningful mission. Our team supports clients in their health decisions with energy and expertise. This role is based in our Lausanne branch, offering a 40-hour work week with a minimum of 5 weeks vacation, monthly transportation reimbursement if you use public transport, and access to social benefits and significant reductions on health insurance. We welcome candidates to join us immediately or based on mutual agreement in a permanent contract.

• You hold a degree (Bachelor or Master)
• You have a proven experience of at least 3 years with SSIS and T-SQL
• You have confirmed experience in data projects and management
• You master SSIS (development, deployment)
• You are a team player, appreciate and encourage collaboration
• You are curious and capable of innovating
• You can work autonomously with a sense of responsibility
• You are rigorous, organized, detail-oriented, and have a holistic view
• You speak fluent French and have good knowledge of English
• Basic knowledge of German is a plus