Product Specialist

Diversified Systems, Inc.

Columbus, OH

JOB DETAILS
SKILLS
Access Control, Analysis Skills, Apache Hadoop, Architectural Services, Automation, Bug Tracking/Defect Management, Business Model, Career Development, Clinical Laboratory, Cloudera, Contingency Plans, Continuous Improvement, Cross-Functional, Customer Acquisition, Customer Support/Service, Data Analysis, Data Management, Data Modeling, Data Quality, Database Administration, Database Extract Transform and Load (ETL), Decision Support, Diversity, Documentation, Ecosystems, Functional Testing, Identify Issues, Infectious Diseases, Information Technology & Information Systems, Information Technology Consulting, Internet Security, Laboratory, Laboratory Analysis, Laboratory Information Management System (LIMS), Laboratory Operations, Laboratory Systems, Leadership, Maintain Compliance, Metrics, Network Debugging, Operational Improvement, Operational Strategy, Operational Support, Privacy Regulations, Problem Solving Skills, Product Support, Product Testing, Production Systems, Project Design, Project Development, Project Estimates, Project Evaluation, Project Schedule, Project/Program Coordination, Project/Program Management, Promotional Programs, Public Health, Python Programming/Scripting Language, Quality Assurance, Quality Assurance Methodology, Quality Metrics, Query Optimization, Regulations, Regulatory Compliance, Regulatory Requirements, Relational Databases (RDBMS), Requirements Management, Risk Analysis, SQL (Structured Query Language), Scripting (Scripting Languages), Snowflake Schema, Software Design for Test (SDET), Software Patches, Software Testing, Statistics, Stored Procedures, Surveillance, System Test, System Validation, Systems Administration/Management, Technical Analysis, Technical Writing, Technical/Engineering Design, Test Case, Test Design, Test Plan/Schedule, Test Scenario, Test Strategy, Testing, Time Management, Traceability, Training/Teaching, Trend Analysis, Unix Shell Programming, Usability Engineering
LOCATION
Columbus, OH
POSTED
1 day ago

Product Specialist
Onsite
 

Description:
Diversified Systems is searching for a results-driven Product Specialist to support laboratory information systems, data analytics, public health reporting, platform modernization, LIMS optimization, system testing, stakeholder engagement, project coordination, and security governance initiatives. This role serves as a subject matter expert responsible for ensuring product reliability, data integrity, operational efficiency, regulatory compliance, and continuous improvement across laboratory and public health technology platforms.


Responsibilities:

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


Requirements:

  • 4-6 years of experience testing I.T. products and applications required.
  • Up-to-date knowledge of software test design and testing methodologies required.
  • SQL development, query optimization, and data modeling required.
  • Data analytics, statistical interpretation, and longitudinal reporting required.
  • LIMS workflow analysis, configuration, and testing required.
  • System validation, quality assurance, and defect analysis required.
  • Technical requirement gathering and solution design required.
  • Cross functional technical communication and documentation required.
  • Snowflake cloud data warehouse required.
  • Cloudera/Hadoop ecosystem required.
  • Laboratory Information Management Systems (LIMS) required.
  • ETL workflows and data integration pipelines required.
  • Relational database management systems (RDBMS) required.
  • SQL (complex joins, aggregations, stored procedures) required.
  • Python (data analysis, automation, validation scripts) required.
  • Shell scripting for workflow checks and basic automation required.
  • Experience with Medical Laboratory systems highly desired.
  • 4-year college degree or equivalent technical study highly desired.


About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.

Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.

Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.

About the Company

D

Diversified Systems, Inc.