Senior Data Integration Lead (Software Development Specialist 3) jobs in United States
cer-icon
Apply on Employer Site
company-logo

State of Ohio · 6 hours ago

Senior Data Integration Lead (Software Development Specialist 3)

The Ohio Department of Medicaid is seeking a software development professional to join our Enterprise Data Warehouse Team. As a Senior Data Integration Lead, your responsibilities will include designing and developing data pipelines and performing data analysis to support high-quality, person-centric healthcare.

Automotive
badNo H1Bnote

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

SnowflakeAWS GlueSQLPythonUNIX Shell ScriptingControl-MApache AirflowOperational SupportSoftware DevelopmentInnovationAnalyzationTechnical DocumentationCollaboration

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
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

Benefits

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)

Company

State of Ohio

company-logo
Employment with the State of Ohio is more than ‘just a job’ – it is a privilege to serve our families, friends and neighbors who rely on us throughout our great state.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Beverlyn Johns, MS
Deputy Chief Operating Officer
linkedin
leader-logo
Holly Drake
State Chief Information Security Officer
linkedin
Company data provided by crunchbase