Note: The job is a remote job and is open to candidates in USA. Peraton is a national security and enterprise IT company that delivers mission-focused technology solutions for government agencies and the U.S. armed forces. The Senior Snowflake Data Engineer with Administration Experience will design, develop, deploy, and optimize data pipelines while providing backup Snowflake platform administration, including data modeling, performance tuning, RBAC, cost optimization, and recovery. The role collaborates with product owners, engineers, architects, and Agile teams to meet performance, security, and architectural standards.
Responsibilities
- The **Senior Snowflake Data Engineer** with Administration Experience will be responsible for the design, development, deployment and optimization of data pipelines and will also play the role of backup Snowflake admin
- The **Senior Snowflake Data Engineer** will split responsibilities between hands-on data engineering (pipeline development, data modeling, performance tuning) and backup platform administration (RBAC, cost optimization, backup recovery)
- They will work closely with Product Owners, Data Engineers, Architects, and Scrum/Kanban teams to ensure alignment with platform performance standards, security requirements, architectural designs, and Agile delivery expectations
Skills
- 7+ years of overall tech experience as Snowflake/Java/Python/ETL Developer and 2+ year of Snowflake Administration
- Ability to work independently and effectively with little to no supervision
- Strong Snowflake Platform Administration and Development experience, including virtual warehouse optimization, complex RBAC design, data modeling, and schema management
- Deep understanding of Snowflake architecture (Storage, Compute, Cloud Services, Time Travel, Fail-safe, and Zero-Copy Cloning)
- Hands-on experience developing efficient data pipelines, utilizing Snowflake features like Snowpipe, Streams, Tasks, and Stored Procedures (SQL/Python/Java)
- Must have advanced SQL skills for writing complex analytical queries, data transformation, performance tuning, and query profiling
- Demonstrated ability to use Python or shell scripting to automate database administration and data engineering workflows
- AWS experience (managing IAM roles, security policies, and S3 external stages)
- Team player with excellent executive function and communication skills
- US Citizen or Green Card
- Ability to obtain a Public Trust clearance
- Minimum of 12 years with BS/BA; Minimum of 10 years with MS/MA; Minimum of 7 years with Ph.D
- Prior Java, Python, or other object-oriented software development experience
- Experience designing and implementing disaster recovery, data replication, and backup/failover strategies in Snowflake across regions or cloud providers
- Scaled Agile Framework (SAFe) experience; certification preferred
- Snowflake certifications (SnowPro Core, Advanced Administrator, or Advanced Data Engineer)
- Infrastructure as Code (IaC) experience using Terraform or Schemachange for Snowflake object and pipeline provisioning
- CLI Linux experience and automation of cloud-native data architectures
- FinOps and cost-optimization experience (implementing resource monitors, credit alerts, and optimizing warehouse compute efficiency for incremental loads)
- Experience working with Centers for Medicare and Medicaid (CMS) information systems
- CMS/Medicare or Medicaid claims data experience
Benefits
- Remote work allowed 100%
- Employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay
Company Overview