Data Engineer at Motive delivering data infrastructure for the AI era. Collaborating with stakeholders, building models, and implementing innovative tooling.
Responsibilities
Collaborate & Strategize: Partner closely with business stakeholders to understand their challenges and design end-to-end architecture that solves complex business problems.
Build & Maintain Data Models: Design, develop, and own robust, efficient, and scalable data models in Snowflake and Iceberg using dbt and advanced SQL.
Orchestrate & Automate: Build and manage reliable data pipelines and CI/CD workflows using tools like Airflow, Python, and Terraform to ensure data is fresh, trustworthy, and infrastructure is version-controlled.
Champion Data Quality: Implement rigorous testing, documentation, and data governance practices to maintain a single source of truth.
Enable Analytics & Workflows: Act as the Product Owner and Tech Lead for your data domains, taking responsibility for the end-to-end data product delivery– from raw ingestion to data models enabling analytics and data apps in tools like Tableau and Retool.
Innovate with AI: Help us build our next-generation data infrastructure by integrating AI capabilities (like Snowflake Cortex AI) to democratize analytics and empower the business.
Architect Observability: Implement monitoring and alerting frameworks (e.g., dbt packages or Monte Carlo monitors) to proactively catch "silent" data failures before stakeholders do.
Requirements
6+ years of experience in Analytics Engineering, Data Engineering, or a similar role.
Deep expertise in SQL and developing complex data models for analytical purposes (e.g., dimensional modeling).
Hands-on experience with:
Data Warehousing: High proficiency in Snowflake (preferred) and experience with Open Table Formats like Iceberg.
Data Transformation: dbt
Orchestration & ETL: Airflow, Fivetran, Airbyte
Cloud Platform: AWS
Programming/Ingestion: Python
Infrastructure as Code: Terraform
AI-Augmented Development: Proficiency using AI coding assistants (Cursor, Copilot, or Claude) to accelerate development and automate routine tasks.
A strong analytical mindset with a proven ability to solve ambiguous business problems with data.
Excellent communication skills and experience working cross-functionally.
Self-starter with the ability to self-project manage work
A user focus with the ability to understand how a data consumer will use the data products you build
Benefits
Health, pharmacy, optical and dental care benefits
Architecte de données sénior concevant des architectures analytiques et gouvernance des données pour les transformations numériques de Wepoint. Travail flexible à Montréal ou Québec, en mode hybride, distant ou sur site.
Streaming Data Engineer building scalable Bronze, Silver, and Gold data pipelines for PLATO’s public sector clients. Managing real - time ingestion, processing, security, and data quality.
Senior Data Architect designing governed, event - driven healthcare data platforms for Wepoint. Leading Fabric, Power BI, ETL, and analytics architecture for Québec health - network transformations.
Staff Data Engineer building pipelines, models, and infrastructure for exacare ai’s post - acute care AI platform. Turning healthcare data into reliable foundations for product, analytics, and ML workflows.
Senior Data Engineer architecting cloud data platforms and pipelines for Arc’teryx supply chain analytics. Leading migrations, governance, observability, and engineering mentorship.
Senior Data Engineer improving General Motors vehicle data pipelines, monitoring, and observability. Supporting reliable fleet software operations across Oshawa and Markham hybrid offices.
Senior software engineer building General Motors’ vehicle data platform across ECUs and cloud. Developing control, data, logging, and SDK software for connected vehicles.
Senior Data Architect integrating Alberta’s environmental regulatory, Databricks, and geospatial platforms. Designing governed data flows for regulators, decision - makers, and Albertans.
Senior Data Architect leading secure, scalable data architecture for Manulife’s financial services organization. Designing cloud, lakehouse, analytics, machine learning, and generative AI data platforms.
Data engineering advisor developing scalable data platforms and pipelines for Desjardins. Designing, integrating, and improving data systems aligned with business needs.