Jobs
>
Springfield

    Data Warehouse Architect - Springfield, United States - Blackspoke

    Blackspoke
    Blackspoke Springfield, United States

    2 weeks ago

    Default job background
    Description

    **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 ** **for more information.**



  • cBEYONData Washington, United States

    Job Description · Job DescriptioncBEYONData is seeking a Data Warehouse Architect with an active Top-Secret clearance to join a Data Warehouse and BI development team supporting our federal client. The Data Warehouse Architect will support maintaining and enhancing the Enterprise ...


  • Steel Point Solutions Washington, United States

    Job Description · Job DescriptionSteel Point Solutions is an amazing SBA Certified (8a), HUBZone, Small Disadvantaged Business (SDB) and a Woman Owned Small Business (WOSB) company. Established in 2013 with a vision of offering world class, integrated business solutions for all l ...


  • vTech Solution Washington, United States

    Job Description · Job DescriptionvTech Solution Inc is hiring Data Warehouse Architect · About us: · Job Location:Chesterfield, VA 23832 · Job Duration: 16 Months · Interview mode: Both Web Cam and In Person Interview · ***** Richmond area candidates or those willing to reloca ...


  • The Salvation Army National Headquarters Alexandria, United States

    **JOB SUMMARY**: · The Data Warehouse Administrator is responsible for managing and optimizing the performance of a data warehouse, ensuring the integrity, security, and efficient storage and retrieval of data. This role involves collaborating with database developers, data archi ...

  • Precision Solutions

    Data Architect

    2 weeks ago


    Precision Solutions Washington, United States

    Overview: · **Data Architect** · Hybrid | Washington D.C. | 2-3 days a week Onsite · Active TS/SCI Clearance Required · **Summary** · Our client is an employee and Service-Disabled, Veteran-owned Small Business focused on providing niche technical services. They are a team of exp ...


  • US Architect of the Capitol Washington, United States

    **Duties**: · **NOTE - must be able to obtain and maintain a Top Secret clearance** · **Duties quoted below are at the GS-13 level.** · The Logistics Management Specialist (Warehousing And Distribution), provides a full range of logístical and supply chain management support acro ...

  • eTelligent Group LLC

    Data Architect

    2 weeks ago


    eTelligent Group LLC Washington, United States

    **Company Overview**: · For the past 15+ years, eTelligent Group has consistently delivered excellent services that are demonstrated through our exceptional past performances. As a small business, we have distinguished our company as effective problem solvers with innovative, sca ...


  • AHU Technologies Inc Washington, United States

    Role **:Data Architect** · **Client : State of DC** · **Location **:Washington, DC · Job Description: · 6-10 years of experience. Designs and builds relational databases. Performs data access analysis design, and archive/recovery design and implementation. · **Complete Descriptio ...


  • US Federal Bureau of Investigation Washington, United States

    **Duties**: · **GS-11**: · - Provides adequate housing for FBI personnel space needs including office, warehouse, storage, computer facilities, garage, photographic, facilities, and other types of specialized facilities; ensures adequate funding is available for the acquisition a ...

  • 9th Way Insignia

    Power BI Sme

    2 weeks ago


    9th Way Insignia Washington, United States

    **Company Introduction** · **Team (Project) Introduction** · 9th Way Insignia is looking for an expert-level Microsoft Power BI developer with data warehouse and analytics experience to join this team. · **Professional Level Information**: · The Power BI Developer Expert aligns t ...

  • Rycon Construction

    Estimator

    1 day ago


    Rycon Construction North Bethesda, United States

    Rycon Construction, Inc. is an employee-owned company (ESOP) that provides construction management, general contracting, and design-build services nationwide. Rycon is an ENR Top 400 Contractor, ENR Top 100 Green Contractor, and is celebrating our 35th anniversary this year We ha ...


  • Rycon Construction North Bethesda, United States

    Rycon Construction, Inc. is an employee-owned company (ESOP) that provides construction management, general contracting, and design-build services nationwide. Rycon is an ENR Top 400 Contractor, ENR Top 100 Green Contractor, and is celebrating our 35th anniversary this year We ha ...


  • Peraton Springfield, United States

    Responsibilities: · Mid-level Cloud Architects support the planning and development of cloud services architectures for the Government mission data warehouse. The initial focus is on providing systems engineering and AWS technical support in reviewing, fulfilling, and monitoring ...


  • Peraton Springfield, United States

    About Peraton Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deli ...


  • Syms Strategic Group, LLC Springfield, United States

    Syms Strategic Group (SSG) is seeking a talented Senior Database Architect · Department: Veterans Affairs · Location: On-site, Washington, DC · Type: Full Time · Min. Experience: Experienced · Security Clearance Level: Public Trust (MBI) · Salary Range: $118,737 - $140,000 ...

  • Marathon TS

    Data Engineer

    1 week ago


    Marathon TS Springfield, United States

    Marathon TS is looking for a Data Engineer to support our end client. · The ideal candidate will provide Data integration and senior level engineering and design services related to data integration in support of an enterprise-level ICAM solutions using Radiant Logic, SailPoint a ...


  • Peraton Springfield, United States

    About Peraton Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deli ...


  • SAIC Springfield, United States

    · The Vanguard 2.2.1 program currently has an opening for a Data Integration Engineer supporting the Department of State (DoS) Bureau of Information Resource Management (IRM). · The position may allow temporary hybrid remote work due to Covid-19. Position may be called back onsi ...


  • SAIC Springfield, United States

    Description · The Vanguard 2.2.1 program currently has an opening for a Data Integration Engineer supporting the Department of State (DoS) Bureau of Information Resource Management (IRM). · The position may allow temporary hybrid remote work due to Covid-19. Position may be calle ...

  • NV5

    Geospatial Analyst

    1 week ago


    NV5 Springfield, United States

    Overview · Are you searching for a role where you can grow, work with a team of like-minded geospatial experts, and use your unique skill set to make the world a safer place? NV5 Geospatial's (formerly Axim Geospatial) GEO-SPI B program is ideal for geospatial professionals to le ...