Program Manager - Data Modernization & Property and Casualty

Overview

On Site
Depends on Experience
Contract - W2

Skills

Amazon Lambda
Access Control
Amazon Redshift
Amazon Web Services
Data Lake
ELT
Extract
Transform
Load
Insurance
KPI
PMP
Property And Casualty Insurance
Snow Flake Schema
Spectrum
Migration
Regulatory Compliance

Job Details

***CURRENTLY WE ARE NOT ABLE TO SPONSOR. WE ENCOURAGE TO APPLY & GC***

Job Title : Program Manager - Data Modernization & Property and Casualty
Location : Erie PA
Experience: 10+ years

Contract Long term

Role Overview:
We are seeking a seasoned Data Modernization Program Manager to lead an enterprise-wide Property and Casualty transformation program focused on modernizing our data ecosystem on AWS. This role will drive the migration of legacy data platforms to a cloud-native AWS Data Lake architecture integrated with Snowflake for scalable analytics. The successful candidate will combine program leadership skills with a deep understanding of AWS cloud services, data engineering best practices, and enterprise governance.
Key Responsibilities:

  • Must have strong Property and Casualty insurance domain experience.
  • Program Leadership & Strategy, running PI and Program planning sessions
  • Own and execute the AWS-centric data modernization roadmap, including AWS Data Lake build-out and Snowflake integration.
  • Collaborate with business and technology leaders to define modernization priorities, target architecture, and measurable success metrics.

Execution & Delivery:

  • Lead the migration of on-premises and legacy data platforms into AWS Data Lake and Snowflake
  • Oversee data ingestion pipelines using AWS Glue, AWS Lambda, AWS Kinesis, and other AWS-native services.
  • Implement automated ETL/ELT processes integrating AWS services with Snowflake.

Team & Stakeholder Management:

  • Lead cross-functional teams of data engineers, cloud engineers, BI developers, and governance specialists.
  • Coordinate with AWS account teams, Snowflake solution architects, and vendors to drive adoption of best practices.
  • Ensure transparent communication with executives and stakeholders on program progress, risks, and dependencies.
  • Risk, Compliance, and Optimization
  • Enforce AWS security best practices, including encryption, IAM roles, and data access controls.
  • Monitor KPIs, cost metrics, and optimize AWS & Snowflake resources for performance and budget efficiency.

Preferred Skills

  • AWS Certified Solutions Architect Professional or AWS Certified Data Analytics Specialty.
  • Snowflake SnowPro Core or Advanced certification.
  • PMP Certified

Sample Success Metrics

  • Legacy platform decommissioned within planned timelines.
  • X% improvement in data query performance in Snowflake.
  • Reduction in data storage and compute costs on AWS by X%.
  • Increased adoption of self-service analytics using AWS + Snowflake.

Technology & Architecture:

  • Partner with architects to design scalable AWS Data Lake architectures and high-performance Snowflake schemas.
  • Optimize AWS S3 storage, Snowflake compute usage, and data partitioning strategies.
  • Integrate AWS-native services (Glue, Athena, Redshift Spectrum) with Snowflake for hybrid workloads.
  • Establish metadata management and data quality frameworks leveraging AWS Glue Data Catalog and Snowflake governance features.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.