Data Warehouse Architect

1 month ago

Washington, United States Seneca Resources Full time

Position Title: Datawarehouse Architect

Location: Remote

Clearance Requirements: Must be able to obtain a Public Trust Clearance

Position Status: Contract


Job Description

TASK 1 – Construction and Implementation of new Data Warehouse(s)

  • Complete gathering of user requirements, Performance Indicators, and use cases for the data warehouse.
  • Construct, test, implement and maintain ETLs (Extract, Transform, and Load) processes for the data warehouses.
  • Finalize and implement data warehouse prototype including design of schema structures, staging areas, data marts, fact tables, dashboards and use cases.
  • Maintain and modify data warehouse and ETLs as user requirements evolve.
  • Using a similar methodology, construct and implement additional data warehouses as required.
  • Provide technical documentation of all data warehouses and their components as required.


TASK 2 – Implementation of COTS/Government Software to replace Legacy systems

  • Provide technical research and recommendations for COTS software or government-provided software to replace Legacy systems.
  • Provide technical support for Legacy to COTS/Government software data mapping.
  • Provide technical support for development of Legacy to COTS/government software data migration plans.
  • Provide technical support for identification of Legacy features to be implemented in the COTS/government software environment.
  • Provide technical support for develop and document system cut-over plans.
  • Provide user liaison support to ensure system functionality is retained and/or improved.
  • Provide technical support for User Acceptance Testing. Document results and ensure defects are corrected.
  • Construct and execute data migration scripts as needed.
  • Provide user and technical documentation as needed.
  • Construct, test, and implement interfaces as required for the new COTS/government system to other Govt systems.


TASK 3 – Development and Modification of Multi-Agency Interfaces

Contractor shall provide technical support in the development and implementation of new or existing interfaces with various partnering agencies. These interfaces include the import and export of data and documents. Some of these interfaces involve loading the data and documents to a staging area and then subsequently processing the data to the application. Specific tasks shall include the following:

  • Provide support to modify current transaction loading and processing of data and documents in the current environment as need arises.
  • Transition current transaction environment from Oracle to SQL Server.
  • Transition current SOAP web services to REST API.
  • Modify current and new multi-agency interfaces to support loading data and documents to new staging area environments.
  • Migrate current processes to populate data sources with transaction data and documents from new staging areas.
  • Conduct interface testing - internally and externally with other agencies as needed.
  • Go Live and post-implementation support.


TASK 4 - Web Development of User Interfaces on Existing and New Applications

Contractor shall support the development and implementation of updated user interfaces using Web technologies on existing and/or new applications. In addition, MS SQL Server database in an MS Windows environment will be used for the backend RDBMS. Specific tasks shall include the following:

  • Analysis of user requirements documented in a Functional Requirements Document
  • Design and creation of data structures and database objects in MS SQL Server environment.
  • Design of the new module, interfaces documented in a Design Document
  • Construction of forms, reports, interfaces, and processes required for User Interface
  • Migration of data to the new MS SQL Server environment, as needed.
  • Unit and system integration testing
  • Go Live and post-implementation support


TASK 5 – Provide Maintenance Support for Existing Applications and Processes

Contractor shall support the development and implementation of required modifications for existing applications, processes, and interfaces. Specific tasks shall include the following:

  • Develop a system architecture document to illustrate application inter-connectivity.
  • Design, develop, test, implement and document modifications of existing applications including, but not limited to, Oracle Forms and Reports, and MS Access.
  • Design, test and implement roles-based application access vs direct grants application access for Oracle applications.
  • Develop and implement solutions for identified application security issues.
  • Develop, implement, and maintain scripting solutions for various interfaces including, but not limited to, MS Office 365 components and MS Windows.
  • Construct and execute mass data update scripts as required.
  • Conduct unit and system integration testing as required.
  • Provide Go Live and post-implementation support.
  • Provide recommendations and solutions for day-to-day user adhoc requests.


Deliverables, as required, for these tasks shall include, but not be limited to, the following:

  • Functional Requirements Documents
  • Business Process Flow Diagrams
  • Application and Database Design Documents
  • New and Modified Application Reports, Forms, Procedures and APIs
  • Technical Documentation
  • Data mapping documents
  • System cutover plans
  • Test Plans and Test Results
  • Interface Design Documents
  • Server Technical Specifications


About Seneca Resources:

Seneca Resources is a client driven provider of strategic Information Technology consulting services and Workforce Solutions to government and industry. Seneca Resources is a leading IT services provider with offices in Virginia, Alabama, Georgia, Florida and Texas that service clients throughout the United States.


We are an Equal Opportunity Employer and value the benefits of diversity in our workplace.

  • Senior Data Warehouse Solutions Architect

    4 weeks ago

    Washington, United States Seneca Resources Full time

    Job Title: Senior Data Warehouse Solutions ArchitectJob Summary:Seneca Resources is seeking a highly skilled Senior Data Warehouse Solutions Architect to join our team. The ideal candidate will have extensive experience in designing and implementing data warehouse solutions, leveraging their expertise in data modeling, ETL processes, and business...

  • Data Warehouse Architect

    1 month ago

    washington, United States Seneca Resources Full time

    One of our clients is hiring a Data Warehouse Architect:Location: Mostly remote but must be in the DC area to come onsite for meetings.Top Requirements:Data warehousing SQL Server Oracle Must be a US Citizen able to obtain a public trust clearanceJob Description:TASK 1 – Construction and Implementation of new Data Warehouse(s)• Complete gathering of user...

  • Data Warehouse Architect

    1 month ago

    washington, United States Seneca Resources Full time

    One of our clients is hiring a Data Warehouse Architect:Location: Mostly remote but must be in the DC area to come onsite for meetings.Top Requirements:Data warehousing SQL Server Oracle Must be a US Citizen able to obtain a public trust clearanceJob Description:TASK 1 – Construction and Implementation of new Data Warehouse(s)• Complete gathering of user...

  • Data Warehouse Architect

    1 month ago

    Washington, United States Seneca Resources Full time

    One of our clients is hiring a Data Warehouse Architect:Location: Mostly remote but must be in the DC area to come onsite for meetings.Top Requirements:Data warehousing SQL Server Oracle Must be a US Citizen able to obtain a public trust clearanceJob Description:TASK 1 – Construction and Implementation of new Data Warehouse(s)• Complete gathering of user...

  • Data Architect

    3 weeks ago

    Washington, United States Arena Technical Resources Full time

    Data Architect Location: Washington, DC, US Job ID: 16212 Job Description Job Description: Job Title: Data Architect Job Location: Washington, DC (1 day telework) clearance: Top Secret What you’ll do: You will support the execution of IT management and execution functions across units and systems, to build on the efficiencies gained through...

  • Data Warehouse Architect

    3 weeks ago

    Washington, DC, United States Seneca Resources Full time

    One of our clients is hiring a Data Warehouse Architect:Location: Mostly remote but must be in the DC area to come onsite for meetings.Top Requirements:Data warehousing SQL Server Oracle Must be a US Citizen able to obtain a public trust clearanceJob Description:TASK 1 – Construction and Implementation of new Data Warehouse(s)• Complete gathering of user...

  • Data Architect

    3 weeks ago

    Washington, United States Arena Technical Resources, LLC (ATR) Full time

    Job Description Job Title: Data Architect Job Location: Washington, DC (1 day telework) Clearance: Top Secret What you'll do: You will support the execution of IT management and execution functions across units and systems, to build on the efficiencies gained through centralization over the last several years in order to deliver improved quality, usability,...

  • Solution Architect

    3 weeks ago

    Washington, United States Tantus Technologies Full time

    Overview Tantus Technologies, Inc. (Tantus) - recognized by the Washington Post as a Top Workplace - is seeking an Solutions Architect to support a federal client. The Solutions Architect (Senior Data Warehouse Architect) will be responsible for designing and implementing advanced data solutions to support the project's goals and align with the overall...

  • Solutions Architect

    2 weeks ago

    Washington, United States Data Society Full time

    About Data Society GroupAt Data Society Group (DSG), we provide the highest quality, leading-edge industry-tailored data and AI training and solutions for Fortune 1,000 companies and federal, state, and local government organizations. We partner with our clients to educate, equip, and empower their workforces with the skills they need to achieve their goals...

  • Solutions Architect

    1 week ago

    Washington, United States Data Society Full time

    About Data Society Group At Data Society Group (DSG), we provide the highest quality, leading-edge industry-tailored data and AI training and solutions for Fortune 1,000 companies and federal, state, and local government organizations. We partner with our clients to educate, equip, and employer their workforces with the skills they need to achieve their...

  • Naval Architect

    1 month ago

    Washington, Washington, D.C., United States Pantheon Data Full time

    Job Title: Naval ArchitectWe are seeking a highly skilled Naval Architect to join our team at Pantheon Data. As a key member of our Ship Design Team, you will be responsible for providing engineering support to the United States Coast Guard on various acquisition and sustainment projects.Key Responsibilities:Conduct and document tests, including stability,...

  • Azure Data Architect/Lead

    2 weeks ago

    Washington, United States Cognizant Full time

    About Cognizant’s AI Practice Digital technologies, including analytics and AI, give companies a once-in-a-generation opportunity to perform orders of magnitude better than ever before. However, clients need new business models built from analyzing customers and business operations at every angle to really understand them. With the power to apply...

  • Architect Premium II

    4 months ago

    Washington, United States Mindlance Full time

    Position Summary: Title: Architect Premium II - Data Architect Location: Washington, DC 20433 Duration: 6 Months - Long Term Hybrid Onsite: 3/4 days onsite from Looking for a Data Architect with Azure, Oracle, SQL, Postgres SQL, Azure Data Lake, Azure Data factory, Azure Data bricks. Need someone who has done implementations, and worked with Microsoft...

  • Salesforce Data Cloud Architect

    1 month ago

    Washington, Washington, D.C., United States National Association of Broadcasters Full time

    About UsThe National Association of Broadcasters is the voice for the nation's radio and television broadcasters. As the premier trade association for broadcasters, NAB advances the interests of our members in federal government, industry and public affairs; improves the quality and profitability of broadcasting; encourages content and technology innovation;...

  • Data Solution Architect

    1 month ago

    Washington, United States Ojasys LLC Full time

    Job DescriptionJob DescriptionJob Title: Solution ArchitectLocation: Washington DC Metro Area (Hybrid)Experience: 10+ Years (5+ in Solution Architecting)Salary: Competitive (Based on Fitment of Candidature)Job Description:We are seeking an experienced Solution Architect to join our client, a prominent federal government corporation, responsible for ensuring...

  • Azure Data Architect

    4 weeks ago

    Washington, United States Cognizant Full time

    Cognizant (NASDAQ: CTSH) is a leading provider of information technology, consulting, and business process outsourcing services, dedicated to helping the world's leading companies build stronger businesses. Headquartered in Teaneck, New Jersey (U.S.). Cognizant is a member of the NASDAQ-100, the S&P 500, the Forbes Global 1000, and the Fortune 500 and we are...

  • Big Data Architect

    2 weeks ago

    Washington, United States Lorven Technologies Full time

    Job Title: Big Data Architect Job Location: Washington, DC (Onsite) Job Duration:12+ months contract Position Description: This role will provide expertise to support the development of a Big Data / Data Lake system architecture that supports enterprise data operations, including the Internet of Things (IoT) / Smart City projects, enterprise data...

  • Junior Data Architect

    2 months ago

    Washington, United States @Orchard LLC Full time

    @Orchard LLC is supporting a growing Federal contractor with strength in Financial and Budgetary Management, Data Analytics, Data Management, IT Infrastructure, Change Management, and other related solutions, with an emphasis on supporting the Department of Defense. Our client seeks junior to mid-level Data Architects with active Secret clearances for a...

  • Required certifications: AWS Certified Solutions Architect

    2 weeks ago

    Washington, United States NTT Data Full time

    Req ID:302616NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.We are currently seeking an AWS Architect to join our team in Bethesda, Maryland (US-MD), United States (US).The Cloud Architect (AWS) will be...

  • Naval Architect for Ship Design and Engineering Support

    4 weeks ago

    Washington, Washington, D.C., United States Pantheon Data Full time

    Job Title: Naval Architect for Ship Design and Engineering SupportJob Summary:Pantheon Data is seeking a highly skilled Naval Architect to join our Ship Design Team. As a key member of our team, you will be responsible for providing engineering support to the United States Coast Guard on a variety of acquisition and sustainment...