Principal Data Engineer (DT)

Key Skills

AWS, Azure, Data Architecture, Database, Databricks, Design, ETL frameworks, ETL/ELT technologies, Git, Google Cloud Platform (GCP), JIRA, Mentoring, Microsoft-Excel, Oracle, Presentation skills, Python Programming, SQL Server

Job Description

Technical role requiring strong technical background, hands-on experience in Informatica IICS, Python, ADF and other Azure technologies along with data analysis skills and leadership abilities. Reporting to the Product Owner of Commercial Data, the candidate will work on multiple projects for delivery of data solutions, including new development, maintenance and enhancements. The candidate will also assist with the daily operations, management and oversight of team’s deliverables.

Primary Responsibilities:

• The candidate will be responsible for data design, management and development as part of building out new and vital platforms and products for the team

• Strong development & programming experience in Informatica (IICS), Python, ADF, Azure Synapse, Cosmos and Databricks

• Solid understanding of databases, real-time integration patterns and ETL/ELT best practices.

• Responsible for ensuring enterprise data policies, best practices, standards and processes are followed.

• Accountable for designing and implementing comprehensive solutions that meet business requirements and incrementally move the data ecosystem to the future state.

• Write up and maintain technical specifications, design documents and process flows.

• Mentor a team of onshore and offshore development resources to analyze, design, construct and test software development projects focused on analytics and data integration

• Elaborate user stories for technical team and ensure that the team understands the deliverables.

• Effectively communicate, coordinate & collaborate with business, IT architecture and technical teams across multi-functional areas to complete deliverables.

• Provide direction to the Agile development team and stakeholders throughout the project.

• Assist in Data Architecture design, tool selection and data flows analysis.

• Work with large amounts of data, interpret data, analyze results, perform gap analysis and provide ongoing reports.

• Handle ad-hoc analysis & report generation requests from the business.

• Respond to data related inquiries to support business and technical teams.

Qualifications - External

Technical Skills / Experience: 

• 10+years of proven working experience in ETL methodologies, Data integration and data migration. Informatica IICS hands-on development skills a must.

• Solid understanding of P&C Insurance data

• Technical expertise regarding data architecture, models and database design development

• Fluent in various database technologies like SQL server, Oracle, Azure Synapse and Cosmos

• Strong knowledge of and experience with T-SQL, XML’s, Python, ETL frameworks and Databricks

• Working knowledge/familiarity with Git version control.

• Strong Knowledge of analyzing datasets using Excel

• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

• Proficient in learning new technologies with the ability to quickly understand capabilities and work with others to guide these into development

• Good communication and presentation skills

• Solid problem solving, decision making and analytical skills

• Knowledge & working experience with Duck creek is an added plus

• Knowledge & working experience with Insurity Policy Decisions and/or IEV is an added plus

• Experience with JIRA

Other Skills / Experience:

• Experience being part of high-performance agile teams in a fast-paced environment

• Must understand the system scope and project objectives to achieve project needs through matrix management and collaboration with other enterprise teams

• Proven ability to produce results in the analysis, design, testing and deployment of applications

• Strong team emphasis and relationship building skills; partners well with business and other IT areas

• Strong coaching / mentoring skills

• Applies technical knowledge to determine solutions and solve complex problems

• Ability to be proactive, self-motivated, detail-oriented, creative, inquisitive and persistent

• Excellent communication and negotiation skills.

• Ability to organize, plan and implement work assignments, juggle competing demands and work under pressure of frequent and tight deadlines

EEO Statement

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 retaliationagainst any individual who reports discrimination or harassment.