Lead Snowflake Data Engineer (Software Development Specialist 4)

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

Why Work for the State of Ohio

At the State of Ohio, we take care of the team that cares for Ohioans. We provide a variety of quality, competitive benefits to eligible full-time and part-time employees*. For a list of all the State of Ohio Benefits, visit our Total Rewards website! Our benefits package includes:

• Medical Coverage

• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period

• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year

• Childbirth, Adoption, and Foster Care leave

• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)

• Public Retirement Systems (such as OPERS, STRS, SERS, and HPRS) & Optional Deferred Compensation (Ohio Deferred Compensation)

• Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.

Qualifications

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

Supplemental Information

The Ohio Department of Medicaid does not provide employment-based visa sponsorship.

On call 24 hours a day, 7 days a week. Required to carry a cellular phone as assigned. Required to work occasional overtime as assigned.

Job duty, knowledge, skill & ability statements at lower level are understood to be able to be performed at any higher level.

Travel required, as needed. Must provide own transportation. Or, in order to operate a state vehicle, you must have a valid driver's license from state of residence.

Resumes and/or attachments are not reviewed. Therefore, please provide detail in the work experience section of your application.

ADA Statement

Ohio is a Disability Inclusion State and strives to be a model employer of individuals with disabilities. The State of Ohio is committed to providing access and inclusion and reasonable accommodation in its services, activities, programs and employment opportunities in accordance with the Americans with Disabilities Act (ADA) and other applicable laws.

Drug-Free Workplace

The State of Ohio is a drug-free workplace which prohibits the use of marijuana (recreational marijuana/non-medical cannabis). Please note, this position may be subject to additional restrictions pursuant to the State of Ohio Drug-Free Workplace Policy (HR-39), and as outlined in the posting.