Data Platform Engineer, Snowflake

JD Power is a company focused on powering auto-related decisions through data and analytics. They are seeking a Data Platform Engineer to execute and extend engineering patterns, manage Snowflake objects and pipelines, and contribute to platform reliability and support.

Responsibilities:

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

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