This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

Find jobs in Virginia today!

To post a job, login or create an account |  Post a Job

  Jobs in Virginia  

Bringing the best, highest paying job offers near you

previous arrow
next arrow

Data Warehouse Architect (TS/SCI)


This is a Full-time position in Alexandria, VA posted February 3, 2021.

Calling all Data Warehouse Architect (TS/SCI)

This Jobot Job is hosted by: Mordy Ornguze
Are you a fit? Easy Apply now by clicking the “Apply on company site” button and sending us your resume.
Salary: $150,000 – $200,000 per year

A bit about us:

Team Description: ***This position requires an active TS/SCI Security Clearance***

Our team consists of various experts within the IC that are highly focused on Cloud Architecture & Design, Data Architects & Scientists, Data Visualization Experts, User Interface & User Experience (UI/UX) Experts, Database Warehouse & Mining Experts, and Scrum Masters that will help achieve and mission objectives.

Why join us?

  • Competitive Base Salary!
  • Extremely Competitive Equity Package!
  • Flexible Work Schedules!
  • Accelerated Career Growth!

Job Details

***This position requires an active TS/SCI Security Clearance***

Data Warehouse Architect with experience in the design, deployment and support of a SQL based architecture as a foundation for a large data warehouse. Your role as the Data Warehouse Architect will be to work with the entire team to collect requirements, perform baseline performance captures, and optimize the future of the platform by designing and deploying a highly available, highly resilient SQL system in Amazon’s JWICS version of AWS, called Commercial Cloud Service, or C2S.

We support a data warehouse that ingests from 30+ separate data sources daily. Based on these data sets, our data warehouse provides the data that drives the analytics in use by the Data Scientists within the Agency.

Desired Core Skills:

  • Data Modeling – performing data modeling with tools such as Erwin, ER/Studio, or WhereScape for new data sets for ingestion into our data warehouse.
  • Data Ingest – Extensive experience in building data integration pipelines performing the automated ingest of data from multiple data sources database (Oracle, SQL, Informix, MsSQL, Postgres).
  • Programming / code development – use of programming and code to automate data ingest functions for the extract and load of data using Visual Studio, C#, Python, etc.
  • Job scheduling – scheduling the automated ingest of the data to include error reporting as well as data validation checks using SQL Server Integration Services (SSIS) or WhereScape.
  • Data Warehouse Methodology – Perform data modeling following Data Vault 2.0 methodology, Third normal form (3NF), Star Schema, etc.

Interested in hearing more? Easy Apply now by clicking the “Apply on company site” button.

AL Jobs AR Jobs CA Jobs GA Jobs KS Jobs KY Jobs LA Jobs MD Jobs MI Jobs MN Jobs MS Jobs MO Jobs NY Jobs OR Jobs TN Jobs TX Jobs UT Jobs VA Jobs WV Jobs ID Jobs