Technical Product Specialist LIMS & Data Analytics

Engagement Type

Contract



Onsite 5x a week - ODH Lab, Reynoldsburg, OH

Onsite interviews

Complete Description

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



|

Required/Desired Skills

Skill Required/Desired Amount of Experience 4 year college degree or equivalent technical study Required Experience with Medical Laboratory systems Highly desired up-to-date knowledge of software test design and testing methodologies Required SQL development, query optimization, and data modeling Required LIMS workflow analysis, configuration, and testing Required Snowflake cloud data warehouse Required Cloudera/Hadoop ecosystem Required Relational database management systems (RDBMS) Required ETL workflows and data integration pipelines Required 4-6 years required experience testing I.T. products and applications Required 6.0 Years