Bachelor's degree in Computer Science or a related field.
5-7 years of experience in business systems analysis, preferably in environmental science or laboratory settings.
Proficiency in LIMS application configuration and management, particularly for water quality systems.
Strong programming skills in VGL, VB Script, and familiarity with C#.
Knowledge of SQL databases and experience with MS SQL Management Studio.
Understanding of water quality monitoring regulations and compliance standards at state and federal levels.
Experience with ERP systems, preferably SAP, and knowledge of ABAP.
Responsibilities
Maintain and optimize LIMS metadata, including workflows and user access controls.
Manage relationships with external service providers and oversee workstreams.
Act as Subject Matter Expert to resolve system bugs and data anomalies.
Develop and deploy system enhancements and custom reports using LIMS tools.
Collaborate with the Water Quality department to digitize sampling protocols and workflows.
Generate operational and compliance reports, ensuring adherence to regulations.
Conduct training for lab personnel and create/update Standard Operating Procedures.
Benefits
Eligible for a hybrid work schedule after three months of successful employment.
Full-time, benefit-eligible role with comprehensive benefits package.
Opportunity for professional growth and development in a specialized field.
Engagement with cutting-edge technology and environmental compliance initiatives.
Full Job Description
Job Summary
The Business Systems Analyst, IT Water Quality will serve as the primary technical owner and system administrator for AWA's LIMS environment. Acting as the bridge between information technology and environmental science, this role will work closely with the Water Quality department to optimize sample tracking, automate laboratory workflows, manage instrument integration, and ensure rigorous regulatory compliance for municipal water and wastewater monitoring.
The Business Systems Analyst, IT Water Quality will partner with end users to develop a thorough understanding of business processes, analyze business processes, accurately document functional requirements, and work closely with IT staff and managing third party AMS support providers to identify, evaluate and present IT solutions that are both cost effective and meet customer needs.
Principal Responsibilities
System Administration and Configuration:
Maintain, configure, and optimize LIMS metadata including templates, workflows, lifecycle states, sample points, and user access controls.
Manage the relationship and workstreams with external services provider.
Function as the Subject Matter Expert (SME) to resolve system bugs, data anomalies, and connectivity issues.
Build, test, and deploy system enhancements, VGL (Validation Graphics Language) scripts, ET customizations, or report templates utilizing LIMS native toolsets.
Water Quality Department Collaboration:
Partner with Water Quality Laboratory Department and analysts to map out physical sampling protocols (process control, distribution networks, regulatory compliance) into digital workflows.
Support the generation of critical operational and compliance reporting, including State and Electronic Data Deliverables (EDDS) and Monthly Operational Reports (MORs).
Troubleshoot end-user issues, analyze data anomalies, and provide continuous technical support to lab personnel.
Facilitate status meetings and strategy sessions in collaboration with business SME's and vendor product roadmaps.
Ensure the system complies with federal and state safe drinking water regulations, environmental lab standards (e.g. Lead and Copper Revised Rule, PFAS, and security standards).
Coordinate routine Automated Systems Compliance Reviews (ASCRs), manage system audit trails, and preserve a fully validated state for data audits.
Establish robust backup, disaster recover, and archiving procedures for critical environmental quality data.
Training and Documentation:
Conduct onboarding and continuous training for lab technicians, field samplers, and utility managers on navigation.
Create and update Standard Operating Procedures (SOPs), system validation scripts, and change control logs.
Additional Responsibilities:
Manage requests for enhancements and support ongoing system maintenance work.
Prioritize fit to standard and use of existing applications/technology to support work processes prior to considering enhancements and new technology.
Manage and execute projects such as LIMS upgrades and enhancements to ensure adherence to schedules.
Build close working relationships with both business and IT partners.
Maintain awareness of technical and industry developments to ensure continued growth and knowledge.
Manage LIMS support vendors and oversee progress on assigned projects and tasks.
Perform technical coding in writing new reports and providing new functionality according to customer needs.
Technical Requirements
ERP - utility industry exposure (SAP preferred)
Knowledge of ABAP
LIMS - Understanding and configuration of LIMS Application (water quality systems preferred)
Maintain, design, and enhance static and dynamic tables
Maintain, design, implement reports and enhancements
Data integration with other applications - GIS, SAP, Mobility technology for field use
Compliance Monitoring software - Understanding and configuration of Compliance Monitoring Application
Maintain, design, and enhance static and dynamic tables
Maintain, design, implement reports and enhancements
Data integration with other applications (failed imports) - LIMS
Programming
Fluent in VGL Programming Language
Fluent in VB Script
Knowledgeable of C#
Knowledge of SQL databases
Understanding of Visual Studio and .NET platform
Fluent in MS SQL Management Studio
Water Quality
Understanding of Water Quality Monitoring Program and requirements on State and Federal Level
Familiar with laboratory methodologies, sampling procedures, and compliance monitoring
Understanding of rules and regulations for drinking water and CMDP State reporting
Preferred Requirements
Creating BRD (Business Requirements Document), SRD (Systems Requirements Document), and Use Case documentation
Knowledge of systems development lifecycle (SDLC) methodologies and change management process and software (e.g. ServiceNow, Cherwell, etc.)
Support change through collaboration, brainstorming, asking questions, and thinking outside the box
Provide management with accurate and timely status, risks or issues reporting.
Experience/exposure to alternative analysis and process workflow diagrams.
Ability to adjust priorities based on changing situations.
Ability to embrace feedback and the desire to further develop skills.
Budgeting, financial forecasting, long range planning
Environmental science or laboratory background
Education/Certifications
Bachelor's degree in, Computer Science or a related field.
Salary
This role is a full-time, benefit-eligible role.
This role is classified as an exempt salary role, with a salary range of $120,000 to $130,000.
This role reports out of the Monroe, CT office.
After three months of successful employment, this role will be eligible for a hybrid schedule (3 days office/2 days remote). However, based on business needs-such as training, testing, or project work-the employee may be required to work on-site for specific periods. Any such adjustments will be communicated in advance.
