Senior Data Platform Engineer, Snowflake

JD Power; City of Troy (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

JD Power is seeking a Senior Data Platform Engineer to own hands-on engineering of the Snowflake data platform in a remote US/Canada setting. You will translate architecture into a production-grade, automated, observable Snowflake environment supporting analytics, product, and AI/ML workloads.

You will manage Snowflake accounts, Terraform-based IaC, RBAC and security, Snowpipe, Streams/Tasks, and data ingestion pipelines, while driving platform observability, cost governance, and runbooks for

Qualifications

• 5+ years of professional data platform experience.
• 3+ years Snowflake production experience.
• Snowflake RBAC design and cost governance expertise.
• Strong SQL skills and query optimization.
• Python for tooling, automation, and pipelines.
• IaC experience with Terraform; Snowflake provider preferred.
• Cloud AWS experience including networking, IAM, storage, and Snowflake integrations.
• Ingestion experience with Snowpipe/Streams/Tasks and Kafka; familiarity with Fivetran/Airbyte.
• Effective communication and ability to document decisions and runbooks.

Responsibilities

• Own Snowflake account, warehouse, and object architecture.
• Maintain Terraform-based Snowflake objects and CI/CD pipelines.
• Implement and enforce security controls and IdP integration.
• Manage Snowpipe/Streams/Tasks and data ingestion pipelines.
• Ensure platform observability, cost governance, and performance tuning.
• Develop runbooks and enable platform consumers across teams.

Skills

Snowflake

SQL

Python

Terraform

CI/CD

RBAC design

Education

Bachelor's degree in CS/Engineering/Math

Tools

Schemachange

Liquibase

dbt

Fivetran/Airbyte

Airflow/dbt Cloud

Job description

Job Title

Senior Data Platform Engineer

Location

Remote – USA, Canada

Reports to

SVP, Engineering

Vacancy

New vacancy

The Role

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.

Scope & Ownership

You Will Have in This Role:

• 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.
• Does not own Governance policy and strategy (owned by the Platform Lead).
• Business data modeling and semantic layer (owned by Analytics Engineering).
• Source system data quality at point of capture (owned by upstream teams).

What You’ll Be Doing in This Role

Platform engineering

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

Security and governance enforcement

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

Ingestion and integration

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

Operational excellence

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

Qualifications of this Role

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

Preferred Qualifications

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

Salary

This position has a starting salary range of $120K -$150K USD/$110K -$120K CAD per year. This is the range we reasonably and in good faith expect to pay for the role at the time of posting. An employee’s pay within the range is determined by a number of factors, including relevant skills, education, qualifications, experience, performance, business or organizational needs, and geographic location.

Our Values

We POWER Our Customer’s Success We are Innovative, Collaborative and Grounded and in Data We Make Things Easy We Get It Done We Start with Trust & Prove it Everyday 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.

Why Join JD Power

• We power our customers’ success. Everything we do is focused on helping customers make better decisions and achieve better outcomes.
• We are innovative, collaborative, and grounded in data. We combine advanced analytics with human expertise to deliver insight that holds up in the real world.
• We make things easy. We turn complexity into clarity so teams can act faster and with confidence.
• We get it done. We focus on execution, accountability, and results.
• We start with trust and prove it every day. Independence, integrity, and credibility are the foundation of our work.

Equal Opportunity & Accommodations

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.

JD Power is committed to providing reasonable accommodations throughout the recruitment process for individuals with disabilities or other protected needs under applicable local laws.

Please contact [e-mail] for accommodation request.

Data Privacy

JD Power does not disclose your personal data to unauthorized third parties. However, as a global corporation consisting of multiple affiliated companies in various countries, JD Power has international sites and JD Power uses resources located throughout the world. 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.

Welcome to JD Power Careers!

JD Power is a proven leader in business-critical data and intelligence to drive auto‑related decisions with confidence and clarity. By leveraging unmatched proprietary data, advanced analytics and deep industry expertise, JD Power fuels original equipment manufacturers, retailers, lenders, insurers and partners to enhance their performance. Since 1968, JD Power has delivered incisive guidance and intelligence about customer interactions with brands and products. To learn more about the company, visit JDPower.com.