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 U.S. 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 Salesforce.com, 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 Technology
Position 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 (e.g., 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.
Equal Opportunity Employer:
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
US Benefits:
We offer a comprehensive and highly competitive set of benefits. In the US, these include: 10 sick days, 10 US holidays, 20-25 paid time off days (depending on role and tenure), medical insurance starting at $145 per month, dental starting at $7 per month, and vision starting at $5 per month, FSA for healthcare, childcare, and commuter costs, a 403b retirement savings plans with up to 4.5% immediately vested matching contribution, plus a 3-7% base IRC contribution (3 year vesting), disability & life insurance, and an Employee Assistance Program which is available to our staff and their families to support counseling and care in times of crisis and mental health struggles.
Compensation:
Posted pay ranges apply to US-based candidates. Ranges are based on various factors including the labor market, job type, internal equity, and budget. Exact offers are calibrated by work location, individual candidate experience and skills relative to the defined job requirements.
