Who Can Apply
- Candidates must be legally authorized to work in Canada
Job Description
Project Overview
The team is in the middle of a migration from Salesforce Marketing Cloud to MoEngage, focused on rebuilding and modernizing the data ingestion and curation pipelines that support email marketing and outbound communication workflows.
Role Summary
This is an intermediate to senior‑level BI/Data Engineering role focused on the data infrastructure side, not dashboarding or Looker development.
You will own and drive the migration of existing data curation processes into a more scalable, cloud‑native model. This includes working closely with business stakeholders to understand current workflows, translating them into improved data models, and implementing pipelines that integrate with the new marketing platform.
The environment is Python‑based, with heavy use of SQL, Airflow, GCP, and dbt.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
Key Responsibilities
Build, enhance, and maintain data ingestion and transformation pipelines supporting the migration from Salesforce to MoEngage.
Curate and model data for BitQuery, outbound feeds, and downstream analytics.
Translate existing business logic and curation processes into optimized, scalable data models.
Work with cross‑functional business partners to understand current workflows and requirements.
Develop and maintain Python‑based ETL/ELT pipelines.
Orchestrate workflows using Airflow.
Implement transformations and modeling using dbt.
Ensure data quality, reliability, and consistency across the new platform.
Operate independently, navigating ambiguous requirements and driving solutions with minimal oversight.
Required Skills & Experience
4–5+ years of hands‑on experience in BI, Data Engineering, or similar roles.
Strong proficiency in:
Python (data pipelines, scripting, integrations)
SQL (complex queries, transformations, performance tuning)
Airflow (DAG development, orchestration)
dbt (data modeling, transformations)
GCP (BigQuery, Cloud Storage, etc.)
Experience with marketing data pipelines or customer engagement platforms is a plus.
Ability to work directly with stakeholders and translate business logic into technical solutions.
Comfortable owning deliverables end‑to‑end and working independently.
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.