110 applicants

Company

International Rescue Committee · 9 hours ago

CRM Data Specialist

New York, NY

Full-time

Remote

Mid, Senior Level

5+ years exp

Maximize your interview chances

Non Profit

H1B Sponsor Likely

Insider Connection @International Rescue Committee

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data ManagementETLSQLSalesforceCRMData Quality AssuranceDatabase StructuresData IntegrationMSSQLDBAmpMS Office VBAAgile DeliveryBusiness IntelligenceData Warehouse SolutionsEnglish FluencyCustomer Service Orientation

Required

Minimum: Associate’s Degree

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

Bachelor’s degree in Computer Science, Information Technology or Engineering or equivalent experience.

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.

Benefits

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

Vision starting at $5 per month

FSA for healthcare and commuter costs

A 403b retirement savings plans with immediately vested matching

Disability & life insurance

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.

Company

International Rescue Committee

Glassdoor

3.7

IRC responds to the world's worst humanitarian crises & helps some of the most vulnerable people from harm to home.

Founded in 1933

New York, New York, USA

10001+ employees

http://www.rescue.org/

H1B Sponsorship

International Rescue Committee has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2023 (16)

2022 (19)

2021 (13)

2020 (8)