Database Report Writer jobs in Massachusetts

Database Report Writer assists one or more business teams in understanding and utilizing data. Uses software and scripting, typically including SQL, to generate metrics and reports and synthesize them into actionable recommendations. Being a Database Report Writer may be responsible for management reporting, KPIs, or data QA. Provides support to research teams or management by collecting and analyzing data and reporting results based on the needs of end users. Additionally, Database Report Writer collaborates with various function teams such as marketing, research, and IT to achieve business results. Typically requires a bachelor's degree. Typically reports to a manager or head of a unit/department. The Database Report Writer occasionally directed in several aspects of the work. Gaining exposure to some of the complex tasks within the job function. To be a Database Report Writer typically requires 2-4 years of related experience. (Copyright 2024 Salary.com)

M
Report Writer
  • Massachusetts Water Resources Authority
  • Chelsea, MA FULL_TIME
  • 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!

    - https://www.mwra.com/02org/html/benefits.htm

    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.

  • 13 Days Ago

U
Report Writer Student Admnistrator
  • UMass Boston
  • Boston, MA FULL_TIME
  • General Summary: The Report Writer, Student Administration is responsible for running and providing system reporting for the Registrar's Office. Working with the Summit Reporting System (and other sys...
  • 14 Days Ago

U
Report Writer Student Admnistrator
  • University of Massachusetts Boston
  • Boston, MA FULL_TIME
  • Job no: 522563 Position Type: Staff Full Time Campus: UMass Boston Department: Registrar's Office Pay Grade: 31 Date opened: 07 Mar 2024 Eastern Standard Time Applications close: 28 Mar 2024 Eastern D...
  • 15 Days Ago

D
Senior Account Executive
  • Database USA
  • Wakefield, MA FULL_TIME
  • LocatePlus is a leading provider of investigative databases. We are looking for an account executive with knowledge of software sales with a track record of great client service. The ideal candidate w...
  • 9 Days Ago

D
Marketing and Advertising Specialist
  • Database USA
  • Wakefield, MA FULL_TIME
  • LocatePlus, is looking for an advertising assistant who can lead our digital marketing and other advertising programs. Knowledge of Google, PPC and SEO tools, and some knowledge of email marketing and...
  • 9 Days Ago

B
Report Developer
  • Boston College
  • Chestnut Hill, MA FULL_TIME
  • Boston College IntroductionFounded in 1863, Boston College is a Jesuit, Catholic university located six miles from downtown Boston with an enrollment of 9,484 full-time undergraduates and 5,250 gradua...
  • 8 Days Ago

C
Director of Grants
  • Career Blazers Nonprofit Search
  • Chicago, IL
  • Director of Grants Chicago, IL Hybrid Position Overview Be a part of a nonprofit organization dedicated to improving the...
  • 3/29/2024 12:00:00 AM

A
Credit Manager
  • Arizona Tile
  • Tempe, AZ
  • Arizona Tile is currently seeking a Credit Manager to be based in our Tempe location. In this position, you will work cl...
  • 3/29/2024 12:00:00 AM

T
Proposal Manager/Tech Writer
  • TCI International, Inc.
  • Fremont, CA
  • At SPX Corporation, what’s in it for employees goes well beyond market-competitive compensation and benefits. Our Total ...
  • 3/29/2024 12:00:00 AM

V
Workday Integration Analyst
  • Vaco
  • Cincinnati, OH
  • Vaco has partnered with one of the nation's largest providers of post-acute care in their search for a Workday Integrati...
  • 3/29/2024 12:00:00 AM

W
Legal Brief Writer
  • Wisner Baum
  • Location: Hybrid and Remote Department: Mass Tort – Class Action Reports to: Managing Partner Position Type: Full Time E...
  • 3/29/2024 12:00:00 AM

C
UKG Consultant
  • Coda Search│Staffing
  • ON SITE 5 DAYS PER WEEK! The HRIS Systems Administrator serves as the technical point of contact and UKG HRIS system sub...
  • 3/29/2024 12:00:00 AM

J
Database Administrator
  • Judson Independent School District
  • San Antonio, TX
  • Job Description Job Description ***Interested Applicants need to visit the Judson ISD website (www.judsonisd.org) and co...
  • 3/27/2024 12:00:00 AM

A
Report Writer
  • Akkodis
  • We are seeking a Database Report Writer in Palm Beach, Florida. This is a contract to hire opportunity that will by hybr...
  • 3/25/2024 12:00:00 AM

Massachusetts is the 7th-smallest state in the United States. It is located in the New England region of the northeastern United States and has an area of 10,555 square miles (27,340 km2), 25.7% of which is water. Several large bays distinctly shape its coast. Boston is the largest city, at the inmost point of Massachusetts Bay, and the mouth of the Charles River. Despite its small size, Massachusetts features numerous topographically distinctive regions. The large coastal plain of the Atlantic Ocean in the eastern section of the state contains Greater Boston, along with most of the state's po...
Source: Wikipedia (as of 04/11/2019). Read more from Wikipedia
Income Estimation for Database Report Writer jobs
$78,167 to $104,186

Database Report Writer in Gastonia, NC
This position is responsible for writing programs and reports in order to support University development activities.
February 15, 2020