We are looking for a creative and talented individual and engineer to fill the position of Sr Data Engineer in the Information Management/Business Insights organization (IM/BI). The Sr Data Engineer is responsible for design, development, integration and optimization of analytic repositories and data marts in support of financial/business reporting, dashboarding, and self-service analytics. Additionally this role is in support of leveraging data, data analysis and data driven solutions in creative ways to optimize and advance Chubb’s Business.
The ideal candidate will be a software engineer with strong hands-on experience of building Data focused solutions, database and data integration design methodologies, and data integration tooling. Experience with large and diverse datasets and platforms such as Informatica ICS, Azure Data Factory, SQL Data Warehouse are required in this fast paced environment.
Responsibilities
Re-engineer/re-imagine existing sub-optimal data pipelines and repositories to ensure high performance processing and timely access to high quality data.
Design and develop new data integrations, pipelines and repositories as needed to provide data analysis and insights to support the advancement of Chubb’s business
Ensure solutions are modular and flexible to accommodate changes in the data/information landscape
Ensure solutions are scalable to accommodate growth
Leverage appropriate DevOps and production tooling to ensure operations are fully automated to provide hands-off operations and monitoring
Work within multi-functional agile teams with end-to-end responsibility for product development and delivery
Develop relationships with key stakeholders to understand key requirements and collaborate on end-to-end solutions
Stay current with emerging technologies and industry trends.
Qualifications, Skills and Experience
5+ years’ experience of data analysis, design and integration/ETL
Excellent data analysis skills using T-SQL on SQL-DW or Spark SQL, ANSI SQL etc.
Excellent data modeling and design skill with large and complex data sets
Demonstrated experience with platforms such as Informatica ICS, Azure Data Factory, SQL Data Warehouse
Familiarity with data science and analytic tool sets such as Jupyter hub
Good understanding of Python and Jupyter Notebooks
Experienced in operating system command languages such as bash or ksh
Understanding of common data frameworks and data models to apply database and data solution designs
Understanding of the relational, object, document, key value, knowledge/graph modeling techniques
Understanding of Information Security concepts and tools
Behaviors and Competencies
Has demonstrated the ability to work well with others and be respected as a technologist
An excellent communicator and collaborator across multiple technical and business stakeholders
Must be a self-starter, work without supervision
Has the ability to work across cultural and language barriers