Data Warehouse Architect

1 week 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 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.

  • Data Warehouse Architect

    2 weeks ago

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

    Job SummaryWe are seeking a highly skilled Data Warehouse Architect to join our team at Saxon Global. The ideal candidate will have a strong background in designing and implementing complex data warehouse solutions, as well as experience with ETL (extract, transform, and load) processes.Key ResponsibilitiesDevelop and implement ETL scripts to gather data...

  • Data Warehouse Architect

    6 days ago

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

    About the Role:Saxon Global is seeking a highly skilled Data Warehouse Architect to join our team. As a key member of our IT department, you will be responsible for designing and implementing complex data warehouse solutions to support our business analytics and reporting needs.Key Responsibilities:Develop and maintain ETL scripts to extract, transform, and...

  • Data Warehouse Architect

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

    5 days 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 week 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 week 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 week 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

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

  • Data Warehouse Architect

    1 week 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

    2 weeks ago

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

    Job Title: Data ArchitectJob Summary:We are seeking a highly skilled Data Architect to join our team at Arena Technical Resources, LLC. As a Data Architect, you will be responsible for designing and developing enterprise data warehouse components, including data marts, operational data stores, staging, and archival databases.Key Responsibilities:Architect...

  • Enterprise Data Architect

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

    2 weeks ago

    Washington, Washington, D.C., United States Qualis Full time

    We are seeking a highly skilled Data Architect to design and implement data systems that meet the needs of our organization. The ideal candidate will have a strong background in data architecture and a proven track record of delivering complex data solutions.The Data Architect will be responsible for:Designing and implementing data systems that meet the...

  • Senior Data Architect

    2 weeks ago

    Washington, Washington, D.C., United States Go intellects Inc Full time

    Job OverviewGo intellects Inc is seeking a highly skilled Senior Data Architect to join our team. The ideal candidate will have expertise in designing and implementing large-scale data systems, including data lakes, warehouses, and pipelines.Responsibilities:Design and implement data architectures for enterprise data operationsDevelop and maintain data...

  • Data Architect

    1 month ago

    Washington, Washington, D.C., United States Analytica Full time

    Job Title: Solutions ArchitectAt Analytica, we are seeking a highly skilled Solutions Architect to lead and manage a high-profile team in the development and implementation of data science and machine learning efforts.Job SummaryThe successful candidate will work with a diverse team of professionals to design and implement data-driven solutions, detect and...

  • Senior Data Architect

    2 weeks ago

    Washington, Washington, D.C., United States Sylger Corporation Full time

    Job SummaryWe are seeking a highly skilled Data Architect to join our team at Sylger Corporation. As a key member of our data management team, you will be responsible for designing and implementing data warehouses and business intelligence solutions to support our federal government clients.Key Responsibilities:Design and implement data warehouses and...

  • Data Architect

    2 weeks ago

    Washington, Washington, D.C., United States Intermountain Health Full time

    Job Description:The Data Architect/Data Engineer is responsible for designing, implementing, and maintaining both traditional and modern data infrastructures at the staff level. This role combines expertise in relational databases, cloud technologies, and big data tools to create scalable, efficient, and secure data solutions.The data architect/engineer...

  • Data Architect

    1 month ago

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

    Job Title: Big Data ArchitectJob Location: Washington, DC (Onsite)Job Duration:12+ months contractPosition 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 warehouse, the...

  • Data Architect

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

  • Data Architect

    2 weeks ago

    Washington, Washington, D.C., United States RxAnte Full time

    Job Title: Data ArchitectRxAnte is seeking a highly skilled Data Architect to join our Data Services team. As a Data Architect, you will be responsible for designing and building scalable data systems to support our analytic products.Key Responsibilities:Design and develop data architectures to support business requirementsCollaborate with cross-functional...