Job Description

Category : IT Data Analyst

Location/City : MA - Springfield

The Business/System Analyst evaluates organizational and departmental needs, gathers requirements, researches, and implements and tests the deployment of systems and solutions to improve business processes and maintains software and databases.

This position is responsible for creating, auditing and maintaining data integrity standards and for managing technology and software training opportunities.

Primary Responsibilities

  1. Supports existing software solutions while participating in the evaluation and implementation of new software services by identifying key business processes, operations, and functions to promote effective & consistent delivery of software and workflow to support the organizations work.

  1. Leads business process requirements gathering and collaborates with staff to translate the requirements to software, database and reporting solutions, through software research and implementation (with the help of outside consultants on an as needed basis) and works with staff to identify and implement an accurate, timely, efficient and transparent workflow.

  1. Develop workflow/process maps for transition from current to future landscape for existing and proposed business initiatives, including advocacy of best practices and potential re-engineering.

4. Trouble-shoot errors and problems, create reports, execute cross system file imports/exports for all departments using advanced database tools and complex query statements. Oversee system processing, relationships and reporting aspects of core database applications (FIMS, Gifts Online, Donor Central, Smarter Select, Access & CRM)

  1. Create and oversee process to collect, manipulate and analyze data and systems to guard and protect data integrity, making sure that the core database applications produce consistent, reliable, reusable data by monitoring, reviewing and auditing new and existing data, data migration, data exports and reports. Identify security vulnerabilities and eliminate them with strategic solutions that increase data safety

  1. Design, develop, document and maintain clear, written protocols and processes in a manual format and communicate and meet regularly with staff to assure their knowledge and effectiveness in carrying out these procedures. In combination with the IT Manager and Sr. Staff, develop, create and maintain an integrated staff general IT training program as well as software and department specific end user training opportunities.

  1. Develop in depth familiarity with integration points (i.e. peripheral software systems) and processes across organization to help standardize processes and tools for activity and provide technical assistance to trouble shoot software and process challenges related to the implementation of software tools

Other Responsibilities

Backs up IT Manager

Help desk and workstation/desktop support

Participate in the development and administration of the technology budget

Occasional night and/or weekend work may be required

Maintain confidentiality in communications, both written and oral

Other duties as required or assigned

Occasional attendance at events outside work hours



A degree in IT / Computer Science, Information Management or equivalent experience


Proven experience as a data analyst or business/systems analyst

Proven experience in eliciting requirements and testing

Experience in analyzing data to draw business-relevant conclusions

Extensive experience with relational databases including SQL Server, direct experience with database application configuration

Solid experience in writing SQL queries, extensive Access expertise

Experience in generating process documentation

Project Management of software implementations

HTML coding

Experience with Blackbaud/Microedge products (Donor Central, Gifts onLine, FIMS) preferred


Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

Strong written and verbal communication skills along with facilitation, prioritization, and scope management

Ability to set and revise procedures while facilitating buy-in from stakeholders

Demonstrated capacity to frame complex situations and present options

Robust collaboration and problem-solving skills to support operational best practices.

Adept at queries, report writing and presenting findings

Technical expertise regarding data models, database design development, data mining

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online