Lead design, development, and maintenance of SQL databases and ETL jobs (SSIS); write and optimize complex queries; ensure data integrity and performance; manage delivery, mentor team members, and collaborate with stakeholders to support data-driven decisions.
Chubb Benefits is seeking a Senior SQL & ETL Lead Developer to join our fast-paced, high energy, growing company. We are proud of our tradition of success in the insurance industry of over 100 years. Come join our team of hard-working, talented professionals!
Job Description:
We are seeking an experienced SQL and ETL Developer with over 7 years of experience to join our dynamic team. The ideal candidate will be responsible for designing, developing, and maintaining SQL databases and Extract Transform Load (ETL) jobs, ensuring data integrity, and optimizing performance. You will work closely with data analysts, data scientists, and other stakeholders to support data-driven decision-making within the organization.
Key Responsibilities:
- Work with cross-functional teams to understand business requirements and translate them into technical specifications.
- Plan and manage project delivery scope, sprint planning, task assignment to developers and tracking completion.
- Create and maintain documentation for database designs, processes, and procedures, as defined by CHUBB engineering and architecture.
- Design, develop, and maintain SQL databases and data models.
- Write complex SQL queries for data extraction, transformation, and loading (ETL).
- Optimize SQL queries and database performance.
- Ensure data integrity and security across all databases.
- Troubleshoot and resolve database issues and performance bottlenecks.
- Ability to work independently and Support Team members in a team-oriented, collaborative environment
- Stay updated with the latest industry trends and technologies related to SQL and database management.
Must-Have Skills:
- 7+ years of experience in SQL development and database management.
- Excellent communication and collaboration skills.
- Proficiency in writing complex SQL queries, stored procedures, and functions.
- Strong understanding of database design principles and data modeling.
- Experience with performance tuning and optimization of SQL queries.
- Experience with Microsoft SQL Server 16 and above versions, and Azure SQL Database.
- Experience with development of ETL jobs in SSIS
- Knowledge of ETL processes and tools.
- Experience with data warehousing concepts and practices.
- Strong analytical and problem-solving skills.
Nice-to-Have Skills:
- Experience with cloud-based database solutions (e.g., Azure SQL Database, Azure Synapse, Snowflake).
- Experience with Informatica Intelligent Cloud Services (IICS)
- Experience with data visualization tools (e.g., Power BI).
- Knowledge of programming languages such as Python, or Java.
- Knowledge of .Net programming.
- Understanding of data governance and compliance standards.
- Familiarity with Agile methodologies and project management tools.
- Familiarity with NoSQL databases (e.g., MongoDB, Cassandra).
Education:
- Bachelor’s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
- Office Location: 8750 W. Bryn Mawr Avenue Chicago, Illinois (Near Rosemont)
- In-Office Expectation: 4 days in office, 1 day remote
The pay range for the role is $122,000 to $178,000. The specific offer will depend on an applicant’s skills and other factors. This role may also be eligible to participate in a discretionary annual incentive program. Chubb offers a comprehensive benefits package, more details on which can be found on our careers website. The disclosed pay range estimate may be adjusted for the applicable geographic differential for the location in which the position is filled."
About Us OUR BENEFITS
As a Chubb corporate employee, you have access to one of the most comprehensive benefit plans in the business, designed to meet your needs and help you reach your financial goals. More details can be found here. Chubb is committed to supporting its employees with a comprehensive compensation package that is appropriate in the market where they work. Below are several of the many benefits we offer our employees:
- Health insurance
- Dental insurance
- Tuition reimbursement
- A company-match 401(k) plan
- Disability insurance
- Life insurance
- Employee referral bonuses
ABOUT CHUBB BENEFITS
Combined Insurance Company of America (Chubb Benefits) is a leading provider of supplemental accident, health, disability, and life insurance products in the U.S. and Canada. Headquartered in Chicago with a tradition of more than 100 years of success, we are committed to making the world of supplemental insurance easy to understand. The company has an A+ rating by the Better Business Bureau and an A + (Superior) financial strength rating by AM Best.
ABOUT CHUBB
Chubb is a world leader in insurance. 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.
At Chubb, we are committed to equal employment opportunity and compliance with all laws and regulations pertaining to it. Our policy is to provide employment, training, compensation, promotion, and other conditions or opportunities of employment, without regard to race, color, religious creed, sex, gender, gender identity, gender expression, sexual orientation, marital status, national origin, ancestry, mental and physical disability, medical condition, genetic information, military and veteran status, age, and pregnancy or any other characteristic protected by law. Performance and qualifications are the only basis upon which we hire, assign, promote, compensate, develop and retain employees. Chubb prohibits all unlawful discrimination, harassment and retaliation against any individual who reports discrimination or harassment.
Connect with us on Twitter, Facebook, LinkedIn, and Instagram
#chubbbenefits
Chubb Chicago, Illinois, USA Office
Chicago, United States, 0
Similar Jobs
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Administer, architect, optimize, secure, and automate PostgreSQL, MySQL, and Snowflake databases in Azure. The role develops resilient database solutions for healthcare applications, manages performance, access controls, encryption, backups, and disaster recovery, and creates technical documentation. It collaborates across Scrum teams, presents solutions to stakeholders, evaluates emerging technologies, uses approved AI tools, solves complex database challenges, and mentors junior engineers.
Top Skills:
AgileAi ToolsAzure Database For Postgresql Flexible ServerGitJavaLinuxAzureMySQLPostgresPythonScrumSnowflakeSQL
Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Investigates and evaluates moderately complex to complex workers compensation and commercial claims. Determines coverage, liability, compensability, reserves, and damages; negotiates settlements and coordinates litigation. The role also engages experts, conducts mediations and reviews, mentors team members, supports escalated issues, participates in quality reviews, and may assist with team workload assignments and technical direction.
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Partner with skilled nursing and long-term care clients to assess and improve revenue cycle operations—admissions, payer authorization, MDS/PDPM reimbursement, billing, collections, and denials. Lead client engagements, recommend process and system improvements using EHR and billing data, manage project execution, deliver training, and support change management to optimize reimbursement and financial performance.
Top Skills:
Billing SystemsElectronic Health Record (Ehr)Revenue Cycle Management Systems
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
