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