Sr. Data Engineer

Company Overview

Role Overview

Data Platform Engineering

• Design and maintain secure, scalable Snowflake databases, schemas, warehouses, and data-sharing solutions.
• Translate business and Finance requirements into data models, technical designs, data contracts, and implementation plans.
• Develop Snowflake SQL, Snowflake Scripting, stored procedures, user-defined functions, and reusable platform components.
• Build ELT pipelines using Snowflake stages, Snowpipe, Streams, Tasks, Dynamic Tables, and orchestration tools.
• Create dimensional, relational, and semi-structured data models.

Performance and Governance

• Optimize Snowflake workloads, warehouse sizing, clustering, concurrency, caching, and query execution.
• Establish cost-efficient warehouse and workload management strategies.
• Implement RBAC, least-privilege permissions, masking policies, row access policies, tagging, auditing, and data classification.
• Apply Time Travel, zero-copy cloning, secure data sharing, and environment isolation.

Operations and Collaboration

• Support Git-based version control, code review, automated testing, CI/CD, and repeatable deployment processes.
• Develop monitoring, reconciliation, quality checks, and dashboards for pipeline failures, data freshness, query regressions, and consumption.
• Partner with Finance, Data Engineering, Analytics, and application teams to resolve data issues and improve data definitions.
• Document data models, lineage, procedures, security decisions, and performance or cost recommendations.
• Contribute to technical standards and mentor team members on Snowflake engineering practices.

Required Qualifications

• At least eight years of professional SQL-based database or data engineering experience.
• At least three years of hands-on experience operating production Snowflake workloads.
• Strong Snowflake architecture and advanced Snowflake SQL knowledge.
• Experience with Snowflake Scripting, stored procedures, user-defined functions, and reusable database logic.
• Experience designing Snowflake ELT pipelines and analytics or Finance data models.
• Experience improving Snowflake performance and managing Snowflake security and governance.
• Experience with Python and scripting for data engineering, automation, testing, or administration.
• Experience with GitHub or GitLab, code review, and automated deployment.

Preferred Qualifications

• Snowpark experience.
• Experience with dbt, Airflow, Dagster, or another modern transformation and orchestration framework.
• Experience with governance, observability, cost-management, data-quality, or catalog tools.
• Knowledge of Finance, accounting, lending, risk, or regulatory reporting concepts.
• Experience with legacy database migrations, Java, infrastructure as code, APIs, event-driven ingestion, or cloud storage integrations.
• Experience with generative AI tools such as ChatGPT, Claude, or Copilot is an asset.

Compensation

• The stated salary range is $110,000-$150,000.
• Final compensation depends on market conditions, location, experience, skills, and education, and may include performance-based incentives.

Benefits

• Benefits include health and dental coverage, vacation, group RRSP participation, support for new parents, and growth opportunities.
• The company describes an inclusive workplace and opportunities for internal advancement.