Reporting Analyst

Digest topic: Jobs & Internships


organization:Mercy Corps
position summary:

The Reporting Analyst creates, maintains and publishes reports on fundraising performance, constituent and gift analysis, and data mining/predictive modeling results. This position interviews key stakeholders on report requirements, retrieves data from multiple sources, produces reports and verifies the results before final publication. The Reporting Analyst helps ensure the reporting and analysis of critical marketing and fundraising data to help guide and support the RD team’s strategic decisions.

ESSENTIAL JOB FUNCTIONS: • Develop and maintain standardized reports using Microsoft SQL Reporting Services: create a suite of reports that are scheduled and delivered electronically or are available on-demand in a self-service environment for RD team members. • SQL development in a production environment: develop, test and document stored procedures, prepare detailed and comprehensive specifications for custom SQL stored procedures. • Interview stakeholders about reporting needs: work regularly with the Database Manager and other RD team members to identify existing and new reports; communicate with team members about report requirements; design, test and vet the final report results with relevant team members. • Establish and maintain a data warehouse as needed. • Work with the IT Team to maintain an optimal network operating environment for Raiser’s Edge and Blackbaud Direct Marketing; monitor SQL database performance. • Support the development of analytic and report-writing skills within the RD team, cross-train in essential functions. • Advise RD about the requirements (hardware, software and skill sets) necessary to meet growing analytical demands. • Other duties as requested or required.

Salary / Pay Rate:TBD
Required Skills and Abilities:KNOWLEDGE AND EXPERIENCE: • College degree in information management or computer science, or comparable experience. • At least 2 years experience working with Microsoft SQL Reporting Services to create customized reports, including multi-dimension reports with drill-down capabilities. • At least 2 years experience in database management, reporting development, data analysis, preferably in a non-profit fundraising environment. • Demonstrated technical competency with Microsoft SQL, including MS SQL Analysis Services. • Knowledge of Raiser’s Edge preferred. • Strong written and spoken communication skills; demonstrated ability to communicate effectively with team members of varied work styles. • Discretion with confidential materials required. SUCCESS FACTORS: A successful candidate will have the ability to work independently in a deadline-oriented team environment, with a strong commitment to teamwork and cross-training, be engaged, interested and communicative, willing to ask questions and understand the bigger picture while staying focused on the details. S/he will be capable of organizing and prioritizing multiple, competing tasks, and will bring a sense of curiosity and an investigative and analytical approach to data and fundraising strategies. An even temperament and good sense of humor, an awareness of and sensitivity to multi-cultural international development work and an interest in growing into a voice at the table guiding strategy and department direction will contribute to success in this position.
Qualifications:Apply at
Education Required:College degree
Other:Equal Opportunity Employer
website link: