Job Details:
Position: DOH - Product Specialist 4/ PS4 (807473)
Location: Reynoldsburg, OH 43068 (Onsite 5 days per week)
Duration: Long-Term
Mode of Interview: In-Person Interview
Client: State of Ohio - Ohio Department of Health (ODH)
Job Description:
On Site Interviews.
Work Location:
Onsite ODH Lab, Reynoldsburg OH
Interview:
Onsite ODH Lab, Reynoldsburg OH
Requirement Description:
ODH is looking for a results-driven Product Specialist:
Strategic Product Oversight and Technical Leadership
Serve as the subject matter expert for designated laboratory information systems and related technical products.
Ensure product reliability, availability, and readiness for laboratory operations and application teams.
Evaluate the technical and functional impact of product enhancements, upgrades, and architecture changes.
Recommend improvements to strengthen product performance, usability, and long term scalability.
Participate in design and technical review sessions to confirm compliance with quality and regulatory standards.
Establish and maintain functional and usability standards to promote consistent product implementation.
Advanced Data Analytics and Public Health Reporting
Calculate newborn screening quality indicators across all stages of the screening workflow.
Conduct longitudinal analyses to identify infants at risk for critical or time sensitive health conditions.
Prepare and maintain turnaround time metrics for infectious disease testing and public health surveillance.
Monitor and analyze laboratory data utilization trends to support operational improvements and reporting accuracy.
Support epidemiological investigations with timely and validated data outputs.
Ensure data used for public health reporting meets accuracy, consistency, and completeness requirements.
Enterprise SQL Engineering, Data Architecture, and Platform Modernization
Update and optimize SQL scripts to support Snowflake based data storage following the IOP migration.
Validate data integration flows between Snowflake, LIMS, and associated laboratory applications.
Coordinate with database administrators to align logical, physical, and business data models.
Ensure high data quality, integrity, and traceability throughout all laboratory data workflows.
Troubleshoot data access, query performance, and platform related issues in collaboration with technical teams.
Support modernization initiatives by implementing SQL and data model improvements.
Laboratory Information Management System (LIMS) Optimization and Support
Assist in testing LIMS functionality during upgrades, module deployments, and workflow enhancements.
Perform impact analyses for production fixes and system enhancements to guide priority decisions.
Validate architectural compatibility for proposed LIMS improvements or new product integrations.
Provide timely issue resolution, troubleshooting, and user support for LIMS related challenges.
Maintain LIMS data accuracy through continuous validation and monitoring.
Coordinate closely with technical teams to ensure LIMS aligns with operational, regulatory, and data requirements.
System Testing, Quality Assurance, and Technical Documentation
Develop and execute structured test scenarios and test cases for product validation.
Review test strategies to ensure alignment with technical specifications and regulatory expectations.
Document system configurations, testing outcomes, product updates, and workflow changes.
Assign accurate severity levels to defects and manage remediation workflows.
Validate quality standards by ensuring all updates meet defined technical requirements.
Support continuous improvement of testing methodologies and documentation practices.
User Enablement, Technical Communication, and Stakeholder Engagement
Create and deliver training materials for laboratory users and technical teams.
Provide clear, consistent, and timely status updates to leadership, project teams, and stakeholders.
Collaborate with executive level users, program managers, and subject matter experts to refine requirements.
Use business driven examples to explain technical features and promote user adoption.
Translate complex technical concepts into accessible information for non technical stakeholders.
Support cross department engagement to ensure smooth communication during enhancements or migrations.
Project Coordination, Issue Resolution, and Risk Management 3%
Develop accurate project estimates for design, development, and testing tasks.
Track, manage, and resolve issues, risks, and action items impacting system or team performance.
Create contingency plans to address technical, operational, or data related risks.
Coordinate tasks and timelines across technical teams to ensure on schedule project delivery.
Support decision making by providing analytical assessments of project challenges.
Contribute to continuous improvement initiatives for project standards and technical processes.
Security Governance, Compliance Assurance, and Access Control Administration
Ensure product use complies with data governance rules, privacy regulations, and cybersecurity policies.
Define and manage user roles, permission structures, and access levels within the product ecosystem.
Coordinate with security teams to deploy patches, updates, and vulnerability fixes.
Validate LIMS data integrity to maintain regulatory and accreditation compliance.
Monitor system activity for potential security or compliance risks.
Support secure workflow design to maintain confidentiality, integrity, and proper access control.
Experience
up-to-date knowledge of software test design and testing methodologies
Mandatory Requirements/Skills
4-6 years' required experience testing I.T. products and applications
Skills, Tools, and Technologies
Technical Skills
SQL development, query optimization, and data modeling
Data analytics, statistical interpretation, and longitudinal reporting
LIMS workflow analysis, configuration, and testing
System validation, quality assurance, and defect analysis
Technical requirement gathering and solution design
Cross functional technical communication and documentation
Data Platforms and Technologies
Snowflake cloud data warehouse
Cloudera/Hadoop ecosystem
Laboratory Information Management Systems (LIMS)
ETL workflows and data integration pipelines
Relational database management systems (RDBMS)
SQL (complex joins, aggregations, stored procedures)
Python (data analysis, automation, validation scripts)
Shell scripting for workflow checks and basic automation
Desired Requirements/Skills
Experience with Medical Laboratory systems
Education
4-year college degree or equivalent technical study.
Required/Desired Skills:
| Skill | Required /Desired | Amount | Years of Experience |
| Experience with Medical Laboratory systems | Highly desired | 0 | |
| 4-6 years' required experience testing I.T. products and applications | Required | 0 | |
| Laboratory Information Management Systems (LIMS) - workflow analysis, configuration, and testing | Required | 0 | |
| Snowflake cloud data warehouse | Required | 0 | |
| Cloudera/Hadoop ecosystem | Required | 0 | |
| Relational database management systems (RDBMS | Required | 0 | |
| SQL (complex joins, aggregations, stored procedures) Python (data analysis, automation, validation scripts) Shell scripting for workflow checks an | Required | 0 | |
| Willing to work at onsite 5 days per week? | Required (Yes/No) | | |
| Willing to attend In-Person interview ? | Required (Yes/No) | | |
Never miss an opportunity! Create an alert based on the job you applied for.
