Location Requirements
Onsite ODH Lab, Reynoldsburg OH
Interview Process
(Virtual/Onsite)
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 subjectmatter 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 longterm 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 timesensitive health conditions.
• Prepare and maintain turnaroundtime 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 Snowflakebased 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 platformrelated 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 LIMSrelated 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 executivelevel users, program managers, and subjectmatter experts to refine requirements.
• Use businessdriven examples to explain technical features and promote user adoption.
• Translate complex technical concepts into accessible information for nontechnical stakeholders.
• Support crossdepartment engagement to ensure smooth communication during enhancements or migrations.
Project Coordination, Issue Resolution, and Risk Management
• 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 datarelated risks.
• Coordinate tasks and timelines across technical teams to ensure onschedule project delivery.
• Support decisionmaking 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.
Never miss an opportunity! Create an alert based on the job you applied for.
