**Data Warehouse Architect | TS/SCI**

Springfield, VA

**Customer Description**

Our customer is an Intelligence Agency (IA) delivering world-class geospatial intelligence providing a decisive advantage to policymakers, war-fighters, intelligence professionals and first responders. The customer enables all of these critical actions and shapes decisions impacting our world through the indispensable discipline of geospatial intelligence (GEOINT). Our customer is a unique combination of intelligence and combat support agency. It is the world leader in timely, relevant, accurate, and actionable GEOINT. This IA enables the U.S. intelligence community (IC) and the Department of Defense (DOD) to fulfill the presidents national security priorities to protect the nation. Although GEOINT is the most critical data within this agency, all data that is produced, collected and stored plays a supportive role in the day-to-day operations of our customer.

**Program Description**

The program within the agency is the go-to-platform for the ingestion and surfacing of data within the agency. Its core mission is to provide an analytics and visualization platform for corporate business data sets such as; Information Technology, Cyber, Security, Financial, Contract, Customer Feedback, and Mission Management Activity. Ultimately this team will provide the Agency with the capability for a centralized authoritative data repository, refreshed automatically, from source systems of record and transaction databases along with a range of visualization tools for reporting and delivery to end-users.

BlackSpoke is the prime contractor on a program awarded to provide agile operations, adaptive maintenance, and minor enhancement services to support the maintenance, integration, and ingest of multiple business data sets into an analytic environment. This Intelligence Agency program is focused on human capital data, and also focused on activities to bring in other corporate business data sets such as; Information Technology, Cyber, Security, Financial, Contract, Customer Feedback, and Mission Management Activity. One goal for the program is to provide the Agency with the capability for a centralized authoritative data repository, refreshed automatically, from source systems of record and transaction databases along with a range of visualization tools for reporting and delivery to end-users.

**Team Description**

The Blackspoke 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.

****Job Description****

**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 Amazons 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.

**Qualifications**

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

**Equal Opportunity Employer/Veterans/Disabled. Individuals with disabilities, including disabled veterans or veterans with service-connected disabilities, are encouraged to apply. If you need assistance applying outside of the online application, please contact ...@blackspoke.com** **for more information.**