Senior SSIS Engineer

Description

We are seeking a skilled Senior SSIS Engineer to join our team for an enterprise data warehouse project. In this role, you will be responsible for developing and supporting ETL code in SSIS, ensuring robust and maintainable solutions that meet project requirements.

If you have a proven track record of working with SQL Server , , or , and possess a strong understanding of best practices for data integration, we encourage you to apply.

Join our dynamic team and contribute to exciting projects that shape the future of data engineering.

#LI-TG3

Responsibilities

• Develop queries and stored procedures using T-SQL
• Understand and analyze requirements to develop, test, configure and deploy SSIS packages
• Use the SQL Server , or experience to implement robust, maintainable solutions that meet requirements
• Evaluate large and complex data sets
• Troubleshoot SSIS packages to address critical production issues
• Create tables, assign permissions, import data and perform app configurations
• Manage source code versioning and deployment
• Write and maintain technical documentation

Requirements

• 5+ years of SSIS / SSRS experience
• Proven 5+ years of expertise writing T-SQLs, Stored Procedure, and Complex Queries using the Microsoft SQL Server
• 8+ years of SSIS proficiency in developing ETL applications
• Data warehouse development competency using SSIS/SQL best practices including the development of reconciliation and validation frameworks
• Ability to utilize of best practice SSIS design patterns
• Knowledge of best practices for loading a data into normalized and/or Star schemas
• Skills in interfacing programmatically with a variety of enterprise systems
• Familiarity with source code management systems (TFS)
• Self-sufficiency in completing high-quality work, without significant guidance
• B2+ English level, both verbal and written

Nice to have

• Knowledge within the insurance business space

We offer

• We connect like-minded people : Delivering innovative solutions to industry leaders, making a global impact Enjoyable working environment, whether it is the vibrant office or the comfort of your own home Opportunity to work abroad for up to two months per year Relocation opportunities within our offices in 50+ countries Corporate and social events
• We invest in your growth : Leadership development, career advising, soft skills and well-being programs Certifications, including GCP, Azure and AWS Unlimited access to LinkedIn Learning, Get Abstract, O'Reilly, Cloud Guru Free English classes with certified teachers
• We cover it all : Participation in the Employee Stock Purchase Plan Monetary bonuses for engaging in the referral program Comprehensive medical & family care package Five trust days per year (sick leave without a medical certificate) Benefits package (sports activities, a variety of stores and services)