• Heritage Action
  • Heritage Libertad
  • More

Senior Data Analyst

This position ensures that data structures and implementation of Blackbaud CRM supports the ongoing needs of The Heritage Foundation including all reporting systems and interfaces with 3rd party systems.

Job Duties:

  • Analyze tables in Blackbaud CRM to establish knowledge of data for accurate retrieval and use in report writing.
  • Utilize SQL Server Reporting Services (SSRS) to provide reports for departments’ needs.
  • Provide comprehensive analysis utilizing a variety of enterprise-wide applications including querying and report writing tools.
  • Develop, test, implement, maintain and troubleshoot stored procedures that are used for existing or newly created reports.
  • Collaborate with end users to gather report requirements and ensure proper testing and validation. Provide support to end users on standardized and ad hoc reports.
  • Understand existing data structures and business logic for development of direct marketing segmentations through SQL Server Integration Services (SSIS) process.
  • Understand existing data structures and business logic for SSIS.
  • Provide technical support for all report applications.
  • Work with the Database Administrator implementing new processes and systems which integrate with Blackbaud CRM’s database. 
  • Provide reports to various departments requesting information from the Raiser’s Edge database using the Query, Export and Report modules. 
  • Other duties as required and assigned by Director of Online Communications.

  • Job Type: 

  • Education:

    Requires a BA/BS. Coursework in related fields preferred.
  • Experience:

    2-3 years experience with database report writing software required. Candidate should have a working knowledge of Blackbaud CRM and/or the Raiser's Edge application.
  • Skills:

    • Excellent communication and customer service skills are essential.
    • Familiarity with Relational Databases and like SQL Server strongly desired.
    • Report writing expertise' extensive knowledge of reporting writing development and support utilizing SSRS (Analyze, Design, Create, and Automate).