Data Engineer

Join us as a

Data Engineer (Remote, Flexible Hours)

Contractor: Oct 2025 - May 2026

Rate: $80.00 to $100.00 / hour

Flexible hours, but needs to be available regularly for meetings between 8am-3pm EST.

Remote (with office available in Toronto for desired Hybrid work)

Do you want to contribute your skills to an organization that combines technical excellence with social purpose?

Do you want to be trusted as the go-do data expert, with the freedom to design solutions and actually see the impact of your work on clients’ missions?

Do you want the flexibility to shape your workday while collaborating with a team that values both your independence and your ideas?

EXPECTATIONS OF THE ROLE

Mission Statement

You are a self-motivated Data Engineer with experience in Azure Data Factory who is an expert in efficiently moving data between systems. You design robust integrations and data pipelines, build well-structured data warehouses and support well-thought-out data migrations. You also have flexibility to work in other data warehousing environments.

Expected Outcomes

Data Operations 

• Data Migrations: Design and build processes and tools for migrating data from source to target system during client Grants Management System implementations; advise clients on their data cleansing needs and data migration validation activities to support a successful data migration
• Data Updates:  carry out large scale data updates for clients using existing systems using existing tools and API scripts, supporting optimization and support projects
• Data Engineering/Warehousing: designs, builds and maintains systems that effectively store, retrieve and analyze large amounts data from different source systems in a client ecosystem. 
• Developing ETL processes to integrate data from multiple sources into a centralized repository
• Create data models that accurately represent business processes and support analytics
• Testing and troubleshooting data systems to ensure accuracy and quality of data. Documenting the data warehouse environment

YOUR PRIMARY RESPONSIBILITIES:

Project 1: Azure Data Factory Data migration engineer on client-facing delivery project (estimated avg 40hr/month, Oct - May)

• Responsibility 1: Build data pipeline from Fluxx (a GMS system) into Azure Data Factory
• Responsibility2: Execute data discovery and support analysis to identify data cleansing requirements
• Responsibility3: Build data cleansing and transformation scripts in Azure Data Factory based on identified data cleansing activities and data mapping rules
• Responsibility 4: Build data outputs of CSV files in the format of expected data migration templates of the target system
• Responsibility 5: Support iterations of data cleansing analysis and data migration verification with the Business Analyst(s) and client teams
• Responsibility 6: Participate in regular team meetings and communicate proactively using project tools

Project 2: Internal Grantbook data infrastructure (estimated avg 20 hr/month, Oct-Feb)

• Responsibility 1: complete 2024 outstanding enhancements using Fivetran, Google Big Query, and Google Cloud Function to rollout to data outputs; build enhancements and transition for 2025 Fiscal year
• Responsibility 2:Transition data infrastructure operational knowledge and design to incoming IT Operations new hire for ongoing maintenance. This includes updating the Internal BI and Data Infrastructure documentation.

Project 3: Future data migration enablement tool (estimated avg 10 hr/month, Mar-May)

• Responsibility 1: Set up reusable infrastructure and documentation for enabling future data migration support projects into Fluxx

IDEAL CANDIDATE PROFILE 

Skills & Qualifications

Required

• Three years minimum professional experience using Azure Data Factory to develop data pipelines from source systems to target systems
• Experience using programming languages Python, SQL, Azure Data Factory Expression Language, and/or REST API.
• Demonstrated experience delivering data migration activities on projects
• Demonstrated experience eliciting data pipeline requirements from functional business team members, including generating documentation outputs such as data flow diagrams and process documentation.
• Familiarity with Google BigQuery, Google Cloud Data Fusion, and Fivetran
• Proven interpersonal skills and a customer service-oriented approach.

Preferred

• Familiarity with Fluxx, SmartSimple, Salesforce for Philanthropy, FoundationConnect, Blackbaud Grantmaking or similar Grants Management Systems.
• Familiarity with financial accounting principles 

Company Profile

Grantbook is a social-purpose, vendor-agnostic consultancy helping Grantmakers around the world operationalize their vision and values - including JEDI and trust-based philanthropy - to transform their grantmaking and amplify their impact. As a values-driven B Corporation, we are proud to participate in a “chain of good”, helping our clients deliver on their missions of building solutions. 

For more information, we encourage you to take a look at our careers page: https://www.grantbook.org/about/culture-careers#Benefits

How to Apply

We have an application intake process that starts when you fill in the online form linked from our website or job posting. 

Interview Process

• We review each application we receive. Only candidates who are selected for an interview will be contacted.
• We will be closing the application window on October 6, 2025 at 9am EST.
• Grantbook leverages AI during the hiring process to identify priority applications to review. 
• Candidates should expect a 1-2 week timeline from application to interviews.
• Candidates should expect a recruiting process that involves a video screening interview (15-20 min), an assessment interview, and request for reference checks.

Commitments

Grantbook welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.