Chubb is the world's largest publicly traded property and casualty insurer. With operations in 54 countries, Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance and life insurance to a diverse group of clients. The company is distinguished by its extensive product and service offerings, broad distribution capabilities, exceptional financial strength, underwriting excellence, superior claims handling expertise and local operations globally.
**KEY OBJECTIVE**:
We are looking for a Senior SQL Engineer to join our fast-paced Carrier Reporting (CR) team. Under the guidance of the CR Tech Team Lead, this role will be responsible for designing, coding, testing, and implementing fixes and enhancements, in support of complex outbound reporting. The Senior SQL Engineer will collaborate with the business team and other developers to produce solutions that meet the requirements of our carrier partners and regulatory bodies, and in general support high quality reporting for the company.
**DUTIES & RESPONSIBILITIES**:
- Complete research and problem-solving tasks with mínimal supervision.
- Develop, modify, and debug complex SSIS packages with control and data flows.
- Prepare documentations and specifications which including file layouts and data mapping.
- Work in a fast-paced environment with competing priorities to meet goals and deadlines.
- Interface and collaborate with other tech team members, business analysts and project managers to clarify requirements.
- Combine IT skills with business knowledge to develop, enhance, debug, and maintain complex stored procedures.
- Design and develop tables with appropriate constraints and indexes.
- Create/update stored procedures, functions, views, triggers and other SQL Server objects.
- Test own work and contribute to the development of test plans.
- Maintains awareness of information security requirements and scalability issues during design and development.
- Participate in technical design; develop from specifications under limited guidance.
**REQUIRED SKILLS AND EXPERIENCE**
- Fluent in English
- 7+ years of experience in SQL
- T-SQL programming - Stored procedures, views, functions, triggers
- ETL design and development
- Development of high-quality database solutions
- Skilled at optimizing large, complicated SQL statements
- Capable of troubleshooting common database issues
- Familiar with tools that can aid with profiling server resource usage to optimize
- Review and interpret ongoing business needs
- Analyze existing SQL queries for performance improvements Strong organizational, detail-oriented skills
**DESIRED SKILLS AND EXPERIENCE**:
- 7 to 10 years of experience as a SQL Developer or similar role
- Excellent understanding of SQL programming
- 5 to 7 years of experience with SQL Server and SSQL Server data tools (SSIS, SSRS) or similar SQL and ETL tools
- Sense of ownership and pride in performance and impact on company's success
- Critical thinker and problem-solving skills
- Team player
- Good time-management skills
- Great interpersonal and communication skills
- Healthcare or insurance industry related experience is a plus