remoteonsite
Senior Software Engineer - SQL & SSIS - Chubb Insurance
Software Engineer
Lead the design, development, and maintenance of enterprise data integration solutions using SQL and SSIS, ensuring high performance, reliability, and compliance with data governance standards.
About the role
Key Responsibilities
- Architect, develop, and optimize SSIS packages for large‑scale data extraction, transformation, and loading across multiple source systems.
- Write and maintain complex T‑SQL scripts, stored procedures, and database objects to support data integration workflows.
- Collaborate with data architects and business analysts to translate business requirements into robust ETL solutions.
- Implement performance tuning, error handling, and logging mechanisms to ensure package reliability and maintainability.
- Conduct code reviews, unit testing, and documentation of data integration processes.
Requirements
- 5+ years of experience in SQL Server and SSIS development.
- Strong proficiency in T‑SQL, database design, and performance optimization.
- Hands‑on experience with data integration patterns, data quality, and governance.
- Excellent problem‑solving skills and ability to work independently in a fast‑paced environment.
- Effective communication skills for collaborating with cross‑functional teams.