Database Analyst

POSITION TITLE: Database Analyst
DEPARTMENT: Membership
REPORTS TO: Director, Data Management
STATUS: Regular, Full-Time, Non-Exempt
LOCATION: Costa Mesa, CA
COMPENSATION: Commensurate with Experience
BENEFITS: Medical Insurance, Dental Insurance, Vision Insurance, Life Insurance, Retirement Plan and Professional Development opportunities

Work With Purpose!

Public Media Group of Southern California (PMGSC) is looking for a talented professional to join our diverse and growing organization. If you enjoy working with database systems, performing data analytics, and developing systems and procedures, then send your cover letter and resume to hr@pmgsocal.org today!

About Public Media Group of Southern California (PMGSC)

Public Media Group of Southern California (KCET, PBS SoCal and LINK TV) tell stories that matter through original programs that reflect the diversity of the region, and the full schedule of trusted PBS programs. Our content channels –KCET and PBS SoCal– are available for free on internet-connected screens and seven local broadcast channels. LINK TV can be accessed through national satellite channels.

A donor-supported community institution, PMGSC sparks the sharing of ideas at cultural events and community conversations and delivers social impact through services that prepare our most vulnerable children for school.

JOB OVERVIEW

Reporting to the Director, Data Management, the Database Analyst will assist with managing the CRM systems and work cross-departmentally on data analytic projects.

Database Processing

  • Manage and maintain constituent information and data files in CRMs (primarily Raiser’s Edge NXT and Luminate Online).
  • Review, correct and update transactional data regularly (ie. chargebacks and non-sufficient funds)
  • Assist with the RENXT implementation and support staff as they learn the new systems and procedures.
  • Create and run queries for membership, advancement, marketing , LINK TV and digital
  • Import data from partner organizations and perform quality control and list
  • Insure all data remains secure and processes follow PCI compliance and PMGSC security

Reconciliation and Quality Control

  • Ensure the database is continuously optimized for accurate reporting while managing data accuracy and integrity
  • Maintain quality control processes and keep documentation updated
  • Responsible for Cash Receipt Advice documentation and monthly reconciliation with finance department

QUALIFICATIONS

  • Bachelor’s degree; Accounting, Business Administration, Computer Science/ Information Systems, or comparable experience
  • 2+ years of CRM system experience or equivalent experience and an understanding of database concepts, application, and
  • Familiarity with Blackbaud products: RENXT, Luminate Online, Financial Edge, Import
  • Demonstrates motivational and problem-solving capabilities with a high degree of integrity, ethics, and dedication to the mission of Public Media Group of Southern California
  • Fundraising or membership experience preferred
  • Attention to detail

Equal Opportunity Employer

PMGSC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

To apply, please submit your cover letter and resume to hr@pmgsocal.org.