Key skills
SnowflakeTerraformSQLPythonSchemachangeLiquibasedbtAWSSnowpipeStreams/TasksKafkaFivetranAirbyteRBACPerformance tuningSecurity controlsIdentity integrationIcebergSnowflake Horizon CatalogPolarisCollibraAlationDebeziumDynamic TablesData observability toolingAI/ML workloads on SnowflakeAIMLData EngineeringAnalyticsAirflowIAMSSODatadogRepositoryCI/CDCommunication
About this role
JD Power is a company that aims to power every auto-related decision through proprietary data and advanced analytics. They are seeking a Senior Data Platform Engineer to own the engineering of their Snowflake data platform, ensuring it supports analytics, product, and AI/ML workloads across the enterprise.
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
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
- 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)