Demo

Massachusetts Water Resources Authority is hiring: Report Writer in Chelsea

Massachusetts Water Resources Authority
Chelsea, MA Full Time
POSTED ON 1/16/2025
AVAILABLE BEFORE 3/31/2025

Job Description

Job Description

POSITION : Report Writer

DIVISION : Administration

DEPARTMENT : Management Information Systems (MIS)

UNION / GRADE : Unit 6 / Grade 10

TO VIEW OUR BENEFITS PLEASE CLICK ON THE LINK!

BASIC PURPOSE :

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.

SUPERVISION RECEIVED :

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

SUPERVISION EXERCISED :

None.

ESSENTIAL DUTIES AND RESPONSIBILITIES :

Report Development

  • 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.

Requirements Gathering, Documentation, and Version Control

  • 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.
  • Release Management

  • 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.
  • Post-Implementation Support

  • 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.
  • Mentoring & Professionalism

  • 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.
  • SECONDARY DUTIES :

  • Performs related duties as required.
  • Serve as backup to developers.
  • MINIMUM QUALIFICATIONS :

    Education and Experience :

  • 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.
  • Necessary Knowledge, Skills and Abilities :

  • 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.
  • Analytical skills and detail oriented.
  • Excellent written and oral communication skills.
  • SPECIAL REQUIREMENTS :

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

    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.

    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.

    Job Posted by ApplicantPro

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Massachusetts Water Resources Authority is hiring: Report Writer in Chelsea?

    Sign up to receive alerts about other jobs on the Massachusetts Water Resources Authority is hiring: Report Writer in Chelsea career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $111,487 - $161,520
    Income Estimation: 
    $122,633 - $166,569
    Income Estimation: 
    $116,413 - $176,962
    Income Estimation: 
    $129,120 - $252,029
    Income Estimation: 
    $133,900 - $199,666
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $115,719 - $153,093
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $120,390 - $162,969
    Income Estimation: 
    $88,359 - $121,264
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $176,131 - $238,730
    Income Estimation: 
    $172,979 - $241,697
    Income Estimation: 
    $65,674 - $90,812
    Income Estimation: 
    $74,161 - $98,561
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $88,359 - $121,264
    Income Estimation: 
    $113,076 - $148,099
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Massachusetts Water Resources Authority

    Massachusetts Water Resources Authority
    Hired Organization Address Southborough, MA Intern
    BASIC PURPOSE: Massachusetts Water Resources Authority operates and maintains waterworks infrastructure that includes tw...
    Massachusetts Water Resources Authority
    Hired Organization Address Winthrop, MA Full Time
    POSITION: Labor Relations Specialist DIVISION: Administration DEPARTMENT: Human Resources UNION/GRADE: Confidential Unit...
    Massachusetts Water Resources Authority
    Hired Organization Address Chelsea, MA Full Time
    Job Description Job Description DIVISION : Administration DEPARTMENT : Management Information Systems (MIS) UNION / GRAD...
    Massachusetts Water Resources Authority
    Hired Organization Address Winthrop, MA Full Time
    As a Senior Counsel for Labor and Employment at the Massachusetts Water Resources Authority (MWRA), you will play a crit...

    Not the job you're looking for? Here are some other Massachusetts Water Resources Authority is hiring: Report Writer in Chelsea jobs in the Chelsea, MA area that may be a better fit.

    Report Writer Job at Massachusetts Water Resources Authority in Chelsea

    Massachusetts Water Resources Authority, Chelsea, MA

    Labor Relations Specialist

    Massachusetts Water Resources Authority, Winthrop, MA

    AI Assistant is available now!

    Feel free to start your new journey!