LIMS Analyst

Role: Product Specialist – Laboratory Information Systems (LIMS) Location: Reynoldsburg, OH (100% Onsite) Interview: Onsite Duration: Long-Term Contract Job Summary Our direct client is seeking a Product Specialist to support Laboratory Information Management Systems (LIMS), enterprise data platforms, SQL development, software testing, and public health reporting. The ideal candidate will have experience in product support, data analysis, quality assurance, system validation, and SQL development in a laboratory or healthcare environment. Required Qualifications • Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience) • 4–6 years of experience testing IT products and applications • Strong SQL development and query optimization experience • Experience with relational databases and data modeling • Experience writing complex SQL queries, joins, aggregations, and stored procedures • Experience with system testing, QA, defect tracking, and test case development • Strong analytical and problem-solving skills • Excellent documentation and communication skills Preferred Qualifications • Laboratory Information Management Systems (LIMS) • Medical laboratory or healthcare systems experience • Snowflake Data Warehouse • Cloudera/Hadoop • ETL/Data Integration • Python scripting • Shell scripting • Public health reporting and data analytics Key Responsibilities Product & Application Support • Serve as the technical subject matter expert for laboratory information systems. • Evaluate product enhancements, upgrades, and technical solutions. • Support application reliability, scalability, and usability. • Participate in technical design and architecture reviews. SQL & Data Engineering • Develop and optimize SQL queries and stored procedures. • Support Snowflake data warehouse initiatives. • Validate data integration between LIMS and enterprise systems. • Troubleshoot SQL performance and data quality issues. Data Analytics & Reporting • Analyze laboratory and public health data. • Generate operational and turnaround-time reports. • Support epidemiological investigations through accurate reporting. • Ensure data integrity and regulatory compliance. LIMS Administration • Support LIMS upgrades, testing, and workflow improvements. • Perform impact analysis for system changes. • Troubleshoot production issues. • Maintain laboratory data quality and integrity. Software Testing & Quality Assurance • Create and execute test plans and test cases. • Perform system validation and regression testing. • Document defects and testing results. • Support release validation and quality assurance processes. Project Coordination • Assist with project planning and technical estimates. • Track issues, risks, and action items. • Support cross-functional project teams. • Participate in continuous improvement initiatives. Security & Compliance • Manage user access and security roles. • Support data governance and regulatory compliance. • Coordinate security updates and vulnerability remediation. • Monitor system integrity and access controls. Technical Skills • SQL • Snowflake • Python • Shell Scripting • ETL • Data Integration • Relational Databases (RDBMS) • Data Modeling • LIMS • Hadoop / Cloudera • Software Testing / QA • System Validation • Technical Documentation Soft Skills • Strong analytical thinking • Excellent written and verbal communication • Stakeholder management • Problem-solving • Collaboration across technical and business teams • Ability to explain technical concepts to non-technical users