Data Engineer

Data Engineer – Snowflake

Location: Toronto, ON

We are building a modern data platform centered on Snowflake and are seeking a Snowflake-focused Data Engineer to design, build, and operationalize Snowflake-native solutions. This role combines advanced Snowflake development, data architecture, and platform engineering to deliver secure, scalable, and high‑performing data products and utilities that support analytics and enterprise data initiatives.

Key Responsibilities

• Design and implement Snowflake-based data architectures, including schema design, data vault/house/star models, materialized views, and zero‑copy cloning strategies.
• Build and maintain production ETL/ELT pipelines using Snowpipe, Snowpark, Streams & Tasks, and tools such as dbt, Fivetran, Matillion, Airbyte, and StreamSets.
• Develop Snowflake-native utilities and applications using Snowpark for Python, UDFs, and external functions.
• Optimize query performance and cost through clustering keys, warehouse sizing, workload isolation, and resource monitoring.
• Implement data governance, security, masking policies, object tagging, lineage tracking, and audit logging.
• Automate infrastructure and deployments using Terraform, GitHub Actions, Jenkins, or equivalent CI/CD tools.
• Build monitoring, alerting, usage/cost reporting, and operational support tooling for Snowflake workloads.
• Mentor engineers, review technical designs, and contribute to Snowflake platform roadmap decisions.

Required Skills & Experience

• Strong hands‑on experience designing and operating Snowflake in production environments.
• Deep expertise with Snowpark, Streams & Tasks, Snowpipe, Time Travel, cloning, materialized views, external functions, and UDFs.
• Hands‑on ETL/ELT development experience with dbt, SQL, and ingestion tools such as Fivetran, Matillion, Airbyte, StreamSets, or Kafka connectors.
• Strong proficiency in Python (Snowpark/Connector) and advanced SQL optimization techniques.
• Experience with Infrastructure as Code and automation tools.
• Strong knowledge of cloud platforms AWS, Azure, or GCP for Snowflake integrations and deployments.
• Solid understanding of medallion architecture, data modeling, governance, and secure data sharing.
• Experience implementing CI/CD, automated testing, and production operational practices for data workloads.

Preferred Qualifications

• Snowflake SnowPro Core or advanced Snowflake certifications.
• Experience with dbt Core or dbt Cloud.
• Experience with data catalogs, data lineage, or data virtualization tools.
• Familiarity with BI platforms such as Looker, Tableau, or Power BI.
• Experience building internal developer tools or lightweight data applications using Snowpark.

Data Platform Engineer

Location: Toronto, ON

The primary focus of this role will be to design, build, and maintain the EMFI Data Application Platform, a financial analytics application. The incumbent will work across the full stack to deliver reliable, performant, and secure data products.

Responsibilities and Duties

• Collaborate with internal stakeholders to translate business and analytical requirements into well‑defined backend features and data products.
• Design and deploy scalable microservices within the FastAPI ecosystem, establishing clear service boundaries for domain‑specific services and ensuring loose coupling through well‑defined API contracts.
• Design and develop Snowflake‑native applications including Snowpark (Python), stored procedures, tasks, streams, and dynamic tables to support day‑end processing engines that run natively within the Snowflake compute layer.
• Design and implement RESTful API endpoints using FastAPI ensuring data contracts are clearly defined, versioned, and documented via OpenAPI/Swagger.
• Write and optimize SQL queries against Snowflake and PostgreSQL for reporting, aggregation, and analytical use cases.
• Own end‑to‑end feature delivery: from requirements gathering and API contract definition through implementation, testing, and deployment.
• Ensure platform security by applying best practices around authentication, authorization (RBAC), input validation, and safe error handling, aligned with OWASP Top 10.

Technical Skills

• Experience designing and implementing microservices architectures, including service discovery, inter‑service communication, API versioning, and distributed tracing/logging for observability.
• Proficiency in Python for backend development, including FastAPI async patterns and Pydantic‑based data validation.
• Hands‑on experience with SQL and analytical databases for writing optimized queries, aggregations, and data transformations.
• Experience developing Snowflake‑native applications: stored procedures (JavaScript/Python), Tasks, Streams, Dynamic Tables, and Snowpark for building backend processing engines.
• Understanding of REST API design, OpenAPI specifications, and API integration patterns in frontend applications.
• Knowledge of authentication and authorization patterns including JWT, OAuth2, and role‑based access control.
• Experience with Docker and Docker Compose for local development and containerized deployments.
• Familiarity with CI/CD pipelines for automated testing and deployment.
• Experience with version control using Git, including branching strategies and code review workflows.
• Ability to work with cloud platforms (AWS, Azure, or GCP) for data storage, compute, and deployment.

Qualifications and Skills

• Bachelor’s degree (Master’s preferred) in Computer Science, Software Engineering, Information Systems, or a related discipline.
• 5–7 years of professional full‑stack development experience, with demonstrated delivery of production‑grade web applications.
• Experience in the Payments or Fintech industry would be a strong asset.
• Proven ability to work independently, manage multiple concurrent workstreams, and deliver with minimal oversight.
• Excellent communication and interpersonal skills, with the ability to engage both technical and non‑technical audiences.
• Unquestionable personal and business ethics and integrity.