Data Warehouse Architect

2 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 clearance


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 ad hoc 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

    3 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, Washington, D.C., United States Expedite Technology Solutions LLC Full time

    Job Summary: We are seeking a highly skilled Data Warehouse Architect to join our team at Expedite Technology Solutions LLC. As a key member of our data team, you will be responsible for designing and implementing logical and physical data models for our clients. Key Responsibilities: Design and implement data models for OLTP and OLAP systems Develop and...

  • Data Solutions Architect

    4 weeks ago

    Washington, Washington, D.C., United States Tantus Technologies Full time

    Job Title: Data Solutions ArchitectAbout the Role:Tantus Technologies, Inc. is seeking a Data Solutions Architect to support a federal client. The ideal candidate will possess strong data analytics, data visualization, and machine learning integration skills, ensuring that data warehouses support reporting, advanced predictive analytics, and AI-driven...

  • 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

    4 weeks ago

    Washington, Washington, D.C., United States Saxon Global Full time

    Job Title: Data ArchitectJob Summary:Saxon Global is seeking a highly skilled Data Architect to spearhead the design and development of a new, high-performance enterprise data warehouse. The ideal candidate will have a strong background in data modeling, ETL processes, and data architecture.Key Responsibilities:• Oversee and review the work of team members...

  • Data Warehouse Architect

    1 month ago

    Washington, United States Seneca Resources Full time

    Position Title: Datawarehouse ArchitectLocation: RemoteClearance Requirements: Must be able to obtain a Public Trust ClearancePosition Status: ContractJob DescriptionTASK 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,...

  • Enterprise Data Architect

    4 weeks ago

    Washington, Washington, D.C., United States Arena Technical Resources Full time

    Job Title: Data ArchitectJob Description:We are seeking a highly skilled Data Architect to support the execution of IT management and execution functions across units and systems. The ideal candidate will have at least 5 years of experience with architecting, designing, and developing enterprise data warehouse components, including data marts, operational...

  • Data Architect

    3 weeks ago

    Dallas, TX, United States Programmers.io Full time

    One of our global food client is looking for Data Architect in Dallas TXThe Data Architect is responsible for ensuring standards are followed. Perform Design Perform Data Analysis Reviewing requirements, workshops, or working directly with a business team member Reviewing/querying various systems – familiarity with Query language – SQL/T-SQL Create Data...

  • 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 Architect

    2 weeks ago

    Beaverton, OR, United States Talent Groups Full time

    Data ArchitectLocation: Hybrid - Beaverton, ORTalent Groups is seeking a Data Platform Architect to lead the design and strategy of a scalable data environment. This role involves close collaboration with cross-functional teams to shape the future of data infrastructure.Key Responsibilities:Evaluate and improve the current data infrastructure for...

  • Data Architect

    2 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 Data Architect

    4 weeks ago

    Washington, DC, United States Booz Allen Full time

    Solution Data ArchitectThe Opportunity:At a certain point, experience-based system design can start to look like clairvoyance. When you’ve developed so many systems that you can not only orchestrate the best solution for any technology-based challenge, but you can also anticipate and preempt future issues, you’re a solutions architect. You’ve evolved...

  • Senior Data Architect

    3 weeks ago

    Torrance, CA, United States iSpace, Inc. Full time

    Senior Data ArchitectTorrance, CA - HybridNovember 2024 – March 31, 2026 This Senior Data Architect will be responsible for performing the following duties: Manage senior business stakeholders to secure strong engagement and ensure that the delivery of the project aligns with longer-term strategic roadmaps. Lead and participate in the peer review and...

  • Data Architect

    4 weeks ago

    Washington, Washington, D.C., United States HHA eXchange Full time

    Data Architect Job DescriptionHHAeXchange is a leading technology platform for home and community-based care.We are seeking a highly skilled Data Architect to join our team.The successful candidate will be responsible for developing, documenting, and communicating frameworks, standards, and practices to ensure that HHAeXchange is properly managing and...

  • 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

    6 days 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...

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

  • Senior Data Architect

    3 weeks ago

    Chicago, IL, United States Producers National Corporation Full time

    Overview:The Senior Data Architect is responsible for designing, implementing, and managing the organization's data architecture, including but not limited to data warehouse and data marts. This role ensures that data across the organization is well-architected, structured, integrated, and managed in a way that supports business operations and analytics. The...