Job Description
By joining Chubb as a Senior Data Analyst, you will analyze and certify data, troubleshoot data issues, promote data quality, work directly with the business and developers to document requirements and technical specifications and lead the delivery of key projects in support of North America Statutory Reporting from the enterprise data warehouse. 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 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 will lead reporting initiatives, delivering solutions from inception to reporting submission while working within budget and timelines. 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 all phases of the development, testing, and implementation life cycle, defining, documenting, and reviewing all requirements, creating test scenarios, developing test plans, analyzing results and testing/validating data
• Work with business partners, project management, architecture, development, and leadership to deliver reporting solutions on-time, within budget and with data accuracy.
• Document requirements, technical specifications, and implementation documentation on all reporting solutions.
• 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
• 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

Qualifications

• 7 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 or related to regulatory reporting is preferred
• Previous experience with Azure Synapse, Informatica Intelligent Cloud Services (IICS), and/or reporting tools, such as Qlik, Spotfire is a plus

About Us
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.