Senior Data Integration Lead (Software Development Specialist 3) at Ohio Department of Administrative Services

, , -

Full Time

Start Date

Immediate

Expiry Date

25 Dec, 25

Salary

0.0

Posted On

26 Sep, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Integration, Snowflake, Snowpark, SnowSQL, Stored Procedures, SQL, Python, UNIX Shell Scripting, Control-M, Apache Airflow, Data Analysis, Data Quality, Documentation, ELT, ETL, Workflow

Industry

Government Administration

Description

What You Will Do at ODM: Office: Data & Integrated Systems Classification: Software Development Specialist 3 (PN 20102567) Primary Technology: Data Integration Tools (e.g. Snowpark, SnowSQL, AWS Glue, and Stored Procedures) Secondary Technology: SQL Job Overview: 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. The ideal candidate will have experience in the following technologies: Cloud & Modern Data Stack: AWS Glue, Snowflake, Snowpark, SnowSQL, and stored procedures Languages & Tools: SQL, Python, UNIX Shell Scripting Orchestration: Control-M, Apache Airflow 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. 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 Professional Skills: Innovation, Collaboration, Analyzation

Responsibilities

As a Senior Data Integration Lead, you will design and develop ELT/ETL data pipelines and perform data analysis and quality checks. You will also create and maintain documentation related to production support and workflows.