IT Functional Expert Consultant - Part Time

Job Title IT Functional Expert Consultant Client Company/Dept. Name Department of Justice Office of U.S. Attorneys ddress 601 D St NW, Washington, DC City Name Washington State Name DC-District Of Columbi Zip Code If others (Address) Duration of the project Project Start Date: December 13, 2024 Project End Date December 12, 2025 Due date for Resume submission October 28, 2024 No. of Openings 3 No. of Maximum Submissions 3 Job Description Complete gathering of user requirements, Prosecutor Performance Indicators, anduse cases for the Case Statistics data warehouse.•Construct, test, implement and maintain ETLs (Extract, Transform, and Load)processes for the Case Statistics data warehouses.•Finalize and implement Case Statistics data warehouse prototype including designof schema structures, staging areas, data marts, fact tables, dashboards and usecases.•Maintain and modify Case Statistics data warehouse and ETLs as userrequirements evolve.•Using a similar methodology, construct and implement additional data warehousess required by USAODC.•Provide technical documentation all data warehouses and theircomponents as required by USAODC. Provide technical research and recommendations for COTS software orgovernment-provided software to replace USAODC Legacy systems.•Provide technical support for Legacy to COTS/Government software datamapping.•Provide technical support for development of Legacy toCOTS/government software data migration plans.•Provide technical support for identification of Legacy features to beimplemented in the COTS/government software environment.•Provide technical support for develop and document system cut-overplans.•Provide user liaison support to ensure system functionality is retained and/orimproved.•Provide technical support for User Acceptance Testing. Document results andensure defects are corrected.•Construct and execute data migration scripts as needed.•Provide user and technical documentation as needed.Provide support to modify current transaction loading and processing of data anddocuments 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 anddocuments to new staging area environments.•Migrate current processes to populate USAODC data sources with transactiondata and documents from new staging areas.•Conduct interface testing - internally and externally with other agencies as needed.•Go Live and post-implementation support.nalysis of user requirements documented in a Functional Requirements Document•Design and creation of data structures and database objects in MS SQL Serverenvironment.•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 new MS SQL Server environment, as needed.•Unit and system integration testing•Go Live and post-implementation support Skill set info Skills in data modeling and process modeling.o Knowledge of requirements analysis and system definition reports anddocumentation.o Skills in providing end user training.o Skills in project planning.o Skills writing user and system manuals.•Web Technologies:o XML (Extensible Markup Language)o JSON (JavaScript Object Notation)o Web Services (SOAP, SoapUI, REST API)o Internet Authentication Service (IAS) for Windows Servero Dynamic web pages using CSS, Ajax and HTML5o .Net Applications using C#o Java•Databases, Operating Systems, Application Serverso MS SQL Servero PostgreSQLo Oracleo Linuxo Windowso Apacheo Apache Tomcat•Development Tools, APIs, and Scriptingo .Net Applications using C#o VB Scripto Javao Data modeling and data management using ERWin and TOADo Interactive Dashboards using Tableau, Power BIo SQL Server Integration Serviceso MS Accesso Oracle 12c Developer Tool SuitePL/SQLThis is a senior level technical position, often the most senior level technical position for all work for a particular DOJ component. Must demonstrate substantial, hands-on, successful experience in actually doing the work on the systems being used, usually at least five years of such experience. Other systems environments will require other specific sets of skills. Requires broad knowledge of the Government's IT environments, including office automation networks, and PC and server-based databases and applications. Experience in a litigation support environment extremely helpful. Excellent oral and written communication skills are required. Supervisory experience very strongly preferred. Ability to lead a technical team, and to give it direction, will be very important, as will the demonstrated ability to analyze the attorneys' needs, and to design and implement a whole system solution responsive to those needs. Education Bachelor's degree in computer science, engineering, or related field, and 3 years of experience in the appropriate area. Certifications (if required) Documentation Required for submission Signed letters of commitment from candidate is required. Work Hours This part-time role may require fewer days or hours per week, working up to approximately 18-20 hours per week across the year. Work authorization required US Citizen Only Relocation is accepted Yes Remote work No dditional Notes if any This role is for a part-time position, with an estimated workload of up to 952 hours during the contract period. The selected candidate will be expected to work on a flexible schedule based on project needs and coordination with the USAODC IT Applications Manager. Candidates should demonstrate a proven track record in delivering IT functional expertise within government or related sectors, with an emphasis on the skills specified.