Job Description

Lead Data Engineer
Data is at the core of our business. The Lead Data Engineer serves as a key resource in building and executing on Chubb's information strategy. The ideal candidate for this role is a self-starter who will take ownership of your projects and deliver high-quality data-driven solutions. The primary responsibilities include using services and tools to ingest, egress, and transform data from multiple sources. They manage and secure the flow of structured and unstructured data from multiple sources and should be comfortable working with data platforms that can include relational databases, nonrelation databases, data streams, and file stores. Data Engineering Leads also ensure that data services securely and seamlessly integrate with other data platform technologies or application services such as Microsoft Azure or on-premise solutions.

The Lead Data Engineer collaborates with business stakeholders to identify and meet data requirements. They design and implement solutions. They also manage, monitor, and ensure the security and privacy of data to satisfy business needs.

Essential Qualifications
• Ability to synthesize data, uncovers inherent trends in data, assess impacts of data on business usage, and make recommendations for improvement.
• Data Delivery Leads must get, ingest, transform, validate, and clean up data to meet business requirements.
• Prior experience working in the Property and Casualty Insurance domain a must have.
• Prior experience working in a data warehouse environment or on data integration projects a strong plus.
• Self-motivated and innovative with the ability to set direction, manage own work, and effectively obtain results from others.
• Strong influencing & partnership skills; ability to work collaboratively with business and IT counterparts.
• Exceptional communication & interpersonal skills, verbal & written
• Ability to multi-task & adapt within a constantly changing environment
• Strong organizational & analytical skills, high attention to detail.

Technical Skills
• Prior Experience working with Informatica PowerCenter or Informatica Intelligent Data Management Cloud (IDMC).
• Knowledge of at least one of the following programming languages, Python, Scala, Java, C •# •
• Proficiency with SQL to facilitate the data integration process through data profiling, understanding relationships in the data, and validating the integrity of the data.
• Experience working with enterprise class RDBMS platforms like Oracle, SQL Server, and DB2. Must have worked on ETL efforts in one of these environments.
• Experience creating UNIX shell scripts to perform file level validation and analysis.
• Prior experience building solutions on Cloud based PaaS like MS Azure SQLDW or other Cloud Platforms.
• Exposure to serialized data formats such as XML and JSON.


Responsibilities
--------------------

• Analyze business procedures and requirements to recommend specific types of data that can be used to improve upon them.
• Work with business stakeholders to outline the specific data solutions for a project.
• Serve as technical lead for projects, enhancements, and production. Provide direction, leadership, and mentorship to data team resources to ensure quality of deliverables.
• Work with Information architect and other data team members to develop high/low level designs and technical specifications that can be accurately executed by onshore and offshore outsourced resources.
• Ability to gain a complete understanding of systems, data flows, integration points, and quickly asses the impacts of changes.
• Establish work estimates based on business requirements through participation in project feasibility, scoping, and estimating activities.
• Provide hands-on design, development and testing for the most complex work.
• Coordinate/lead production implementations to ensure smooth and quality releases.

Other Knowledge/Skills/Abilities:
-------------------------------------

• Excellent communication/interpersonal skills, with experience coordinating ETL work with an onshore/offshore vendor team. Must be able to clearly communicate.
• Excellent problem solving skills. Applies technical knowledge to determine solutions and solve complex problems.
• Proven ability to create and maintain documentation (ETL designs, technical specs, test cases, test results, project status, deployment plans, etc.)
• Experience working on projects using Agile, Scrum, or Scaled Agile Framework (SAFe).