Senior Snowflake Data Platform Engineer - Remote

JD Power; Michigan; Sur place; USD 120 000 - 150 000; Plein temps

Résumé du poste

JD Power is seeking a Senior Data Platform Engineer to own and evolve the enterprise Snowflake data platform for analytics, product, and AI/ML workloads. You will translate architecture directions into a production-grade, automated, observable environment with strong security and cost governance.

You will manage Snowflake objects, Terraform-based deployments, and CI/CD, while partnering with InfoSec and Compliance to ensure audit readiness.

Qualifications

• 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.

Responsabilités

• 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.

Connaissances

Snowflake

SQL

Python

Terraform

CI/CD

AWS

Security & IAM

Data Platform

Outils

Terraform

Schemachange

Liquibase

dbt

Airflow

Fivetran/Airbyte

Snowpipe

Description du poste

JD Power is seeking a Senior Data Platform Engineer to own and evolve the enterprise Snowflake data platform for analytics, product, and AI/ML workloads. You will translate architecture directions into a production-grade, automated, observable environment with strong security and cost governance.

You will manage Snowflake objects, Terraform-based deployments, and CI/CD, while partnering with InfoSec and Compliance to ensure audit readiness.