Data Engineer
- remote type
- Open to Remote
- locations
- London, UK
- time type
- Full time
- posted on
- Posted Yesterday
- job requisition id
- JR00001249
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 call of Albert Einstein, the IRC is one of the world's largest international humanitarian non-governmental organizations (INGO), at work in more than 40 countries and 29 U.S. cities helping people to survive, reclaim control of their future and strengthen their communities. A force for humanity, IRC employees deliver lasting impact by restoring safety, dignity and hope to millions. If you're a solutions-driven, passionate change-maker, come join us in positively impacting the lives of millions of people world-wide for a better future.
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 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.
Licenses or Certifications: None required
Language Skills: English Fluency
Working Environment (Optional): Remote
The salary for this role is GBP 48,550 – GBP 58,800
PROFESSIONAL STANDARDS
All International Rescue Committee workers must adhere to the core values and principles outlined in IRC Way - Standards for Professional Conduct. Our Standards are Integrity, Service, Equality and Accountability. In accordance with these values, the IRC operates and enforces policies on Safeguarding, Conflicts of Interest, Fiscal Integrity, and Reporting Wrongdoing and Protection from Retaliation. IRC is committed to take all necessary preventive measures and create an environment where people feel safe, and to take all necessary actions and corrective measures when harm occurs. IRC builds teams of professionals who promote critical reflection, power sharing, debate, and objectivity to deliver the best possible services to our clients.
Cookies: https://careers.rescue.org/us/en/cookiesettings
#li-1
Why Choose the IRC?
Work that has meaning: Every day at the IRC is a chance to make a difference through a purpose-driven career. Whether you're working directly with communities or providing support behind the scenes, you will be part of a dynamic team that is always innovating, scaling, and testing new and better solutions to ensure the best possible outcomes for the people we serve.
Global scale, dynamic workplace: At the IRC, we believe that the dynamic, global make-up of our team is our strength. When you join us, you're not just starting a job—you will be part of a global organization positively impacting millions of lives in over 40 get to work with colleagues from all around the world—working across time zones and regularly exchanging different ideas, perspectives and insights. You’ll join a team that is dedicated to fostering a supportive environment to create a workplace where everyone feels valued, respected, and heard.
Challenging work, innovative solutions: We’re committed to excellence and innovation, and pride ourselves in setting industry-leading standards while practicing evidence and data-lead strategies. Come challenge norms, shatter conventions, and pioneer change while working on real, nuanced and complex issues we face in the world today.
Community centered: We’re an empathetic community that truly cares for one another. Our comprehensive safety and security initiatives ensure a safe work environment, while our continuous learning and development programs provide ongoing opportunities for personal and career advancement.
Our Typical Recruitment Process
The interview process typically includes three rounds, though the number may vary depending on the role and level of seniority. It usually begins with a conversation with our recruiting team to learn more about you and your goals. This is followed by an interview with a hiring manager or business stakeholder to explore your background and provide more insight into the role. The final round focuses on assessing your role-specific expertise and may be conducted as a panel interview to evaluate your cross-functional strengths. Before extending an offer, we generally conduct reference checks, and after an offer is made, a standard background check is completed. While we strive for consistency, the process may differ based on the role, business unit, location, job type, legal requirements, and other factors.