Water Data & Revenue Analytics Manager

Town of Shrewsbury, Massachusetts; Shrewsbury (MA); On-site; USD 60,000 - 95,000; Full time

Benefits offered by this job

Health insurance

Pension

Professional development

Paid time off

Job summary

The Town of Shrewsbury is seeking an experienced Data Analyst to join the Public Works Business Management Division as a Water Analytics Program Manager. You will bridge billing data with water operations to improve data integrity, revenue assurance, and operational efficiency.

You’ll perform meter data audits, reconcile production and consumption, manage MUNIS ERP setup, and produce reports on system loss and performance.

Qualifications

• Bachelor’s degree in a data analytics, business administration, operations management, or related field with 1–3 years in a data analysis role.
• Advanced Excel skills and proficiency with data analysis tools.
• Experience with MUNIS highly preferred.
• Ability to identify and troubleshoot complex data discrepancies and system integration failures.
• Strong communication and problem-solving skills.
• Ability to work with staff, boards, vendors, and the public.

Responsibilities

• Performs analyses and audits of meter data to identify discrepancies impacting read and billing accuracy.
• Reconciles water production vs. consumption to identify Unaccounted for Water (UAW) trends.
• Manages water meter data setup in the MUNIS ERP system to ensure billing accuracy.
• Oversees data transfers between UtilityUIQ, Temetra, and MUNIS for data integrity.
• Identifies opportunities to improve revenue collection with Utility Billing.
• Consolidates data from pumping stations and meters to report system loss and efficiency.

Skills

Excel proficiency

Data analysis

Analytical mindset

Communication

Education

Bachelor's degree in data analytics, business administration, operations management or related field

Tools

MUNIS

Job description

The Town of Shrewsbury is seeking an experienced Data Analyst to join the Public Works Business Management Division as a Water Analytics Program Manager. You will bridge billing data with water operations to improve data integrity, revenue assurance, and operational efficiency.

You’ll perform meter data audits, reconcile production and consumption, manage MUNIS ERP setup, and produce reports on system loss and performance.