Senior Staff Data Engineer - Hybrid

Sr Staff Data Engineer - GE07DE

We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future.   

         

The Enterprise Data Services department’s IT team supporting Global specialty is seeking a hands-on Senior Staff Data Engineer to enhance and support its Data assets on snowflake and SQL server platform. We are looking for a talented professional with a proven track record of engineering the ELT development and integration using Snowflake.  Our ideal candidate will leverage deep technical expertise and problem-solving skills to deliver invest , maintenance and enhancement projects within the Data & Analytics Value stream.

This role will have a Hybrid work schedule, with the expectation of working in an office location (Hartford, CT; Danbury, CT; Charlotte, NC; Chicago, IL; Columbus, OH) 3 days a week (Tuesday through Thursday).

The Senior Staff Data Engineer will be proficient with data platform architecture, design, data curation, multi-dimensional models,  strong understanding of data architecture, principles of ETL and Data Warehousing. Responsibilities will also include technical delivery review, resolution of architecture issues in AWS Snowflake platform.

Responsibilities:

• Demonstrate Technical leadership and expertise in Snowflake’s cloud native architecture.
• Ability to create, troubleshoot, enhance complex code in Snowflake Data Lakes/Data hubs/data warehouses.
• Experience in building data pipelines(ELT) with Snowflake cloud data platform using AWS compute (EC2) and storage layers (S3).
• Experience in building the Snowflake SQL Datawarehouse using the Virtual warehouses based on best practices.
• Hands on experience working with  ELT tool with Snowflake.
• Implement and leverage Materialized views, Data Sharing, Clone Feature and Performed Dynamic data Masking.
• Have a solid understanding of delivery methodology(SDLC) and lead teams in the implementation of the solution according to the design/architecture.
• Hands on experience with Snow SQL, Stored Procedures, UDF’s using JavaScript, SnowPipe and other snowflake utilities.
• Experience in Data migration from RDMS to snowflake cloud Datawarehouse.
• Experience in data security and data access controls and design.
• Solution the data loading and unloading activities to/from Snowflake.
• Experience working with Data Lakes loading disparate data sources- Structured, semi-structured data (Flat files, XML, JSON, Parquet) and unstructured data.
• Experience in building data pipelines using cloud native ELT tools and automation of data ingestion including change data capture (CDC).
• Integration of data pipelines with source control repository and build CI/CD pipeline and DevOps.
• Experience in Performance Tuning of  Jobs to reduce the CPU time/load timing.
• Deeper Knowledge on SnowFlake License model and their continuous data protection life cycle.
• Architect reusable ETL components such as Audit and reconciliation of jobs. 
• Researches and evaluates alternative solutions and recommends the most efficient and cost-effective solution for the systems design.
• Support and quickly respond to Production issues and requirements clarifications.
• Coordinate as needed between multiple disciplines such as, Architects, Business Analysts, Scrum Masters, and Developers to get technical clarity leading to design, develop and implementation of business solution.
• Oversight of quality and completeness of detailed technical specifications, solution designs, and code reviews as well as adherence to the non-functional requirements.
• Experience in delivering technical solutions in an iterative, agile environment (Scrum/Kanban)
• Participate as active agile team member to help drive feature refinement, user story completion, code review, etc.
• Identify, document, and communicate technical risks, issues and alternative technical solutions discovered during project.
• Collaboration with a high-performing, forward-focused team, Release train engineer, Product Owner(s) and Business stakeholders.
• Ability to work on innovative and new projects with a "fail-fast" approach to provide optimal solut