Data Segmentation Specialist

About CRS

Catholic Relief Services is the official international humanitarian agency of the Catholic community in the United States. CRS works to save, protect, and transform lives in need in more than 100 countries, without regard to race, religion, or nationality. CRS’ relief and development work is accomplished through programs of emergency response, HIV, health, agriculture, education, microfinance, and peacebuilding.

Job Responsibilities:

The Data Segmentation Specialist will manage and analyze database details for the successful implementation of CRS’ renewal, sustainer, mid-level, acquisition, and special fundraising projects. Data upload across systems, duplicate record resolution across all systems.

Responsibilities include data analysis, data integrity management, data mining for donor segmentation, internal reporting, vendor support and other data fundraising projects as needed.

• Creation and/or tuning of any SQL-based queries for use in the Donor Database reporting tools (JasperSoft, ClearView, Sales Force, SQL Query tool, etc.) to estimate record counts, data quality checks or to support ad hoc marketing analysis.
• Maintain baseline configuration and compliance standards and level of manageability through established recurrent on-going data integrity activities.
• Use industry best practices to execute the selects and segmentation within CRS’ relational database for multichannel direct marketing campaigns.
• Manage internal clients’ requests and answer questions involving marketing lists, reports, labels, etc., in a timely manner.
• Create documentation of business decisions related to file orders and segmentation such as suppressions, inclusions, and other data-driven components. Include tools used in database such as queries and parameters.
• Analyze, interpret, and effectively communicate database(s) report findings to refine and enhance direct response activities and support/inform the planning and resource allocation process.
• Identifying opportunities for workflow automation and develop automation within the endpoint management platform to increase efficiencies and decrease delivery time.
• Work with Team to ensure data accuracy and integrity across all systems.
• Interface with other technical team members, internal and external, to establish internal reporting requirements, segmentation standards and overall data integrity.
• Ensure the donor database is updated accurately and consistently from various sources such as lockbox vendor, web vendor, market research vendors, etc. This includes NCOA files and acquisition lists.
• Create, upload and update the numerous mailings, web, event, etc., campaign and appeal codes in the donor database.
• Successfully execute the running of the private donor acknowledgment program.
• Support the Donor Portal and troubleshoot any issues.
• Work with 3rd party vendors to supply data as needed.
• Service Now Ticket monitoring.
Serve as the primary backup to many of the functions of the Donor Database Manager, including but not limited to:

• 
  
  
  • Creating of codes across all systems
  • Testing processes across all systems
  • Assisting with configuring surveys (Donor Voice)
  • Ability to troubleshoot issues for donor database users
  • Detailed knowledge of data stored
• Additional duties as assigned.

This is a remote position with the possibility of traveling to HQ a couple of times a year.

Key Working Relationships: (Key positions and departments needed to work with in order to accomplish the job.)

Internal: Charitable Giving, MarCom, M2

External: Vendors

Agency-wide Competencies (for all CRS Staff)

These are rooted in the mission, values, and guiding principles of CRS and are used by each staff member to fulfill his or her responsibilities and achieve the desired results.

• Integrity
• Continuous Improvement & Innovation
• Builds Relationships
• Develops Talent
• Strategic Mindset
• Accountability & Stewardship

Personal Skills: (Key skills necessary to accomplish job such as communications skills, interpersonal skills, decision-making skills, knowledge skills and the ability to work independently.)

• Strong analytical skills
• Excellent communication skills
• Strong critical thinking skills
• Great attention to detail
• Excellent math skills
• Team player with the ability to work well with all levels of staff
• Exceptional quantitative, analytical, and problem-solving skills
• Effective at multitasking, establishing priorities and providing high-quality, detail-oriented products while meeting deadlines
• Ability to take initiative and make judgments independently

Qualifications: (Requirements expected to fulfill the needs of the position such as education, training, years of experience, licenses, etc.)

• Bachelor's degree in related field or work experience equivalent; mathematics-related discipline is preferred.
• 1–2 years of experience writing SQL queries
• 1–2 years of experience using relational database applications along with various database reporting tools, desktop computer software including Microsoft Windows and Microsoft Office
• Direct response marketing background with working knowledge of nonprofit fundraising communications programs and techniques is beneficial.

SPECIAL REQUIREMENT

Due to the concentration of activity at year-end, there is a limit on PTO during our busy season which is from the end of September-beginning of October and December-January of each year.

What we offer

CRS offers a comprehensive benefits package including medical, dental, life insurance, vision, a generous retirement savings plan, and the opportunity to work in a collaborative, mission-driven culture committed to improving the lives of the poor worldwide.

***Our Catholic identity is at the heart of our mission and operations. Catholic Relief Services carries out the commitment of the Bishops of the United States to assist the poor and vulnerable overseas. We welcome as a part of our staff people of all faiths and secular traditions who share our values and our commitment to serving those in need. CRS’ processes and policies reflect our commitment to protecting children and vulnerable adults from abuse and exploitation.

Disclaimer: This job description is not an exhaustive list of the skill, effort, duties, and responsibilities associated with the position.

CRS' talent acquisition procedures reflect our commitment to protecting children and vulnerable adults from abuse and exploitation.