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.