Business Systems Analyst, IT Water Quality

Job Summary

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

• Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (e.g. H-1B visa) for this opportunity. 
• AWA does not accept unsolicited resumes from external recruiting firms. All vendors must have a current and fully executed MSA on file before submitting candidates. Any unsolicited resumes and candidate profiles will be deemed the property of AWA, and no fee will be due.
• Employment with AWA is contingent upon the successful completion of pre-employment screenings, including a drug screening, where permitted by law.