Product Specialist

We need to output HTML fragment with sections: About the role (maybe from description), Responsibilities, Requirements, maybe Benefits? The posting mentions "We offer our consultants a number of flexible and competitive compensation benefit packages." That's a benefit statement but vague. It says "flexible and competitive compensation benefit packages." That's somewhat generic but still a benefit mention. However rule: include a section ONLY when posting has real, specific content for it — never emit a heading followed by filler/placeholder text (e.g., "commensurate with experience", "not specified", "N/A", "varies", "TBD") and never create Pay/Schedule/Benefits sections unless the posting actually states them. Here we have "flexible and competitive compensation benefit packages." That's somewhat vague but still states benefits exist. It's not specific like health insurance, 401k, etc. Might be considered too vague? The rule says avoid filler/placeholder text like "commensurate with experience", "not specified", "N/A", "varies", "TBD". "flexible and competitive compensation benefit packages" is not exactly placeholder but still vague. Might be okay to include Benefits section with that sentence. However they also say "Prefer a few substantive sections over many thin ones." Could combine Benefits into About the role? Probably better to have Benefits section with that statement. Also Pay and Schedule not mentioned, so omit. We need to use

for section headings. Use

• for any list of duties/requirements/benefits, and

  for prose. We need to preserve all substantive information; do not invent or summarize away detail. Remove boilerplate: cookie/navigation/legal/EEO/equal-opportunity/scam-warning boilerplate, duplicated lines, and application instructions. The posting includes EEO statements etc at end: "Diversified Systems is committed to the principles of equal employment..." and Diversity, Equity and Inclusion section. Those are boilerplate EEO/diversity statements; we should remove them. Also "About Diversified Systems" includes some description; we might keep that as part of About the role? The instruction: "Use

  for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule)." So we can have About the role section that includes the Onsite Description and maybe About Diversified Systems? The Onsite Description is at top: "Onsite Description: Diversified Systems is searching for a Product Specialist. This position serves as a subject matter expert..." That's basically the role summary. Then later there is "About Diversified Systems" paragraph. That could be part of About the role or maybe separate but we only have headings list; we could put About the role includes both the description and company overview. That seems fine. We must not repeat the job title as a heading. So no heading for "Product Specialist". Good. We need to output only HTML fragment. Let's extract content: Onsite Description: "Diversified Systems is searching for a Product Specialist. This position serves as a subject matter expert for laboratory information systems, data platforms, reporting environments, and related technical products. The consultant will support laboratory operations through advanced data analytics, SQL development, platform modernization, LIMS optimization, testing, system validation, stakeholder engagement, and project coordination activities." That's prose; we can put in

  . Responsibilities: many bullet points under headings like "Strategic Product Oversight and Technical Leadership", "Advanced Data Analytics and Public Health Reporting", etc. Those are subheadings within responsibilities but we can treat each bullet as list items. The responsibilities section includes multiple paragraphs each starting with a bold heading. We need to preserve all substantive information; we can convert each bullet point into

  under a

  . However we need to keep the subheadings? The instruction: Use
  • for any list of duties/requirements/benefits. So we can flatten them into a list, losing the subheadings but preserving the content. That's acceptable as we preserve all substantive information (the text). Could also keep subheadings as

    then list. But simpler: make a

    with each responsibility sentence as
    • . Ensure we capture all. Let's list responsibilities sentences: From "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. From "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. From "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. From "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. From "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. From "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. From "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. From "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. Now Requirements: list each requirement line. Requirements bullet list: - 4-year college degree or equivalent technical study required. - 6 years of experience testing IT products and applications required. - Up-to-date knowledge of software test design and testing methodologies required. - Experience with SQL development, query optimization, and data modeling required. - Experience with LIMS workflow analysis, configuration, and testing required. - Experience working with Snowflake cloud data warehouse required. - Experience working within the Cloudera/Hadoop ecosystem required. - Experience with relational database management systems (RDBMS) required. - Experience with ETL workflows and data integration pipelines required. - Experience performing data analytics, statistical interpretation, and longitudinal reporting required. - Experience with system validation, quality assurance, and defect analysis required. - Experience gathering technical requirements and supporting solution design required. - Strong cross-functional technical communication and documentation skills required. - Experience using SQL including complex joins, aggregations, and stored procedures required. - Experience with Python for data analysis, automation, and validation scripts required. - Experience with shell scripting for workflow checks and automation required. - Experience with Medical Laboratory systems highly desired. Note: "Experience with Medical Laboratory systems highly desired." is not required but desired; we still include as it's substantive. Now About the role: we have Onsite Description paragraph plus maybe About Diversified Systems paragraph (founded 1990 etc). Also there is a line: "We offer our consultants a number of flexible and competitive compensation benefit packages." That's benefits. We should also include maybe a short paragraph about company: "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 can combine that into About the role section. Now Benefits: we have that sentence about flexible and competitive compensation benefit packages. Could also include that they offer flexible and competitive compensation benefit packages. That's it. We should not include EEO/diversity sections. Now produce HTML:

      About the role

      Diversified Systems is searching for a Product Specialist. This position serves as a subject matter expert for laboratory information systems, data platforms, reporting environments, and related technical products. The consultant will support laboratory operations through advanced data analytics, SQL development, platform modernization, LIMS optimization, testing, system validation, stakeholder engagement, and project coordination activities. 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.

      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 Snow