Data Warehouse Architect

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, 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 systemsProvide 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 InterfacesContractor 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 ApplicationsContractor 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 DocumentDesign and creation of data structures and database objects in MS SQL Server environment.Design of the new module, interfaces documented in a Design DocumentConstruction of forms, reports, interfaces, and processes required for User InterfaceMigration of data to the new MS SQL Server environment, as needed.Unit and system integration testingGo Live and post-implementation supportTASK 5 - Provide Maintenance Support for Existing Applications and ProcessesContractor 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 DocumentsBusiness Process Flow DiagramsApplication and Database Design DocumentsNew and Modified Application Reports, Forms, Procedures and APIsTechnical DocumentationData mapping documentsSystem cutover plansTest Plans and Test ResultsInterface Design DocumentsServer Technical SpecificationsAbout 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.

Created: 2024-11-07