Massachusetts Water Resources Authority - Chelsea, MA

posted 14 days ago

Full-time - Mid Level
Chelsea, MA
Administration of Environmental Quality Programs

About the position

This position is responsible for developing and managing the entire lifecycle of MWRA's reports managed by the MIS Department. Reports cover both administrative and operational systems such as Enterprise Asset/Maintenance Management (EAM), Enterprise Resource Planning (ERP), Helpdesk Ticketing, and other data intensive applications. The primary responsibility is report development, however work on requirements gathering, report definition documentation, version control, and release management is equally important. This position is also responsible for post-implementation support including incident, performance, capacity, continuity, and problem management activities.

Responsibilities

  • Develops and modifies reports using SAP Business Objects Crystal Reports, Business Intelligence and Reporting Tools (BIRT), and other data presentation tools.
  • Performs data analysis to verify report results against information source and user expectations.
  • Creates complex SQL queries, views, and stored procedures to create desired data structures.
  • Uses sub-reports to include related information not available in primary data set.
  • Creates and modifies business layers to allow users easy access to data on the reporting portal.
  • Creates and modifies data sources for relational databases, web services, active directory, file systems, MS Outlook, etc.
  • Ensures proper use of titles, headers, footers, charts, tables, graphics, and figures.
  • Performs unit, integration, functional, and regression testing.
  • Gathers and documents requirements from report sponsor.
  • Provides proof of concept analytical analysis on proposed dataset to report sponsor for verification.
  • Suggests alternatives to sponsor where consolidation can be used.
  • Prepares and updates report definition documents.
  • Maintains report version repository.
  • Estimates and records development time for report creation or modification.
  • Prepares and submits documentation to Change Advisory Board (CAB).
  • Administers report on Business Intelligence portal for Run On-Demand, Scheduling, and Email distribution.
  • Manages report portal distributional lists, folders, and user access.
  • Coordinates report deployments with sponsors, MIS staff, and CAB.
  • Develops a release package for all systems changes when transitioning to production environments.
  • Supports the resolution of incidents and problems with software application functionality.
  • Researches and corrects problems with the system applications code during production processing in an efficient and timely manner ensuring system recovery and integrity.
  • Executes and carries out IT continuity and disaster recovery plans as needed.
  • Monitors portal for report execution and distribution failures.
  • Maintains professional interaction with the application development staff, user and extended IT community (i.e. project teams) to ensure adequate system functionality, promote team participation, and encourage user confidence in MIS quality of service.

Requirements

  • A Bachelor's degree in management science, engineering management, computer science or related field; and
  • Three (3) years' experience developing Crystal Reports; and
  • Two (2) years' experience supporting enterprise applications with an N-tier architecture; and
  • One (1) year experience developing BIRT reports; and
  • A minimum of one year experience with an Asset/Maintenance Management system such as Maximo; or
  • Any equivalent combination of education or experience.

Nice-to-haves

  • Expertise in Business Intelligence and Reporting Tools (BIRT) skills are preferred.
  • Experience using Web Services and knowledge of database storage procedures.
  • Knowledge of programming languages such as .Net, Python or R, troubleshooting techniques, application server platforms, middleware, and operating systems.
  • Expertise in ORACLE, SQL Server, Tomcat, Eclipse IDE, SAP Business Intelligence Administration, and Maximo.

Benefits

  • Health insurance
  • Dental insurance
  • Vision insurance
  • 401k
  • Paid holidays
  • Paid time off
  • Professional development opportunities
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service