Lead Snowflake Data Engineer (Software Development Specialist 4)

Ohio Department of Medicaid; Columbus (OH); On-site; USD 131,809,000 - 194,131,000; Full time

Job summary

The Ohio Department of Medicaid is seeking a Lead Snowflake Data Engineer to drive design, development, and optimization of a modern data platform. You will lead architectural decisions, improve data reliability, and enable analytics across the organization.

Ideal candidates bring advanced Snowflake expertise, enterprise data engineering background, and experience with ELT/ETL, medallion architecture, and cloud-native deployments.

Qualifications

• Deep Snowflake expertise (architecture, security, performance tuning).
• Strong enterprise data engineering and modern data warehousing background.
• Experience with ELT/ETL design, medallion architecture, and advanced data modeling.
• Proficiency with CI/CD pipelines and cloud-native deployment workflows.

Responsibilities

• Designs, builds, and optimizes Snowflake data architectures, including tables, views, materialized views, and Dynamic Tables.
• Implements and maintains Snowflake security models (RBAC, column-level, row-level security).
• Leads performance tuning using clustering strategies, warehouse sizing, and query optimization.
• Develops ELT/ETL pipelines and support medallion-layered data architecture.
• Manages schema changes, CI/CD deployments, and automation of data workflows.
• Analyzes business requirements and translates them into scalable data models and technical designs.
• Creates and maintains technical documentation, standards, and architecture artifacts.
• Oversees testing, validation, and performance assessments for platform enhancements.
• Troubleshoots production issues and ensures environment readiness for updates.
• Provides technical mentorship and guidance to engineers and project teams.

Skills

Snowflake architecture

Security

Performance tuning

Cloud computing

Tools

Cloud Computing

Technical Documentation

Operational Support

Software Development/Implementation

Job description

What You Will Do At ODM

Office: Data & Integrated Systems

Classification: Software Development Specialist 4 (PN 20102567)

Primary Technology: Snowflake Architecture, Enterprise Data Engineering, and Platform Development

Job Overview

The Ohio Department of Medicaid (ODM) is seeking a highly skilled Lead Snowflake Data Engineer with advanced Snowflake and enterprise data engineering expertise to drive the design, development, and optimization of our modern data platform. This role is ideal for a technical leader who thrives in designing scalable architectures, improving data reliability, and enabling analytics across the organization.

Key Responsibilities

• Designs, builds, and optimizes Snowflake data architectures, including tables, views, materialized views, and Dynamic Tables.
• Implements and maintains Snowflake security models (RBAC, column-level, row-level security).
• Leads performance tuning using clustering strategies, warehouse sizing, and query optimization.
• Develops ELT/ETL pipelines and support medallion-layered data architecture.
• Manages schema changes, CI/CD deployments, and automation of data workflows.
• Analyzes business requirements and translates them into scalable data models and technical designs.
• Creates and maintains technical documentation, standards, and architecture artifacts.
• Oversees testing, validation, and performance assessments for platform enhancements.
• Troubleshoots production issues and ensures environment readiness for updates.
• Provides technical mentorship and guidance to engineers and project teams.

What We're Looking For

• Deep Snowflake expertise (e.g. architecture, security, performance tuning)
• Strong enterprise data engineering and modern data warehousing background
• Experience with ELT/ETL design, medallion architecture, and advanced data modeling
• Proficiency with CI/CD pipelines and cloud-native deployment workflows

60 mos. combined work experience in any combination of the following: providing solutions design, developing project plans with project manager or recommending approach through defining tasks and/or leading meetings relating to programs for computer applications including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.

• Or completion of associate core program in computer science or information systems; 42 mos. combined work experience in any combination of the following: providing solutions design, developing project plans with project manager or recommending approach through defining tasks and/or leading meetings relating to programs for computer applications including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.
• Or completion of undergraduate core program in computer science or information systems; 36 mos. combined work experience in any combination of the following: providing solutions design, developing project plans with project manager or recommending approach through defining tasks and/or leading meetings relating to programs for computer applications including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.
• Or equivalent of minimum class qualifications for employment noted above. Note: The official position description on file with the designated agency is to reflect the required, primary technology directly relating to the duties of the position. only those applicants possessing the experience in the required, primary technology listed in the position description & job posting are to be considered for any vacancies posted. The job posting must list the required technology commensurate with the position in question.

Job Skills

Information Technology

Technical Skills

Technical Documentation, Operational Support, Software Development/Implementation, Cloud Computing

Professional Skills

Innovation, Collaboration, Analyzation

Agency Contact Name and Information

[e-mail]

Work Location

Lazarus 5

Primary Location

United States of America-OHIO-Franklin County-Columbus

Compensation

$46.00 - $67.75/hour

Schedule

Full-time

Work Hours

8:00 am - 5:00 pm

Classified Indicator

Classified

Union

OCSEA

Technical Skills

Cloud computing, Technical Documentation, Operational Support, Software development/implementation

Professional Skills

Analyzation, Collaboration, Innovation

Primary Technology

Data Integration Tools

Agency Overview

About Us: Investing in opportunities for Ohioans that work for every person and every family in every corner of our state is at the hallmark of Governor DeWine's agenda for Ohio's future. To ensure Ohio is "the best place to live, work, raise and family and start a business," we must have strong schools, a great quality of life, and compassion for those who need our help.

Responsibilities

Ohio Department of Medicaid plays a unique and necessary role in supporting the governor's vision. As the single state Medicaid agency responsible for administering high-quality, person-centric healthcare, the department is committed to supporting the health and wellbeing of nearly one in every four Ohioans served. We do so by:

• Delivering a personalized care experience to more than three million people served.
• Improving care for children and adults with complex behavioral health needs.
• Working collectively with our partners and providers to measurably strengthen wellness and health outcomes.
• Streamlining administrative burdens so doctors and healthcare providers have more time for patient care.
• Ensuring financial transparency and operational accountability across all Medicaid programs and services.