MWRA

Report Writer

Chelsea, MA

The MWRA is looking for a Report Writer who 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.

The work includes: 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.

This position requires a bachelor's degree in management science, engineering management, computer science or related field; 3 years' experience developing Crystal Reports; 2 years' experience supporting enterprise applications with an N-tier architecture; 1 year experience developing BIRT reports; minimum of one year experience with an Asset/Maintenance Management system such as Maximo.

Expertise in Crystal Reports development skills required. Business Intelligence and Reporting Tools (BIRT) skills are preferred; ability to write complex SQL statements including multi-table joins, outer joins, pivot result sets, and hierarchical queries from an enterprise relational database (e.g. Oracle or SQL Server); strong knowledge of database tables, views, triggers, stored procedures, and other structures; experience using Web Services and knowledge of database storage procedures; experience and understanding of Software Development Life cycle; knowledge of programming languages such as .Net, Python or R, troubleshooting techniques, application server platforms, middleware, and operating systems; expertise in the following is preferred: ORACLE, SQL Server, Tomcat, Eclipse IDE, SAP Business Intelligence Administration, and Maximo.

Information Technology Infrastructure Library (ITIL) Foundation v3 Certification is required or the ability to obtain within twelve months.

Salary: $67,529.80 to 103,332.84 Annually.

TO VIEW OUR BENEFITS PLEASE CLICK ON THE LINK! - https://www.mwra.com/02org/html/benefits.htm

Apply at: https://mwra.applicantpro.com/jobs/

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, genetics, or veteran status.