Lead Ai Data Engineer

Hartford Fire Insurance

Columbus, OH, US
Base: $135,040 - $202,560; bonus/equity: not speci...
Hybrid
Spark, snowflake, python, sql, pl/sql
Aws services, devops/dataops pipelines
Data integrity, accessibility, compliance
Join our multi-year Cloud Modernization journey, focusing on integrating data from multiple systems and curating high-quality data products using AI and Cloud tools

Job Summary

  • Join our multi-year Cloud Modernization journey, focusing on integrating data from multiple systems and curating high-quality data products using AI and Cloud tools.
  • Uphold data integrity, accessibility, and compliance while creating curated Data Products to support diverse analytics needs, including descriptive, diagnostic, predictive, and prescriptive use cases.
  • This role will have a Hybrid work schedule, with the expectation of working in an office (Columbus, OH, Chicago, IL, Hartford, CT or Charlotte, NC) 3 days a week (Tuesday through Thursday).

Matching Summary

Join our multi-year Cloud Modernization journey, focusing on integrating data from multiple systems and curating high-quality data products using AI and Cloud tools.

Salary

Base: $135,040 - $202,560; Bonus/Equity: Not specified; Benefits: Not specified

Skills & Requirements

Must-have

  • Spark, Snowflake, Python, SQL, PL/SQL
  • AWS services, DevOps/DataOps pipelines
  • Data integrity, accessibility, compliance
  • Data modeling, governance, security
  • Agile methodologies (Scrum, Kanban)
  • Large-scale data processing (batch, near-real-time)
  • Data observability practices

Nice-to-have

  • Lakehouse architecture
  • Data Mesh architecture
  • Streaming technologies
  • AI solution leveraging Cloud
  • Data Governance Office collaboration
  • Building and integrating AI agents
  • Tableau, Power BI proficiency

Key Requirements

  • Bachelor’s or master’s degree in computer science or related discipline
  • 5+ years of experience in data analysis, transformation, and development
  • 2+ years in the insurance or related industry
  • 3+ years developing/deploying data apps on AWS and Snowflake
  • 3+ years SQL, Python, and ETL tools (Informatica IDMC)
  • 3+ years designing/optimizing data models for Data Warehouses, Data Marts, Data Fabric
  • 3+ years processing large-scale structured/unstructured data
  • 3+ years Agile methodologies (Scrum, Kanban)
  • 2+ years leveraging DevOps pipelines
  • Authorized to work in the US without company sponsorship

Work Rights

Authorized to work in the US without company sponsorship

Tailored Resume

Cover Letter