1+ months

AWS Snowflake Admin

Washington, DC 20004
Apply Now
Apply on the Company Site
Peraton Overview

Peraton drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the worlds leading mission capability integrator and transformative enterprise IT provider, we deliver trusted and highly differentiated national security solutions and technologies that keep people safe and secure. Peraton serves as a valued partner to essential government agencies across the intelligence, space, cyber, defense, civilian, health, and state and local markets. Every day, our 22,000 employees do the cant be done, solving the most daunting challenges facing our customers.


Requires 10 to 12 years with BS/BA or 8 to 10 years with MS/MA or 5 to 7 years with PhD.

  • Experience with ETL concepts and DWH
  • Experience using Snowflake SQL and implementing stored procedures
  • Good understanding of Snowflake Timetravel concepts and zero copy cloning ,Network policies, clustering and tasks
  • Experience with Snowflake advanced concepts like setting up RBAC control , resource monitors , Virtual warehouse sizing and Query Performance tuning.
  • Experience using Python connector and Spark Connector for snowflake.
  • Good experience using AWS S3 data storage, privatelink , VPC , EC2
  • Experience using Github.
  • Experience in Python ,Apache airflow
  • Experience in Administrating Cloud environments, such as AWS.
  • Experience Administering/Sizing Clusters, such as Redshift/Snowflake/DataBricks/Hadoop.
  • Experience in CI/CD pipelines, agile methodologies and DevOps styled deployments.
  • Expert knowledge of Cloud components such as DevOps scripts, S3 access management and applications configuration.
  • Experience in Data Organization skills, Partitioning strategies, Data retention policies.
  • Excellent investigative skills to find root cause for AWS Cloud problems, to perform Impact analysis for proposed changes.
  • Ability to identify and create detailed requirements.
  • Ability to collaborate and coordinate with other contract Government resources.
  • Industry experience a plus (Medicare, Medicaid, Healthcare or commercial insurance).


Peraton has an immediate need in our Health Payer Segment for a Snowflake Admin to support the Centers for Medicare and Medicaid Services (CMS) Integrated Data Repository (IDR) Cloud Migration Contract. Ability to achieve Public Trust Clearance is required. Must be a US Citizen or a Green Card Holder who has worked in the US three out of the past five years.

The IDR responds to the Agencys critical need to have an integrated data environment that contains Medicare and Medicaid data (e.g. claims, beneficiary, provider, and plan data). The underlying technology of the IDR is an integrated Hadoop and Teradata Enterprise Data Warehouse. It supports the massive volumes of data associated with CMS program benefits. This data warehouse is migrating to the cloud. This cloud migration will include migrating data from IDR Teradata, migrating IDR streams, setting up the IDR Cloud Data Warehouse, and establishing an Operations and Maintenance plan.

POSITION OVERVIEW: The Snowflake Admin will be responsible for providing administrative support to an AWS Cloud data warehouse, addressing issues, and supporting activities needed to maintain the IDR Cloud AWS environment.

Key Responsibilities
  • Manage Snowflake utilities such as SnowSQL, SnowPipe, Big Data model techniques using Python
  • Setting up resource monitors, Deploying RBAC controls, virtual warehouse sizing and query performance tuning
  • Deploy Snowflake features such as data sharing
  • Configure Storage integration to access AWS S3 and create stage objects.
  • Work with version control tools (github)
  • Configure AWS PrivateLink to access Snowflake account
  • Applies subject matter knowledge to solve common and complex data issues within established guidelines and recommends appropriate actions.
  • Supports Cloud Migration teams projects with AWS Cloud expertise.
  • Supports operation of the IDR Cloud AWS environment.
  • Provide user access/security/release/schedules management.
  • Work with federal and contractor staff to identify Cloud Migration requirements.
  • Follow established CMS standards for implementing Cloud configurations.
  • Collaborate and coordinate with the other contract Government Task Leads as directed by CMS.
  • Works on problems / projects of diverse complexity and scope.
  • Exercises independent judgment within generally defined policies and practices to identify and select a solution.
  • Strong proven analytical ability and ability to solve problems independently

For Colorado Residents
Colorado Salary Minimum: $96,928.00 Colorado Salary Maximum:$207,209.60 The estimate displayed represents the typical salary range for this position, and is just one component of Peraton's total compensation package for employees. Other rewards may include annual bonuses, short- and long-term incentives, and program-specific awards. In addition, Peraton provides a variety of benefits to employees.


  • Information Technology
Posted: 2021-06-29 Expires: 2023-10-01

With offerings in mission services, digital transformation and enterprise operations, our team of 14,000 engineers, analysts, investigators and architects work tirelessly to create innovative solutions. We have the expertise and experience not only to devise solutions, but to execute on them successfully.

Sponsored by:
ADP Logo

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

AWS Snowflake Admin

Washington, DC 20004

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast