Data Engineer at International Rescue Committee

Job Overview / Summary (What and Why):

• This is a great opportunity for a dynamic and passionate individual to join our Data Engineering & Architecture team to help grow and evolve how we do Audience Management. The Data Engineer is responsible for quality assurance and stewardship of data received from content, fundraising and analytics activities, both external and internal. They will be tasked with planning, designing, and completing data list pulls and upload routines; and proactively monitoring, measuring, analyzing, and reporting on large data quality issues to the organization. 
• The development of protocols, creating and implementing monitoring procedures to ensure data quality and standardization, and suggesting process improvements will all be crucial parts of this role. The Data Engineer 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 Engineer you will perform hands-on technical implementation, with a focus on administering and delivering functional solutions on IRC’s backend data extracted from the Marketing Technology systems. You will be involved in the design, implementation, deployment, and documentation of projects that utilize the enterprise ETL, and SQL toolsets.
• 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 ER data using Azure MSSQL, Databricks, and Salesforce 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 Databricks, Salesforce or other key marketing technology platforms.
• Develop and automate recurring data processing operations to optimize efficiency.
• Create, maintain, and update Excel VBA templates for partners, ensuring usability and alignment with project requirements.
• Develop and maintain database code in the form of Stored Procedures/Notebooks, SQL Queries. Functions and Views as required by business processes.
• Ensure system optimization, by improving and restructuring databases. Involved with all levels of database management.
• Perform database updates and migrations.
• Design, implement, and maintain data upload workflows to ensure seamless integration from external sources into the IRC’s data architecture.
• Ensure efficiency of database code, integrity of data structures, quality of data content and database code is accurately documented.
• Work closely with other team members to make sure database code meets the requirements.
• Experience building data-warehouses (relational and non-relational databases) and solutions for CRM (Salesforce)
• Write database queries and code while maintaining data quality, privacy, and security.
• Responsible for requirement gathering, bug fixing, testing, documenting, and implementation.
• 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: Senior Data Engineer
• 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 Databricks, DBT, MongoDB, and MSSQL queries 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.
• Certification for Databricks is a plus.
• Hands-on experience with ETL design sessions and workflows.
• Experience in supporting fundraising applications for non-profit organizations.
• 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.