 |
 |
|
|
| Position Title: |
|
Database & Report Specialist |
| Department: |
|
Membership |
| Reports To: |
|
Senior Director of Membership |
| Grade: |
|
17 |
| Status: |
|
Full-time, Non-Exempt |
| Date: |
|
April, 2008 |
|
|
| Summary: |
Responsible for the creation and/ or generation of all database analysis reports, segmentation, and other project reports relating to material contained in the WNED Membership Database (currently Allegiance). This includes, but is not limited to, direct mail segmentation pulls (routine and advanced segments) for all Development areas (Membership, Major Gifts, and Special Events); single project reports (Direct Marketing campaigns, Pledge, Fundraising Event ticket sales, & Telemarketing efforts); premium history report creation & generation for all on-air fundraising activities; premium order tracking reports (vendor orders); premium fulfillment tracking reports (UPS membership fulfillment); and other duties as assigned. |
|
|
|
|
| Duties and Responsibilities: |
|
Monthly % Time Spent |
|
Reports & Segmentation
- Work with Senior Director of Membership to determine (and then generate) segmentation pulls for all Direct Mail campaigns (& Telemarketing efforts, if applicable).
- Work with Senior Director of Membership & VP of Development to generate pledge drive analysis reports.
- Monitor and generate single project reports for Major Gifts department.
- Generate Fundraising Event ticket sales reports as needed.
|
|
|
60% |
|
Premium Tracking
- Coordinate with Membership Manager to create (and regularly generate) a vendor tracking report for all premium orders used during on-air pledge drives (TV & Radio). This includes reconciliation for what is ordered from each vendor, what is fulfilled, and the backorder & reorder status of same.
- Coordinate with Membership Manager to create (and regularly generate) a premium item fulfillment report for all items shipped to and from the WNED designated warehousing and fulfillment center (currently, UPS). This includes reconciliation for which items are delivered to the fulfillment house, the number of units delivered for each item, units shipped to members, and backorder & recorder status needs for items.
- Update of membership database as necessary to keep member records in sync with premium fulfillment status.
|
|
|
20% |
|
Capital Campaign close out:
- Prepare daily cash receipts and EFT transactions.
- Prepare, balance and reconcile bathes for data entry. Sort & key bank bags.
- Modify member records as needed.
- Generate monthly installment payment reminders. Prepare end of month close-out report.
- Process monthly charges.
- Process monthly expiration date and annual reminder mail merge and mailing. Maintain write-off report.
|
|
|
15% |
|
| Miscellaneous duties as assigned |
|
5% |
|
|
| Qualifications and Education Required: |
|
- Computer skills required, with strong background in report generation and data management.
- Ability to multi-task and complete projects with strict deadlines in a timely fashion.
- Ability to work well with a variety of personality types.
- Good analytical ability
- College Degree preferred
|
|
| Please send cover letter and resume to: |
Fran Lipani
Director of Human Resources
WNY Public Broadcasting Association
Horizons Plaza
P.O. Box 1263
Buffalo, NY 14240-1263 |
|
| Back |
|
|
