Senior Data Integration Lead; Software Development Specialist

Senior Data Integration Lead (Software Development Specialist
3)

Ohio Department of Medicaid

Data & Integrated Systems

Columbus, OH 43215 United States

$40.59 - $59.70 per hour

Full-time

OCSEA

Data Integration Tools (Snowpark, SnowSQL, AWS Glue, Stored Procedures)

As a Senior Data Integration Lead, you will develop and maintain ELT/ETL pipelines to deliver curated data.

• Design and develop ELT/ETL data pipelines using Snowflake, Snowpark scripts, SnowSQL queries, and stored procedures.
• Analyze, profile, and perform quality checks for data ingestion across multiple layers using Snowflake, Snowpark scripts, SnowSQL queries, stored procedures, and UNIX shell scripts.
• Generate mock data, conduct unit testing, and validate results in lower environments.
• Document production support, including run books and Control-M (or Airflow) schedules.
• Maintain functional and technical design documents.
• Provide detailed workflow documentation after each production release.

Minimum 60 months combined work experience in software development, including code reviews and application development standards. Candidates may qualify with an associate or undergraduate core program in computer science or information systems, plus 42–36 months combined experience. Applicants must possess experience in the primary technology listed in the position description and job posting.

• Medical coverage
• Free dental, vision, and basic life insurance premiums after eligibility period
• Paid time off: 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 (OPERS, STRS, SERS, HPRS) and optional deferred compensation (Ohio Deferred Compensation)

The Ohio Department of Medicaid does not provide employment-based visa sponsorship. Work is 24/7 on call, with occasional overtime as assigned. Travel may be required, and a valid driver’s license is necessary if operating a state vehicle.

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.

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