Lead Data Engineer

This is a fully remote position, open to applicants in Canada.

📋 Description

• Define the technical strategy, architectural guidelines, and data governance for the primary Data Analytics platform.

• Oversee logical and physical data modeling, warehouse architecture, and the structured curation process from staging to intermediate and mart.

• Act as the Data Engineering Tech Lead and primary technical resource for Analytical Engineers.

• Lead the comprehensive design and implementation of data pipelines, encompassing ingestion, API integrations, custom connectors, ELT/ETL processes, and pipeline orchestration.

• Integrate specialized data practices into Git, CI/CD, and Jira workflows.

• Execute automated dbt testing, manage environmental isolation, credential oversight, and data deployment standards.

• Establish and enhance governance frameworks.

• Assess and adopt Data Catalog and Data Observability solutions to ensure lineage, freshness, completeness, and failure notifications.

• Optimize Snowflake query performance, clustering, and warehouse configurations to improve execution efficiency and manage compute expenses.

• Provide architectural insights, conduct design reviews, and offer technical mentorship within an Agile planning environment.

• Analyze tools, frameworks, and architectural patterns to modernize and enhance the data stack.

• Propel AI-readiness initiatives by developing semantic layers, data structures, and access patterns suitable for AI agents and automated workflows.

• Collaborate with Engineering, Infrastructure, Data Science/ML, and business stakeholders.

⛳️ Requirements

• Demonstrated experience as a Senior Data Engineer, Data Architect, or Tech Lead in cloud-based data environments.

• Familiarity with developing data structures, semantic models, feature stores, and API/access layers tailored for AI agents, machine learning pipelines, and automated LLM workflows.

• Extensive hands-on experience with administering, tuning, and modeling in Snowflake.

• Advanced proficiency in dbt, including macros, incremental models, custom tests, packages, and dbt-native CI/CD testing.

• Exceptional analytical SQL capabilities, encompassing query execution plan optimization, window functions, and CTEs.

• Strong Python skills for data pipeline development, scripting, and MLOps workflows.

• Practical knowledge of ingestion and orchestration engines like Matillion, Apache Airflow, Prefect, Dagster, or Fivetran.

• Ability to assess architectural trade-offs, performance, and costs when choosing or transitioning platforms.

• Experience working with active Git and CI/CD pipelines, including automated data testing, deployment validation, and secure credential management.

• Strong critical thinking, business-context collection, hypothesis development, and thorough evaluation of results.

• Experience creating lightweight MVPs and proofs of concept.

• Proficient in business-level English.

• Ability to explain complex technical trade-offs, mentor peers, and work collaboratively in a remote, globally distributed team.

🏝️ Benefits

• Remote First, Remote Always.

• PTO in accordance with local labor regulations.

• Fully Paid Parental Leave.

• Home office stipend based on country of residence.

• Professional development courses available through Cloudbeds University.

• Access to professional growth opportunities, including manager training, skills enhancement, and knowledge transfer.