The Ohio Department of Medicaid is seeking a software development professional to join our Enterprise Data Warehouse (EDW) Team. As a Senior Data Integration Lead, your responsibilities will include: Designing and developing ELT/ETL Data Pipeline using Snowflake, Snowpark scripts, SnowSQL queries, and stored procedures for curated data delivery. Performing data analysis, profiling, quality checks, and ingestion across multiple layers using Snowflake, Snowpark scripts, SnowSQL queries, stored procedures, and UNIX shell scripts. Creating mock data, conducting unit testing, and validating results in lower environments. Updating production support documentation, including Run Books and Control-M (or Airflow) schedules. Creating and maintaining functional and technical design documents. Providing detailed workflow documentation after each production release.