Senior Snowflake Data Engineer & Admin Lead

Peraton; Reston (VA); On-site; USD 135,000 - 216,000; Full time

Job summary

Peraton is seeking a Senior Snowflake Data Engineer to design, develop, deploy, and optimize data pipelines in Snowflake while serving as a backup Snowflake administrator. You will collaborate with cross‑functional teams to meet security, performance, and architectural requirements.

The role requires extensive Snowflake experience, strong SQL, Python/Java, and AWS skills, plus ability to work independently and obtain Public Trust if needed. US citizenship or GC is required.

Qualifications

• 7+ years of Snowflake/Java/Python/ETL development with 2+ years Snowflake administration.
• Ability to work independently with minimal supervision.
• Snowflake platform administration and development incl. virtual warehouses, RBAC, data modeling, and schema management.
• Deep understanding of Snowflake architecture (Storage, Compute, Time Travel, Fail‑safe, Zero‑Copy Cloning).
• Hands‑on experience with Snowflake features: Snowpipe, Streams, Tasks, Stored Procedures (SQL/Python/Java).
• Advanced SQL skills for complex analytics, data transformations, performance tuning, and query profiling.
• Python or shell scripting to automate DB admin and data engineering workflows.
• AWS experience (IAM roles, security policies, S3 external stages).
• Team player with strong communication; US Citizen or Green Card; ability to obtain Public Trust clearance.

Responsibilities

• Design, develop, deploy, and optimize data pipelines in Snowflake.
• Serve as backup Snowflake administrator with RBAC and cost optimization.
• Collaborate with Product Owners, Data Engineers, Architects, and Agile teams.
• Ensure platform performance, security requirements, and architectural alignment.

Skills

Snowflake Administration

SQL

Python

Java

ETL Development

AWS

RBAC Design

Data Modeling

Stored Procedures

Shell Scripting

SAFe

Disaster Recovery

Snowflake Certifications

Terraform

IaC

Linux CLI

FinOps

CMS Data Experience

Education

BS/BA in Computer Science or related field

MS/MA in Computer Science or related field

PhD in a relevant field

Tools

Terraform

Schemachange

Snowflake

Job description

Peraton is seeking a Senior Snowflake Data Engineer to design, develop, deploy, and optimize data pipelines in Snowflake while serving as a backup Snowflake administrator. You will collaborate with cross‑functional teams to meet security, performance, and architectural requirements.

The role requires extensive Snowflake experience, strong SQL, Python/Java, and AWS skills, plus ability to work independently and obtain Public Trust if needed. US citizenship or GC is required.