Data Platform Engineer, Snowflake

J.D. Power•Ontario - Remote, ON

1d•$110,000 - $130,000•Remote

About The Position

Execute and extend the engineering patterns established by the Snowflake Platform Lead and Senior Data Platform Engineer. Responsible for the day-to-day build, deployment, and operation of Snowflake objects, pipelines, and tooling — and for growing into a senior-level platform engineer over time.

Requirements

2–4 years of professional software, data, or platform engineering experience.
Strong SQL — comfortable with joins, window functions, CTEs, and reading explain plans.
Python for scripting, automation, and data work.
Cloud data warehouse experience — Snowflake preferred; recent Redshift, BigQuery, or Databricks SQL experience considered.
Version control discipline — comfortable in Git workflows with branching, code review, and CI/CD.
Some Infrastructure-as-Code exposure — Terraform, CloudFormation, Pulumi, or equivalent.
Working knowledge of dbt — comfortable reading models, writing tests, and running dbt build in CI.
Cloud fluency in AWS or Azure — comfortable with IAM, storage, and basic networking.
Production experience — has shipped code to production systems and been on-call or supported live systems.
Communication — can write clear PR descriptions, ask good questions, and document their work.

Nice To Haves

Hands-on Snowflake in production (any role: engineer, analytics engineer, analyst).
Production dbt experience — has authored models, written tests, and shipped to a deployed environment.
SnowPro Core certification (not required at hire; expected within 6–9 months).
Database CI/CD tooling (Schemachange, Liquibase, dbt deploys).
Exposure to ingestion tools (Fivetran, Airbyte, Snowpipe, Kafka).
Data observability tooling (Monte Carlo, Datadog, Grafana).
Automotive, financial services, insurance, or other regulated consumer-data experience.
Computer Science degree or equivalent applied experience (e.g., bootcamp + production track record).

Responsibilities

Owns Implementation of Snowflake objects and roles in Terraform per established patterns.
Day-to-day operation of CI/CD pipelines for database changes.
Configuration and maintenance of assigned ingestion pipelines (Snowpipe, Streams/Tasks, managed connectors).
First-line response to platform alerts on assigned components.
Documentation and runbook updates for work this role delivers.
Contributes to (under guidance of the Senior) Architecture and pattern design decisions.
RBAC model evolution and security policy implementation.
Performance tuning and cost optimization initiatives.
Implement Snowflake objects, roles, and policies in Terraform per established patterns.
Author database migrations using Schemachange/Liquibase and ship them through CI/CD.
Own and operate the CI/CD pipeline that builds, tests, and deploys dbt models in production.
Apply masking and row-access policies to new data domains as they onboard.
Tune individual queries and warehouses using established profiling techniques.
Configure, deploy, and maintain ingestion pipelines for assigned source systems.
Manage Fivetran/Airbyte (or equivalent) connector deployments for assigned sources.
Build Snowpipe and Streams/Tasks workflows for assigned ingestion patterns.
Partner with Analytics Engineering to land data in the shapes downstream models expect.
Participate in the on-call rotation for the platform once ramped (target: month 3–4).
Respond to alerts, triage incidents, and lead resolution for assigned components.
Maintain dashboards and alerting for assigned pipelines and warehouses.
Write postmortems and contribute corrective actions back into the platform.
Pair regularly with the Senior to learn architecture patterns and decision-making.
Drive your own ramp on Snowflake, Terraform, and the JD Power data stack.
Contribute to internal documentation, runbooks, and onboarding materials.
Pursue SnowPro Core certification within the first 6–9 months.
ward senior level (architecture contributions, cross-team influence).

Benefits

JD Power is committed to employing a diverse workforce. Qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, gender expression, veteran status, or disability.
Should you require accommodations during the recruitment and selection process, please reach out to [email protected].
JD Power does not disclose your personal data to unauthorized third parties.
JD Power may from time to time also use third parties to act on JD Power’s behalf.
You agree to the fact that to the extent necessary your personal data may be transferred and/or disclosed to any company within JD Power group of companies as well as to third parties acting on JD Power’s behalf, including also transfers to servers and databases outside the country where you provided JD Power with your personal data.
Such transfers may include for example transfers and/or disclosures outside the European Economic Area and in the United States of America.
If you are a California or United Kingdom resident, additional disclosures about the information we collect and how we use that information can be found by clicking here.
To all recruitment agencies: JD Power does not accept unsolicited agency resumes and we are not responsible for any fees related to unsolicited resumes.