Ohio Department of Medicaid · 5 hours ago
Senior Data Integration Lead (Software Development Specialist 3)
Columbus, OH
Full-time
Onsite
Senior Level
$40.59/hr - $59.70/hr
5+ years expThe Ohio Department of Medicaid is seeking a software development professional to join our Enterprise Data Warehouse (EDW) Team as a Senior Data Integration Lead. The role involves designing and developing ELT/ETL Data Pipelines and performing data analysis and quality checks, ensuring efficient data delivery and documentation for production support.
Government Administration
Responsibilities
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
Qualification
Required
60 mos. combined work experience in any combination of the following: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met 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: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met 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: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met 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
Experience in Data Integration Tools (e.g. Snowpark, SnowSQL, AWS Glue, and Stored Procedures)
Experience in SQL
Experience in Python
Experience in UNIX Shell Scripting
Experience in orchestration tools like Control-M or Apache Airflow
Technical Documentation skills
Operational Support skills
Software Development/Implementation skills
Professional skills in Innovation, Collaboration, Analyzation
Company
Ohio Department of Medicaid
The Ohio Department of Medicaid (ODM) delivers health care coverage to more than 3 million Ohioans on a daily basis.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Andrew Stevens
Chief Privacy Officer and Deputy Legal Counsel
Matt Stearmer
Chief Data Officer
Company data provided by crunchbase