CRM Data Specialist

Requisition ID:  req39769

Job Title:  CRM Data Specialist

Sector:  Information Technology

Employment Category:  Fixed Term

Employment Type:  Full-Time

Compensation:  USD 86, - 95,;Salary

Location:  New York, NY HQ USA

Job Description

The IRC
The International Rescue Committee (IRC) responds to the world’s worst humanitarian crises and helps people to survive and rebuild their lives. Founded in 1933 at the request of Albert Einstein, the IRC offers lifesaving care and life-changing assistance to refugees made to flee from war or disaster. At work today in over 40 countries and 28 cities, we restore safety, dignity and hope to millions who are uprooted and struggling to endure. The IRC leads the way from harm to home.

This position will sit within the Marketing Technology department. Marketing Technology is responsible for supporting the IRC’s mission and key business strategies by creating best-in-class digital solutions that manage audience data, derive insights, inspire deeper engagement, and convert supporters. These responsibilities include the management of enterprise CRM platform, web, donation platforms, and communications platforms.
Job Overview / Summary (What and Why):
This is a great opportunity for a dynamic and passionate individual to join our CRM Audience Management team to help develop and grow the Audience data quality to ensure the organization is reaching every one of its targets. The CRM Data Specialist is responsible for quality assurance and stewardship of data received from ever an increasing number of sources, both external and internal. S/he will be tasked with planning, designing, and executing data quality routines; and proactively monitoring, measuring, analyzing, and reporting on data quality issues to the organization. The development of protocols, creating and implementing monitoring procedures to monitor and ensure data quality and standardization, and suggesting process improvements will all be essential parts of this roll. The CRM Data Specialist will provide ongoing support, training, and documentation to multiple global teams, helping them to capture and extract high quality information for analytical decision making from IRC's systems.

As CRM Data Specialist you will perform hands-on technical implementation, with a focus on administering and delivering functional solutions on IRC’s backend data extracted from the CRM systems. You will be involved in the design, implementation, deployment, and documentation of projects that leverage the , ETL, and SQL toolset.In this role you support global External Relations Department’s business systems and processes, ensuring they are aligned and continuously improved to meet business needs as they change.Drawing on technical skills, critical thinking, problem solving, and creativity, you will implement new solutions and/or troubleshoots issues. You will work with a wide range of key stakeholders and staff to translate business requirements into sophisticated systems and reporting solutions.You’ll be dynamic, self-motivated and will have the technical savvy to inspire and provide technical edge to business users and department to meet their goals.
Major Responsibilities: Support the assessment and resolution of Salesforce cases Assist with Salesforce support and specific enhancement projects  Identify, assess, monitor, document, and communicate potential quality issues and provide efficient solutions for the back-end database and Salesforce CRM. Evaluate system performance and design, as well as its effect on data quality. Runn data queries to identify coding issues and data exceptions, as well as data cleansing. Participate in design of Excel VBA and SQL back end. Build and automate data quality controls and master data management operations. Support CRM business process automation projects and data optimization projects. Collaborate with database developers to improve data collection and data reporting. Develop advanced data capture, quality control and fulfilment processes using advanced Salesforce processes/flows, reports/dashboards, Excel VBA/macros, and basic SQL processes. Participate in special projects as needed. Play SME and product owner for select applications, tools, and plug-ins within the CRM stack.  Provide technical/admin support and advanced troubleshooting for end users Perform complex data analysis/management tasks and provide support for related data warehouse infrastructure (SQL databases, scheduling and ETL tools, and key integrations). Perform unit testing and defect fixes. Build productive relationships with cross-functional stakeholders and business owners. Communicate proactively and frequently and modify technical information as needed so that it can be understood by stakeholders to enable their decision-making. Key Working Relationships:  Position Reports to: Director, Marketing TechnologyPosition directly supervises: None Indirect Resources: Collaborates with other staffers on cross-functional development and project teams.Other Internal and/or external contacts: Internal: Close collaboration with global colleagues working in the areas of CRM, digital technology, and analytics across External Relations, IT and Communications teams.External: May collaborate with external digital vendors and consultants.Impact of work: Supports IRC’s ability to generate digital donations in excess of $60 million annually, measure and improve on data management, and deliver of segmentation and reporting for fundraising, and policy initiatives to expand the IRC’s impact, brand awareness and to generate revenue.
Job Qualifications:  Education:  Minimum: Associate’s Degree Preferred: Bachelor’s degree in Computer Science, Information Technology or Engineering or equivalent experience.
Work Experience:  Minimum:  5+ years hands on with Data Management or Data Quality Significant demonstrable professional work experience with CRM and relational databases (non-profit experience a plus) and IT delivery, IT services, and professional services environments. Experience creating basis for data CRM quality checks. Proficiency in programming languages, MSSQL queries and with DBAmp. Exceptional analytical and problem-solving skills. Accuracy and attention to detail a must; sensitivity when working with highly confidential information and ability to always maintain complete discretion. Proven ability to plan and independently manage a variety of projects and high work volume: must work well under pressure, prioritize, show flexibility, and solve problems creatively. Experience with creating views, stored procedures, and functions. SQL database experience using T-SQL, query performance tunings, database development, implementation, data manipulation and complex custom reports, and underlying data models. Excellent oral and written communication, interpersonal skills, ability to communicate technical issues to non-technical audience. Strong customer service orientation Preferred: NPSP Salesforce experience.Experience with MSOffice VBA.Experience in ETL Design sessions.Experience in supporting fundraising applications for non-profit organizations.Experience in working effectively with an Agile delivery model.Experience with web services or application programming interfaces is a great plus;Experience in implementing business intelligence and data warehouse solutions.
Licenses or Certifications:  None required
Language Skills: English Fluency
Working Environment (Optional): Remote
COVID-19 Vaccination Requirement:  In accordance with IRC’s duty to provide and maintain a workplace that is free of known hazards and our commitment to safeguard the health of our employees, clients, and communities, IRC requires new hires to furnish proof of vaccination against COVID-19 in order to be considered for any in-office or hybrid positions. All IRC US offices require full vaccination to attend any in-office functions (, meetings, trainings).
Commitment to Diversity and Inclusivity:  IRC is committed to building a diverse organization and a climate of inclusivity. We strongly encourage applications from candidates who can demonstrate that they can contribute to this goal.