2 days old

Snowflake Engineer

Home, DC
Apply Now
Apply on the Company Site
Business Group Highlights


The Health group provides solutions to help government healthcare agencies lower administrative costs, reduce fraud and abuse, and improve the quality of services for individuals. We also provide analytics that combine clinical knowledge with big data technology and techniques to transform petabytes of data into meaningful solutions for our customers.


Perspecta has an immediate need in our Health Payer Segment for a Snowflake Engineer to support the Centers for Medicare and Medicaid Services (CMS) Integrated Data Repository (IDR) Cloud Migration Contract. The position is remote although a location close to Baltimore would be helpful. 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 Integrated Data Repository (IDR) is the centerpiece of CMS Enterprise Data Warehouse Strategy. 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 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 position requires Snowflake technical expertise to support a large and complex Cloud Data warehouse migration (from a Teradata on-prem data warehouse to Snowflake). This position requires an individual experienced in deploying Snowflake best practices, developing complex data models in Snowflake, tuning, monitoring and maintaining the Snowflake data warehouse. Knowledge of Erwin Data Modeler is important as it will be used to accelerate Cloud Migration from the current on-prem data model/Teradata data warehouse to Snowflake.

Key Responsibilities

  • Apply Snowflake best practices to Snowflake Data Warehouse
  • Developing complex data models in Snowflake
  • Monitoring, maintaining and tuning Snowflake
  • Data Modeling using Erwin
  • Applies subject matter knowledge to solve common and complex data issues within established guidelines and recommends appropriate actions.
  • Supports Cloud Migration teams projects with technical expertise.
  • Provides forward looking guidance to team and CMS on projects and impacts.
  • Provides estimates for projects.
  • Provides impact analysis on possible projects.
  • 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.
  • Becomes knowledgeable on the IDR Data Model.
  • 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


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

  • Expert knowledge of Snowflake
  • Experience developing complex data models in Snowflake
  • Experience monitoring, maintaining and tuning Snowflake
  • Expert knowledge of Erwin for Data Modeling
  • Expert knowledge of SQL and Unix required.
  • Experience with a Cloud Data warehouse tools, such as Databricks, is beneficial.
  • Strong data analytical skills.
  • 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).
  • Agile software development experience is required
  • Client Facing Experience required
  • Expertise with Microsoft Office Suite, especially MS Project and Excel required
  • Experience working with the Federal Government required
  • Experience with the CMS Targeted Lifecycle (TLC) is beneficial
  • Medicare, Medicaid or private healthcare experience is beneficial
  • Excellent organizational, communication, and time management skills
  • Ability to work effectively in a team
  • Experience working with clients and technicians
  • Pro-active in seeking problem resolution
  • Quick learn of new systems, tools, processes
  • Self-starter and able to deal with ambiguity

About Perspecta

What matters to our nation, is what matters to us. At Perspecta, everything we do, from conducting innovative research to cultivating strong relationships, supports one imperative: ensuring that your work succeeds. Our company was formed to bring a broad array of capabilities to all parts of the public sectorfrom investigative services and IT strategy to systems work and next-generation engineering.

Our promise is simple: never stop solving our nations most complex challenges. And with a workforce of approximately 14,000, more than 48 percent of which is cleared, we have been trusted to do just that, as a partner of choice across the entire sector.

Perspecta is anAA/EEOEmployer - Minorities/Women/Veterans/Disabled and other protected categories.

As a government contractor, Perspecta abides by the following provision

Pay Transparency Nondiscrimination Provision

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of the other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractors legal duty to furnish information. 41 CFR 60-1.35(c).


  • Information Technology
Posted: 2020-09-20 Expires: 2020-10-20

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.

Featured Job

Featured Employer

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:

Snowflake Engineer

Home, DC

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast