Lead ETL (SSIS) Developer

Synechron - Jacksonville, FL

Full-time - Mid Level

Jacksonville, FL

10,001+ employees

Professional, Scientific, and Technical Services

About the position

Synechron is seeking a skilled SSIS Developer with strong .NET experience to join our data integration team. The role involves designing, developing, and maintaining ETL processes using SQL Server Integration Services (SSIS) while leveraging .NET technologies to enhance data management solutions. The ideal candidate will collaborate with business analysts and stakeholders to understand data integration needs and ensure data quality and integrity throughout the ETL process.

Responsibilities

• Design, develop, and implement ETL processes using SSIS to extract, transform, and load data from various sources into data warehouses or databases.
• Collaborate with business analysts and stakeholders to gather requirements and understand data integration needs.
• Create and maintain documentation related to SSIS packages, ETL processes, and data flow diagrams.
• Optimize existing SSIS packages for performance, reliability, and maintainability.
• Use .NET technologies (C#, ASP.NET) to develop custom components or solutions to support data integration efforts.
• Troubleshoot and resolve issues related to ETL processes and SSIS packages.
• Ensure data quality and integrity throughout the ETL process.
• Monitor and maintain SSIS jobs and troubleshoot failures.
• Stay updated with the latest industry trends and technologies related to data integration and ETL processes.

Requirements

• Proven experience as an SSIS Developer with a strong understanding of ETL concepts.
• Proficient in SQL Server (2012 or later) and T-SQL.
• Strong programming skills in .NET (C#, ASP.NET).
• Experience with data warehousing concepts and best practices.
• Familiarity with data modeling and database design.
• Excellent problem-solving skills and attention to detail.
• Strong communication skills and the ability to work collaboratively in a team environment.

Benefits

• A highly competitive compensation and benefits package
• A multinational organization with 55 offices in 20 countries and the possibility to work abroad
• Laptop/equipment
• 12 days of paid annual leave (plus sick leave and national holidays)
• Maternity & Paternity leave plans
• A comprehensive insurance plan including: medical, dental, vision, and long-/short-term disability (plans vary by region)
• Retirement savings plans
• A higher education certification policy
• Extensive training opportunities, focused on skills, substantive knowledge, and personal development
• On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses
• Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups
• Cutting edge projects at the world's leading tier-one banks, financial institutions and insurance firms
• A flat and approachable organization
• A truly diverse, fun-loving and global work culture
• Saving funds plan for Mexico