Community Foundation of Western Mass.-posted 2 months ago
Springfield, MA
11-50 employees

The Data Systems Analyst evaluates organizational and departmental needs related to systems and data, gathers requirements, researches, and partners with departments to implement and test the deployment of systems and solutions to improve business processes at CFWM and maintains software and databases. This position is responsible for creating, auditing and maintaining data integrity standards for CFWM and utilizing data to support decision making and ongoing work. The data systems analyst supports the implementation of a data culture that supports the overall organizational goals and priorities. This role also supports the Foundation’s commitment to trust-based philanthropy by ensuring our data and analysis amplify community voice, foster transparency, and meaningfully assess the impact of our grantmaking in partnership with the communities we serve. Maintains software and databases and supports technology and software training opportunities. All activities are developed and implemented in alignment with the Foundation’s overall strategic priorities including diversity, equity, and inclusion.

  • Develop, create and maintain a data culture that supports the data needs of the organization and encourages staff ownership of data and processes.
  • Create, design and maintain an integrated staff general Foundant training and onboarding program.
  • Maintain a high-level understanding of overall system processing, relationships and reporting aspects of core database applications (Foundant).
  • Trouble-shoot errors and problems, support report creation, support cross system file imports/exports for all departments using advanced database tools and complex query statements.
  • Manage, support and participate in the Foundant Admin Team who will monitor, review and implement data processes, data migration, data exports and reporting needs.
  • Collaborate with Admin Assistant in support of existing Microsoft software solutions.
  • Co-lead with departments process requirements gathering and translate the requirements to software, database and reporting solutions.
  • Develop workflow/process maps for transition from current to future landscape for existing and proposed business initiatives.
  • Develop in depth familiarity with integration points across the organization to help standardize processes and tools for CFWM activity.
  • Collaborate with Community Impact team to analyze grant outcomes to measure community impact across funded initiatives.
  • A degree in IT / Computer Science, Information Management or equivalent experience.
  • 5-7 years proven experience as a data analyst or business/systems analyst.
  • Proven experience in eliciting requirements and testing.
  • Proven experience in analyzing data to draw business-relevant conclusions.
  • Proven experience with relational databases including SQL Server, direct experience with database application configuration.
  • Experience in generating process documentation.
  • Project Management of software implementations.
  • HTML coding preferred.
  • Experience with Foundant or Blackbaud products preferred.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service