Data Engineer — TalentHop, United States

This is a Fully Remote Job

About Our Client:

The organization operates in the fundraising technology industry, addressing challenges in donor management and engagement. It supports sectors such as education, healthcare, and nonprofit by providing tools and a large charitable giving database. The organization leverages real-time data and AI to offer fundraising intelligence through purpose-built CRMs, donor prospect research tools, and generative AI for personalized content, serving thousands of organizations globally.

About the Opportunity:

The DATA ENGINEER role focuses on building and maintaining the data platform that supports customer-facing analytics products. This position is responsible for managing the full data pipeline from ingestion of customer data into the data lake to transforming it for dashboards and AI-driven insights. The role is critical for enabling scalable, multi-tenant analytics and ensuring accurate, timely data delivery for decision-making.

Responsibilities:

• Build and maintain ELT pipelines ingesting data from customer Salesforce environments into the AWS data lake.

• Develop data transformation layers and dimensional models using dbt on Redshift or Snowflake.

• Write and optimize complex SQL queries for transformation, aggregation, and data quality validation.

• Manage AWS services including S3, Glue, Athena, Redshift, Step Functions, Lambda, IAM, Lake Formation, and CloudWatch.

• Onboard new customer data sources by extending configuration-driven pipelines and validating against acceptance criteria.

• Implement automated data quality checks, reconciliation queries, and monitoring for pipeline health.

• Investigate and resolve data issues through the entire data flow.

• Contribute to infrastructure as code development using AWS CDK or Terraform.

• Support dashboard and reporting development in QuickSight or Tableau by ensuring correct data models.

Requirements:

• Minimum 3 years of hands-on data engineering experience with production data pipelines.

• Advanced proficiency in SQL including window functions, CTEs, complex joins, and query tuning.

• At least 2 years of hands-on AWS experience with key services such as S3, Glue, Athena or Redshift, IAM, and orchestration tools.

• 2+ years experience building ETL/ELT pipelines with dbt or similar frameworks.

• Experience with cloud data warehouses like Redshift or Snowflake, including dimensional modeling.

• Proficiency in Python for data-related tasks.

• Experience with Git workflows, code review, and CI/CD for data pipelines.

• Bachelor's degree in Computer Science, Data Science, Engineering, or related field, or equivalent experience.

Pay Range and Compensation Package:

• Compensation range is $120,000 to $135,000 CAD OTE annually, based on experience and role complexity.

Equal Opportunity Statement: Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin.

Note:

TalentHop is a recruitment partner of this role. Please note that all employment decisions, including candidate assessment, interviews, hiring, compensation, and employment terms, are made exclusively by the hiring employer.