Project Manager, Pretreatment Information Management System (PIMS)

Are you looking to make a meaningful impact on public health and the environment? Join the MWRA team! We deliver some of the nation's highest-quality drinking water to 3 million residents, restored Boston Harbor, and continue to invest in protecting vital public resources. Be part of a mission-driven organization where your work truly makes a difference in a safe, inclusive, and supportive environment.

Summary:

Manages the day-to-day projects related to information management of the MWRA's EPA-approved pretreatment program. Coordinates MWRA's pretreatment program database needs with Management Information Systems (MIS)staff and project consultants. Represents the TRAC Department's interests in ongoing future development of pretreatment information systems and their associated software applications (Laboratory Information Management System (LIMS), Geographic Information System (GIS), Cross-Media Electronic Reporting Rule (CROMERR) and successor applications.

Posting Period: 7/7/2026 to 7/20/2026
Location: Chelsea, MA
Salary: $100,049.18 to $139,887.65 Annually $1,924.02 to $2,690.15 Weekly
Work Schedule: Monday - Friday 7:00am - 3:00pm

Key Responsibilities

• Manages day-to-day issues with Pretreatment Information Management System (PIMS) as they arise. Troubleshoots problems, initiates service requests, proposes temporary work-arounds to enable staff to meet their short and long term pretreatment program requirements and recommends long term solutions.
• Develops reports, for Department and external users, utilizing business intelligence applications such as SAP Crystal Reports and SAP Webi (Web BI).
• Creates custom SQL queries for data extraction from the PIMS database utilizing Oracle SQL Developer.
• Designs and implements dynamic Word templates alongside XML data extraction to generate documents within the PIMS application.
• Validates PIMS application stability post-server upgrades through comprehensive regression testing, collaborating with MIS to ensure uninterrupted operations.
• Develops and implements PIMS quality assurance/quality compliance (QA/QC) plan to ensure database integrity and reliable information.
• Develops standard operating procedures for TRAC staff interactions with PIMS in accordance with QA/QC plan.
• Reviews functionality of PIMS and identifies ways to leverage the existing system functionality to improve efficiency and effectiveness of TRAC staff. Recommends enhancements for improved efficiencies.
• Supports the pretreatment program in ensuring that submitted Web Based Self Monitoring Reports (WebSMR)and data are CROMERR compliant.
• Serves as the primary liaison with MIS Department to translate business requirements into structured technical specifications for IT development.
• Provides on-going training and user support for PIMS and related systems.
• Assesses systems performance and works with users to identify system needs and determine appropriate hardware/software/training/procedural improvements.
• Prepares data requests to meet the needs of the TRAC and Legal Department or other MWRA groups.
• Provides capital and current expense budget input for computer related equipment and software purchases.
• Performs related duties as required.

Required Qualifications

• A Bachelor's degree in environmental or related sciences, environmental engineering, computer sciences, or related field; Master's degree preferred; and
• At least five (5) years of experience in project management, application development or database management; or
• Any equivalent combination of education or experience.
• A valid Massachusetts Driver's license or driver's license from another state.
• Position may be eligible to telework up to 50% after an initial waiting period.

Knowledge and Abilities

• Knowledge of principles and practices of National Pretreatment Program or related field required.
• Demonstrated proficiency in data analysis, database development, management and planning.
• Demonstrated ability in a variety of computing environments, particularly Oracle Discoverer, structured query language (SQL) or Microsoft Access strongly preferred.
• Knowledge of MWRA's PIMS, LIMS and geographic information systems, particularly ARC/VIEW and ARC/INFO preferred.
• Excellent interpersonal, oral and written communication skills.

Tools and Equipment Used

Office machines as normally associated with a professional office environment, including the use of telephones, personal computers, word processing and other software, email, videoconference applications, copiers, scanners and fax machines.

Physical Demands

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to use hands to finger, handle, feel or operate objects, tools or controls and reach with hands and arms. The employee is regularly required to sit and talk or hear. The employee is frequently required to stand and walk.
The employee must regularly lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision and the ability to adjust focus.

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. While performing the duties of this job, the employee regularly works in an office environment.
The noise level in the work environment is usually moderately quiet.

Supervision Received and Exercised

Works under the general supervision of the Program Manager, Industrial Treatment Systems & Data.
Exercises supervision of professional employees.

Other Position Information
PCR: 2210064 Division: Operations
Department: TRAC
Union/Grade: MOSES (Unit 9)/Grade 25

Massachusetts Water Resources Authority (MWRA) is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, national or ethnic origin, age, religion, disability, sex or gender, sexual orientation, gender identity or expression, or veteran status.