2 days old

Data Warehouse Analyst Senior Technical Specialist

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

Health

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.


Responsibilities

Business Group Highlights

Health

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.

Position:

Perspecta has an immediate need in our Health Payer Segment for an ETL Developer to support the Centers for Medicare and Medicaid Services (CMS) Integrated Data Repository (IDR). 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 IDR is the largest government Teradata database in the world it is currently a one Petabyte Teradata system complimented by a two petabyte Hadoop system with 667 usable terabytes serving over 2,500 users. 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. The IDR is currently migrating to an AWS cloud environment.

Position Overview: This position is for the CIO-SP3 Contract supporting the Integrated Data Repository Operations & Maintenance task order. The position requires the individual to analyze Medicare claims data and other sources of information for inclusion in Data Warehouse. The IDR is a Teradata database (migrating to AWS) and ETL is used to map data from source to the warehouse. The mission of this contract is to support CMS in efforts to maintain the Integrated Data Repository.

Key Responsibilities

  • Analyze new data sources for inclusion into the enterprise data warehouse;
  • Work with federal and contractor staff to identify ETL (extract, transform, load) requirements;
  • Create and update Interface Control Documents (ICDs);
  • Create ETL Functional specifications that document source to target mappings;
  • Create new Informatica ETL streams for additional data sources such as the Shared Systems, Providers systems, or other claims related data;
  • Follow established CMS standards for implementing Informatica ETL on an IDR database. These standards include, but are not limited to, enforcing referential integrity and following purgatory requirements;
  • Collaborate and coordinate with the other contract Government Task Leads as directed by CMS;
  • ETL Utilizing IDR staging tables while following CMS standards.
  • Become knowledgeable on the IDR Data Model
  • Apply developed subject matter knowledge to solve common and complex data issues within established guidelines and recommends appropriate actions.
  • Work on problems / projects of diverse complexity and scope.
  • Exercise independent judgment within generally defined policies and practices to identify and select a solution.
  • Utilize strong proven analytical ability and ability to solve problems independently

Qualifications

Requires 12 to 15 years with BS/BA or 10 to 13 years with MS/MA or 7 to 9 years with Ph.D.

Qualifications:

  • Experience with developing ETL streams using Informatica and Teradata;
  • Experience with push down functionality of Informatica to maximize performance;
  • Solid investigative skills to find root cause for ETL problems;
  • Strong data analytical skills;
  • Ability to identify and create detailed requirements;
  • Ability to create ETL specifications and create data mappings;
  • Ability to collaborate and coordinate with other contract Government resources;
  • Good understanding of IDR processes;
  • Solid understanding of production IDR ETL streams.
  • Knowledge of SQL and Unix required, Teradata is the underlying database.
  • Knowledge of AWS, Informatica DEI, Databrick, Snowflake and Python extremely helpful
  • US Citizen

Essential functions:

  • Excellent organizational and communication skills
  • Strong communication skills
  • Ability to attend meetings, training, and conferences.
  • Can work remotely but must have high speed internet access and voice mail
Salary Minimum: $97,760.00 Salary Maximum:$209,019.20 The estimate displayed represents the typical salary range for this position, and is just one component of Perspecta's total compensation package for employees. Other rewards may include annual bonuses, short- and long-term incentives, and program-specific awards. In addition, Perspecta provides a variety of benefits to employees.
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 - All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

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

Industry

  • Information Technology
Posted: 2021-04-18 Expires: 2021-05-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.

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:

Data Warehouse Analyst Senior Technical Specialist

Perspecta
Home, DC

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast