Business Intelligence Developer/Report Writer

Massachusetts Water Resources Authority•Chelsea, MA

17h•$91,420 - $134,454•Hybrid

About The Position

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.

Requirements

A Bachelor's degree in computer science or related field
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
Experience developing SQL queries, views, stored procedures, triggers and functions.
Experience developing formatted reports, BI dashboards, BI reports, BI universes and other BI data visualizations
Information Technology Infrastructure Library (ITIL) Foundation v3 Certification is required or the ability to obtain within twelve months.

Nice To Haves

Expertise with Infor CloudSuite Birst Designer and Visualizer or IBM Maximo BIRT Designer development or SAP Business Objects Crystal Reports and Web Intelligence.
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.

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.