Role Overview
Join a mission-driven team focused on advancing data integrity and efficiency within a global humanitarian organization. As a Data Engineer, you'll play a central role in shaping how data flows across systems, enabling smarter decision-making for fundraising and outreach. You'll work across platforms including Azure MSSQL, Databricks, and Salesforce, ensuring data is accurately extracted, transformed, and loaded from both internal and external sources.
Key Responsibilities
- Extract, transform, and load data from sources such as SFTP servers and vendor portals into core platforms, ensuring accuracy and consistency.
- Design and automate recurring data processes to improve operational efficiency and reduce manual effort.
- Develop and maintain database components including stored procedures, views, functions, and SQL queries aligned with business needs.
- Build and support Excel VBA templates used by partners, enhancing usability and automation capabilities.
- Manage database performance through optimization, restructuring, and migration activities.
- Implement secure and reliable data upload workflows to integrate external data into the organization’s architecture.
- Ensure high standards of data quality, privacy, and documentation across all database activities.
- Collaborate with cross-functional teams to gather requirements, troubleshoot issues, and deliver effective data solutions.
- Diagnose and resolve data discrepancies using advanced SQL and analytical techniques.
- Support Salesforce operations by resolving data-related cases and improving integration processes.
- Conduct testing, document workflows, and maintain a reliable knowledge base for ongoing reference.
- Act as a technical resource for automation tools and data handling best practices.
Qualifications
Candidates should have at least an Associate’s degree and five or more years of hands-on experience in data management, with a focus on ETL processes and relational databases. Strong technical proficiency in SQL, Azure MSSQL, Databricks, and Salesforce integration tools such as DBAmp is essential. Experience with CRM systems—especially in nonprofit environments—and familiarity with Salesforce NPSP are highly valued.
Additional qualifications include advanced skills in query optimization, experience building data warehouses, and the ability to translate technical workflows for non-technical stakeholders. Familiarity with Agile methodologies, web services, APIs, and business intelligence solutions is beneficial.
Technical Environment
The role leverages a modern data stack including Azure MSSQL, Databricks, DBT, MongoDB, Salesforce, SFTP, Excel VBA, and API-based integrations. Engineers work extensively with stored procedures, SQL queries, functions, and views to maintain robust data pipelines.
Work Environment
This is a remote position, open to candidates globally. The role supports a mission-critical function in driving digital fundraising success, contributing to annual digital donations exceeding £50 million. Engineers help refine segmentation, reporting, and data strategies that expand organizational impact.
Values and Culture
The organization is guided by core principles of integrity, service, equality, and accountability. All team members are expected to uphold these standards in daily work and collaboration. Policies on safeguarding, fiscal responsibility, and ethical conduct are rigorously enforced.
