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