Senior Data Platform Engineer, Snowflake

J.D. Power • Ontario - Remote, ON

5d • $120,000 - $150,000 • Remote

About The Position

Own the hands-on engineering of JD Power's Snowflake data platform. Responsible for translating the Platform Lead's architecture and governance direction into a production-grade, automated, and observable Snowflake environment that supports analytics, product, and AI/ML workloads across the enterprise.

Requirements

• 5+ years of professional data platform, data engineering, or data infrastructure experience.
• 3+ years of hands-on Snowflake experience at production scale (not pilot/POC).
• Demonstrated expertise in Snowflake RBAC design, warehouse sizing and cost governance, performance tuning, and security features.
• Strong SQL — able to read and optimize a query profile.
• Python for tooling, automation, and pipelines.
• Production IaC experience — Terraform required; Snowflake provider strongly preferred.
• Database CI/CD using Schemachange, Liquibase, dbt, or equivalent change-management tooling.
• Cloud fluency in AWS — networking, IAM, storage, and Snowflake integration points.
• Ingestion experience with Snowpipe, Streams/Tasks, Kafka, and/or Fivetran/Airbyte.
• Communication — able to author decision records and runbooks; able to influence without authority.

Nice To Haves

• SnowPro Advanced certification (Architect, Data Engineer, or Administrator).
• Hands-on dbt and modern Analytics Engineering experience.
• Experience with Snowflake Horizon Catalog, Polaris, Collibra, or Alation.
• Streaming and CDC: Kafka, Debezium, Snowpipe Streaming, Dynamic Tables.
• Iceberg / lakehouse architecture.
• Data observability tooling (Monte Carlo, Bigeye, Datadog).
• Automotive, financial services, insurance, or regulated consumer-data experience.
• AI/ML workloads on Snowflake (Cortex, Snowpark, feature stores).

Responsibilities

• Owns Snowflake account, warehouse, and object architecture.
• Infrastructure-as-Code repository and CI/CD for all Snowflake changes.
• RBAC implementation, security controls, and identity integration.
• Ingestion and integration patterns (Snowpipe, Streams/Tasks, managed connectors).
• Platform observability, cost monitoring, and performance tuning.
• Documentation, runbooks, and onboarding patterns for platform consumers.
• Design and evolve Snowflake account, warehouse, and object architecture.
• Implement and maintain all Snowflake objects, roles, and policies in Terraform.
• Operate database CI/CD using Schemachange, Liquibase, or equivalent.
• Tune performance: clustering, search optimization, materialized views, query profiling.
• Build and maintain the functional/access role hierarchy enforcing least privilege.
• Implement masking policies, row access policies, object tagging, and network policies.
• Integrate Snowflake with IdP for SSO/SCIM; manage service accounts and key rotation.
• Partner with InfoSec, Privacy, and Compliance on audit readiness and control attestation.
• Operate Snowpipe, Snowpipe Streaming, Streams/Tasks, and Kafka Connector pipelines.
• Manage Fivetran/Airbyte (or equivalent) connector deployments and reliability.
• Implement Iceberg / external tables where lakehouse interoperability is required.
• Integrate with orchestration (Airflow / dbt Cloud) and observability tooling.
• Define and meet SLOs for platform reliability, freshness, and cost.
• Build dashboards and alerting; lead incident response for platform issues.
• Document architecture decisions, patterns, and runbooks.
• Enable Analytics Engineering, Product Engineering, and Data Science consumers.

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.
• To all recruitment agencies: JD Power does not accept unsolicited agency resumes and we are not responsible for any fees related to unsolicited resumes.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed