Data Engineer

Data Engineer at International Rescue Committee (IRC)

The International Rescue Committee (IRC) responds to the world’s worst humanitarian crises, helping to restore health, safety, education, economic wellbeing, and power to people devastated by conflict and disaster. Founded in 1933 at the behest of Albert Einstein, the IRC is one of the world’s largest humanitarian non‑governmental organisations, operating in more than 40 countries and 29 U.S. cities. IRC employees deliver lasting impact by restoring safety, dignity and hope to millions of people worldwide.

If you are a solutions‑driven, passionate change‑maker, come join us in positively impacting the lives of millions for a better future.

This role sits within the Marketing Technology department, which supports 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. Responsibilities include managing enterprise CRM, web, donation and communications platforms.

This is an opportunity for a dynamic individual to join our Data Engineering & Arch­itecture team to grow and evolve our Audience Management. As a Data Engineer you will provide quality assurance, stewardship of data from content, fundraising and analytics activities, design and implement data pipelines, and monitor data quality. You will develop protocols, create monitoring procedures, and suggest process improvements.

You will train and document for multiple global teams, helping them capture high‑quality information for analytical decision‑making.

Your work will support the global External Relations Department’s business systems and processes, ensuring alignment and continuous improvement to meet evolving goals.

• 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 optimise efficiency.
• Create, maintain and update Excel VBA templates for partners to ensure 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 optimisation by improving and restructuring databases; manage database at all levels.
• 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 and quality of database content; document code accurately.
• Work closely with other team members to ensure database code meets requirements.
• Build data‑warehouses (relational and non‑relational) 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 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 and administrative support.
• Review, assess and resolve database‑related…