Seeking a Senior Snowflake Hadoop Developer experience in Laboratory Information Management Systems for workflow analysis, configuration, and testing using Snowflake cloud data warehouse and Cloudera/Hadoop ecosystem.
Interview: On-Site
Location: Columbus, OH
Posting: 807473
Work: ON-SITE
Role and Experience
up-to-date knowledge of software test design and testing methodologies
· 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
· 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
· Experience with Medical Laboratory systems
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.
Never miss an opportunity! Create an alert based on the job you applied for.
