Technical Data Analyst at Chubb in Philadelphia, Pennsylvania

Job Description:

Chubb is a global leader in the insurance industry and provides an extensive suite of products to a wide range of clients. Delivering superior coverage, craftsmanship, and customer experience has always been at our core, and will continue to be as we modernize what insurance does and how we deliver it, all while protecting what our customers value most. Major initiatives are underway at Chubb to build on our strengths and expand Chubb’s reach in the digital insurance space. This means data-enriched processes and real-time insights embedded across our value chain, design thinking and an “engineers of everything” mentality, and a world-class customer experience that sets us apart. We are also reimagining our ways of working to be more adaptable and flexible through agile principles and investing in skillset development and tools for a digital age.

What We Bring

• Dynamic Hybrid – flexible work arrangements


• Competitive offer packages which include a competitive base salary bonus and equity (for applicable roles)


• Employee stock purchase plan (15% discount)


• Comprehensive benefits that start day 1


• Retirement savings plan (Chubb contributes 9% on your behalf)


• Investment in education program- Tuition reimbursement program


• Charitable gift matching programs


• Mentorship programs to help you grow your career

What You Will Do:

By joining Chubb as a Technical Data Analyst, you will analyze and certify data, troubleshoot data issues, promote data quality, and assist in the delivery of key projects in support of our North America enterprise data warehousing initiative.  Our data warehouse platform is a strategic application within the business, feeding into innumerable be 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 knowledge of SQL and database tables to analyze data, identify gaps or 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.

Day to day, you will:

• Support assigned work efforts through all phases of the development, testing, and implementation life cycle, reviewing all requirements, creating test scenarios, developing test plans, analyzing results and testing/validating data


• Reconcile multiple data sources and identify the root cause of discrepancies in expected output; distinguish between multiple root causes and/or multiple trends in a given data set and articulate results to various stakeholders, management, and technical resources


• Analyze and test relational databases and investigate any data load failures or data retrieval issues


• Monitor data warehousing systems based on assigned tasks to ensure reliability and accuracy of information loaded into the databases 


• Aid in defining and documenting requirements, communicating changes in scope or requires, to all stakeholders; initiate change management processes as required


• Generate reports, dashboards, and ad hoc extracts for business and/or leadership


• Ensure data integrity by implementing quality assurance practices, gathering, and entering missing data, and resolving any anomalies

• 3+ years of experience in a Data Analysis, Business Analysis, Data Quality Assurance (or similar) role as part of a data warehouse team and supporting data-driven projects


• Experience working with DBMS platforms, including a demonstrated understanding of table structures, hierarchies, joins, etc.


• Advanced knowledge of SQL, with the ability to write and troubleshoot medium to advanced SQL queries


• Knowledge of data warehousing methodologies and tools including their connection to systems both up and down stream


• Bachelor’s degree in Mathematics, Engineering, Computer Science, or a related discipline preferred


• Prior experience within the insurance industry is a plus