Sr. Data Engineer / Production Support Lead

Company: Chubb
Location: Philadelphia
Posted on: July 1, 2025

Job Description:

By joining Chubb as a Sr. Data Engineer / Data Warehouse Production Support Lead for our North America enterprise data warehouse, you'll be responsible for ensuring the data warehouse operates smoothly and reliably, including incident management, performance optimization, and collaborating with other teams to maintain data quality and system stability. Our data warehouse platform is a strategic application within the business, feeding into multiple systems and applications both up and downstream with data that directly supports business decisions being made each and every day. With us, you’ll leverage your technical expertise to tactically and strategically handle data discrepancies, and partner with applications teams, IT teams across the business, our stakeholders, and our Data Architect to drive solutions that directly impacts how data is used throughout the business. You’ll have opportunities to build upon your technical skills and insurance knowledge as we continue the evolution of our data warehouse and related infrastructure. Through it all, we’ll also look to you to share your ideas and manage data related projects end to end that influence how we incorporate, validate, and distribute data enterprise-wide. In this role, you will: Lead the process of identifying, prioritizing, and resolving production issues, ensuring minimal disruption to business operations. Investigate and identify the root causes of incidents to prevent recurrence Maintain clear and timely communication with stakeholders, including business users, IT teams, and management, throughout the incident lifecycle. Continuously monitor the data warehouse's performance, identifying bottlenecks and areas for improvement Implement performance tuning techniques to optimize query execution times, ETL processes, and overall system performance Collaborate with other teams to ensure the data warehouse has sufficient resources to meet current and future demands Implement and maintain data validation processes to ensure the accuracy and integrity of data in the data warehouse Address data quality issues, including data cleansing and transformation, to ensure data accuracy and consistency Participate in the planning and execution of data warehouse releases, ensuring minimal disruption to production operations Test new releases and changes to the data warehouse environment to ensure stability and functionality Build and maintain strong relationships with business users, IT teams, and other stakeholders Maintain comprehensive documentation of the data warehouse architecture, processes, and procedures Possess a strong understanding of data warehouse technologies, ETL processes, and database management systems Demonstrate strong analytical and problem-solving skills to effectively address technical issues and challenges Lead and mentor team members, providing guidance and support as needed Bachelor’s degree required in Computer Science, Computer Information Systems, Information Systems, Information Technology or Computer Engineering or equivalent work experience 8 years of Strong understanding of ETL development concepts and tools such as ETL development solutions (Informatica/IICS) 5 years of Experience with Data Warehousing and Cloud Technologies like Azure (Synapse, Data bricks, Snowflake ). 3 years of experience in scheduling jobs using Autosys (or comparable distributed scheduler) 3 years of experience writing Unix/Linux or Windows Scripts in tools such as PERL, Shell script, Python, etc. 3 years of experience in creating complex technical specifications from business requirements/specifications Demonstrated critical thinking skills and the ability to identify and resolve data quality issues, performance bottlenecks, and other ETL-related problems Excellent communication and interpersonal skills Experience leading a team and providing technical guidance to junior data engineers The pay range for the role is $140,000 to $165,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. 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.

Keywords: Chubb, North Bergen , Sr. Data Engineer / Production Support Lead, IT / Software / Systems , Philadelphia, New Jersey