Business Intelligence Developer/Report Writer

Massachusetts Water Resources Authority; Chelsea (MA); Hybrid; USD 91,000 - 134,000; Full time

Job summary

Massachusetts Water Resources Authority (MWRA) seeks an experienced Reporting and BI specialist to design, develop, and maintain BI solutions for Enterprise Asset Management, ERP, and other data-intensive systems. You will primarily build reports and dashboards, with data analysis, requirements gathering, query development, testing, and documentation.

Based in Chelsea, MA, with a salary between $91,420 and $134,454 per year and a standard 8:00 am–4:00 pm schedule, this position may offer

Qualifications

• A Bachelor's degree in computer science or related field.
• At least five years IT experience including three years' IT development with enterprise apps (Infor CloudSuite Birst, IBM Maximo BIRT, SAP, or Crystal Reports).
• Experience developing SQL queries, views, stored procedures, triggers and functions; BI dashboards and reports.
• ITIL Foundation v3 Certification is required or must obtain within twelve months.
• Position may be eligible for telework up to 50% of the work week.

Responsibilities

• Develops and maintains reports and BI objects such as dashboards and other data visualizations.
• Gathers business requirements and translates them into reporting specifications.
• Creates complex SQL statements and data relationships.
• Uses ETL and data management tools to prepare data for reporting sources.
• Coordinates report deployments with sponsors and MIS staff.

Skills

BI development

SQL development

Data analysis

ETL tools

Communication

Education

Bachelor's degree in computer science or related field

Tools

Infor CloudSuite Birst

IBM Maximo BIRT

SAP

Crystal Reports

Job description

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:

This position is responsible for designing, developing and maintaining Reporting and Business Intelligence (BI) solutions at the MWRA. The Reporting and BI development includes both administrative and operational systems such as Enterprise Asset Management (EAM), Enterprise Resource Planning (ERP) as well as other data intensive applications. The primary responsibility is report and dashboard development, however data analysis, requirements gathering, query development, testing and documentation are also required activities.

Posting Period: 10/6/2026 to 11/5/2026

Location: Chelsea, MA

Salary: $91,420.07 - $134,454.04 Annually $1,758.08 - $2,585.65 Weekly

Work Schedule: Monday - Friday 8:00am - 4:00pm

Key Responsibilities

• Develops and maintains traditional paginated reports as well as Business Intelligence objects such as dashboards, universes and other data visualizations.
• Gathers business requirements and translates them into reporting specifications and solutions.
• Creates complex and optimized SQL statements and business class relationships.
• Uses orchestration, ETL and data management tools to prepare data in the reporting data source.
• Creates and maintains business layers to allow users easy access to the data.
• Performs data analysis to verify report results against information source and user expectations.
• Identifies data sources and performs data collection, cleaning and transformation.
• Provides proof of concept analytical analysis on proposed datasets to report sponsor for verification.
• Utilizes application security model to securely access required data.
• Ensures proper use of titles, headers, footers, charts, tables, graphics, and figures.
• Uses sub-reports to include related information not available in primary data set.
• Performs unit, integration, functional, and regression testing.
• Prepares and submits documentation to Change Advisory Board (CAB).
• Coordinates report deployments with sponsors, MIS staff, and CAB.
• Prepares and updates reporting documentation.
• Maintains report version repository.
• Upgrades software as necessary.
• Performs related duties as required.

Required Qualifications

• A Bachelor's degree in computer science or related field; and
• At least five years IT experience including three (3) years' IT development experience supporting enterprise applications including Infor CloudSuite Birst,IBM Maximo BIRT, SAP, or Crystal Reports; and
• Experience developing SQL queries, views, stored procedures, triggers and functions. developing formatted reports, BI dashboards, BI reports, BI universes and other BI data visualizations; or
• Any equivalent combination of education or experience.
• Information Technology Infrastructure Library (ITIL) Foundation v3 Certification is required or the ability to obtain within twelve months.
• Position may be eligible for telework up to 50% of the work week.

Knowledge and Abilities

• Expertise with Infor CloudSuite Birst Designer and Visualizer or IBM Maximo BIRT Designer development or SAP Business Objects Crystal Reports and Web Intelligence.
• Ability to create formatted reports and interactive dashboards.
• Experience with relational databases (Oracle, SQL Server, DB2), data warehouses, data marts and data lakes.
• Ability to model data and design, write and optimize complex SQL statements and Stored Procedures.
• Ability to use data management tools and workflows to orchestrate application and other data into the reporting data source.
• Strong knowledge of relational database tables, star schemas, views, triggers, indexes and other database objects.
• Experience with business and security classes.
• Experience with Web Services and APIs is desirable.
• Understanding of the Software Development Life cycle.
• Knowledgeable of scripting or programming languages as well as operating systems.
• Strong analytical skills and detail oriented.
• Excellent written and oral communication skills.

Tools and Equipment Used

Office equipment as normally associated with the use of telephone, personal computers including word processing and other software, copy 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 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 frequently is required to sit and talk or hear. The employee is occasionally required to walk and stand.
The employee must frequently lift and/or move up to 25 pounds and occasionally lift and/or move up to 50 pounds. Specific vision abilities required by this job include close vision and color vision, and the ability to adjust focus.

Work Environment

The work 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 occasionally works in various field settings and in an office environment. The employee regularly works near moving mechanical parts, and is occasionally exposed to risk of vibration.
The noise level in the work environment is very loud in field settings, moderately loud at other work locations and moderately quiet at office settings. Position may be eligible to telework up to 50% of the time after an initial waiting period.

Supervision Received and Exercised

Works under the general supervision of the group supervisor. On specific IT projects, may be supervised by a team lead or project manager.

Other Position Information

Other Position Information
PCR: 8610084
Division: AdministrationDepartment: MIS
Union/Grade: United Steelworkers Local 9360 (Unit 6)/Grade 11

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.