Jobs / JD Power
Data Platform Engineer, Snowflake
JD Power · Canada · Remote
CanadaExp: 2-4 yrs95,000-130,000 CAD/yearlyRemote
Remuneration
95,000-130,000 CAD/yearly
Location
Canada · Remote
Visa sponsorship
Not specified
Job summary
The Data Platform Engineer will execute and extend engineering patterns established by the Snowflake Platform Lead and Senior Data Platform Engineer. This role involves the day-to-day build, deployment, and operation of Snowflake objects, pipelines, and tooling, with a path to grow into a senior-level platform engineer. The engineer will also contribute to architecture and pattern design decisions, RBAC model evolution, security policy implementation, performance tuning, and cost optimization initiatives under guidance.
Qualifications
- 2–4 years of professional software, data, or platform engineering experience
- Strong SQL skills including joins, window functions, CTEs, and reading explain plans
- Python for scripting, automation, and data work
- Cloud data warehouse experience (Snowflake preferred; Redshift, BigQuery, or Databricks SQL considered)
- Version control discipline with Git workflows, branching, code review, and CI/CD
- Infrastructure-as-Code exposure (Terraform, CloudFormation, Pulumi, or equivalent)
- Working knowledge of dbt (reading models, writing tests, running dbt build in CI)
- Cloud fluency in AWS or Azure (IAM, storage, basic networking)
- Production experience shipping code and supporting live systems (on-call experience)
- Clear communication skills (writing PR descriptions, asking questions, documenting work)
- Hands-on Snowflake experience in production
- Production dbt experience (authoring models, writing tests, shipping to deployed environment)
- SnowPro Core certification (expected within 6–9 months)
- Experience with database CI/CD tooling (Schemachange, Liquibase, dbt deploys)
- Exposure to ingestion tools (Fivetran, Airbyte, Snowpipe, Kafka)
- Exposure to data observability tooling (Monte Carlo, Datadog, Grafana)
- Experience in automotive, financial services, insurance, or other regulated consumer-data industries
- Computer Science degree or equivalent applied experience (e.g., bootcamp + production track record)
Responsibilities
- Execute and extend engineering patterns established by Snowflake Platform Lead and Senior Data Platform Engineer
- Build, deploy, and operate Snowflake objects, pipelines, and tooling
- Grow into a senior-level platform engineer
- Implement Snowflake objects and roles in Terraform
- Operate CI/CD pipelines for database changes
- Configure and maintain assigned ingestion pipelines (Snowpipe, Streams/Tasks, managed connectors)
- Provide first-line response to platform alerts on assigned components
- Update documentation and runbooks for delivered work
- Contribute to architecture and pattern design decisions
- Contribute to RBAC model evolution and security policy implementation
- Contribute to performance tuning and cost optimization initiatives
- Author database migrations using Schemachange/Liquibase and ship through CI/CD
- Own and operate CI/CD pipeline for dbt models in production
- Apply masking and row-access policies to new data domains
- Tune individual queries and warehouses using profiling techniques
- Configure, deploy, and maintain ingestion pipelines for assigned source systems
- Manage Fivetran/Airbyte connector deployments for assigned sources
- Build Snowpipe and Streams/Tasks workflows for assigned ingestion patterns
- Partner with Analytics Engineering to land data for downstream models
- Participate in on-call rotation for the platform
Skills
AWSAzureBigQueryCloudFormationDatabricksDatadogdbtGitGrafanaIAMKafkaMakePulumiPythonRedshiftSnowflakeTerraform
Certifications
SnowPro Core certification
Degrees
Computer Science degree
Work schedule
On-call rotation
Industry
AutomotiveFinancial servicesInsurance
Relocation
No