Job Title : Data Modernization Program Manager
Location : Erie PA - Onsite 5 days a week
Duration : 12+ Months
Experience Needed : 15+ Years
Note : Candidate must have experience with Property and Casualty insurance Domain
Role Overview :
We are seeking a seasoned Data Modernization Program Manager to lead an enterprise-wide 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 :
- 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 SnowflakeOversee 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.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.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 OptimizationEnforce 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 CertifiedSample 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.