Senior Data Integration Lead (Software Development Specialist 3)
Senior Data Integration Lead (Software Development Specialist 3)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
About Us:
Investing in opportunities for Ohioans that work for every person and every family in every corner of our state is at the hallmark of Governor DeWines agenda for Ohios future. To ensure Ohio is the best place to live work raise and family and start a business we must have strong schools a great quality of life and compassion for those who need our help.
Ohio Department of Medicaid plays a unique and necessary role in supporting the governors vision. As the single state Medicaid agency responsible for administering high-quality person-centric healthcare the department is committed to supporting the health and wellbeing of nearly one in every four Ohioans served. We do so by:
- Delivering a personalized care experience to more than three million people served.
- Improving care for children and adults with complex behavioral health needs.
- Working collectively with our partners and providers to measurably strengthen wellness and health outcomes.
- Streamlining administrative burdens so doctors and healthcare providers have more time for patient care.
- Ensuring financial transparency and operational accountability across all Medicaid programs and services.
The State of Ohio is a drug-free workplace which prohibits the use of marijuana (recreational marijuana/non-medical cannabis). Please note this position may be subject to additional restrictions pursuant to the State of Ohio Drug-Free Workplace Policy (HR-39) and as outlined in the posting.
What You Will Do at ODM:
Office: Data & Integrated Systems
Classification: Software Development Specialist 3 (PN )
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
On call 24 hours a day 7 days a to carry a cellular phone asassigned. Required to work occasionalovertime as assigned.
Job duty knowledge skill & abilitystatements at lower level areunderstood to be able to be performedat any higher level.
Travel required as needed. Mustprovide own transportation. Or in orderto operate a state vehicle you musthave a valid drivers license from stateof residence.
Resumes and/or attachments are notreviewed. Therefore please providedetail in the work experience section ofyour application.
At the State of Ohio we take care of the team that cares for Ohioans. We provide a variety of quality competitive benefits to eligible full-time and part-time employees*. For a list of all the State of Ohio Benefits visit ourTotal Rewards website! Our benefits package includes:
- 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)
*Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.
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
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.
Required Experience:
Senior IC
Employment Type
Full-Time
