Senior 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; Chicago, IL; Columbus, OH; and Charlotte, NC) 3 days a week (Tuesday through Thursday).

• Demonstrate technical leadership and expertise in Snowflake’s cloud‑native architecture. 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.
• Integrate data pipelines with source control repository and build CI/CD pipeline and Dev Ops.
• Research and evaluate alternative solutions and recommend the most efficient and cost‑effective solution for the systems design.
• 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 the project.
• Collaborate 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 solutions that bring the most value to the business.
• Passion for learning new skills and the ability to adjust priorities on multiple projects based on changing demands/needs.

• Candidates must be authorized to work in the US without company sponsorship. The company will not support the STEM OPT I‑983 Training Plan endorsement for this position.
• 5+ years in Snowflake data warehousing, data pipelines and automation.
• 5+ years of hands‑on experience in data warehouse and data integration (ELT/ETL).
• 3+ years in cloud data modernization (ingestion, curation, data domains, data products).
• Experience working with data lakes loading disparate data sources – structured, semi‑structured data (flat files, XML, JSON, Parquet) and unstructured data.
• Ability to create, troubleshoot, enhance complex code in Snowflake Data Lakes/Data hubs/data warehouses.
• Experience in building data pipelines using cloud‑native ELT tools and automation of data ingestion including change data capture (CDC).
• Hands‑on experience with SnowSQL, stored procedures, UDFs using JavaScript, Snow Pipe and other Snowflake utilities.
• Experience with data governance (catalog, quality, lineage).
• Strong data warehouse application knowledge, preferably in the financial/insurance domain.
• Experience with version control tools, CI/CD pipeline and Dev Ops tools like Git Hub, Jenkins, Nexus and uDeploy.
• Knowledge of data profiling, data modeling and database design is key to this role.

• Snow Pro Core certified.
• AI certifications.
• Implementing AI data pipelines that bring together structured,…