CRM Data Specialist

Background: 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 handle 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 Integrations & Automations team to help develop and grow the Audience data quality to ensure the organisation is reaching every one of its targets. The Data Specialist is responsible for quality assurance and stewardship of data received from ever an increasing number of sources, both external and internal. They will be tasked with planning, designing, and completing data list pull and upload routines; and proactively monitoring, measuring, analysing, and reporting on large data quality issues to the organisation.

The development of protocols, creating and implementing monitoring procedures to ensure data quality and standardisation, and suggesting process improvements will all be crucial parts of this roll. The 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 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 use 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 the team’s goals as they change.

Drawing on technical skills, critical thinking, problem solving, and creativity, you will implement new solutions and/or solves issues. You will work with a wide range of key partners 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:

• Perform Data List Pulls from Salesforce using Azure MSSQL based on stakeholder or vendor requirements.
• Extract, transform, and load (ETL) data from vendor sources such as SFTP or portals into Azure MSSQL and subsequently into Salesforce using DBAmp.
• Design, implement, and maintain data upload workflows to ensure seamless integration from external sources into the database and Salesforce.
• Develop and automate recurring data processing operations to optimise efficiency.
• Create, maintain, and update Excel VBA templates for partners, ensuring usability and alignment with project requirements.
• Collaborate with partners to refine templates and provide sophisticated and strategic support.
• Monitor and enhance database performance and design to support operational efficiency.
• Identify and resolve data inconsistencies, errors, and exceptions using sophisticated SQL queries and strong analytical thinking.
• Work closely with cross-functional teams to deliver solutions that meet business needs.
• Act as a subject matter expert for database processes, data handling, and automation tools.
• Conduct unit testing to validate data workflows, troubleshoot defects, and implement necessary fixes.
• Document processes, workflows, and resolutions to maintain a knowledge base for future reference.
• Build productive relationships with internal partners and vendors to align on data requirements and project goals.
• Communicate proactively to provide updates, resolve challenges, and deliver technical/admin support.
• Review, assess, and resolve database-related Salesforce cases submitted by partners.
• Provide technical support and solutions addressing data pull/upload issues, automation challenges, and other Salesforce data handling needs.

Key Working Relationships:

• Position Reports to: Associate Director, Integrations & Automations
• Position directly supervises: None
• Indirect Resources: Collaborates with other staffers on multi-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 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 including data extraction, transformation, and loading (ETL).
• 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 database structures and implementing quality checks to ensure CRM data integrity.
• Hands-on experience with creating database objects such as views, stored procedures, and functions.
• Advanced knowledge of SQL database development, query performance tuning, and sophisticated data manipulation.
• Proficiency in programming languages, MSSQL queries and with DBAmp for Salesforce data integration.
• Exceptional analytical and problem-solving skills with attention to detail and data accuracy.
• Ability to independently handle multiple projects and high workloads while meeting deadlines.
• Excellent oral and written communication skills, with the ability to translate technical concepts for non-technical audiences.
• Strong customer service orientation with a proactive approach to partner collaboration.

Preferred:

• Experience with Salesforce NPSP (Nonprofit Success Pack)
• Sophisticated knowledge of MS Office VBA for process automation and template creation.
• Hands-on experience with ETL design sessions and workflows.
• Experience in supporting fundraising applications for non-profit organisation.
• Experience in working optimally with an Agile delivery model.
• Experience with web services or application programming interfaces a plus;
• Experience in implementing business intelligence and data warehouse solutions.

Licenses or Certifications: None required

Language Skills: English Fluency

Working Environment: Remote

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.

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 $143 per month, dental starting at $6.50 per month, and vision starting at $5 per month, FSA for healthcare and commuter costs, a 403b retirement savings plans with immediately vested matching, 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.