Data Analytics Developer (Dod Finance, Reporting, Analytics)

Job LocationsUS-HI-HalawaPosted Date1 month ago(4/2/2020 11:40 AM)ID2019-1461# of Openings1CategoryInformation TechnologyOverviewTeksouth Corporation has an immediate need for a Data Analytics Desktop Tools Developer. This position will be located at Camp H. M.

Smith, HI.This position will be FT onsite and candidates must have an Active Secret Clearance that can be verified in JPAS.The U.S. Indo-Pacific Command (USINDOPACOM) is one of six geographic combatant commands defined by the Department of Defense's (DoD) Unified Command Plan (UCP).As a geographic combatant command, the USINDOPACOM is in charge of using and integrating United States Army, Navy, Air Force and Marine Corps forces within the USINDOPACOM area of responsibility (AOR) to achieve U.S. national security objectives while protecting national interests.The USINDOPACOM AOR covers more of the globe than any of the other geographic combatant commands and shares borders with all of the other five geographic...

combatant commands. Teksouth supports the USINDOPACOM by developing and enhancing financial dashboard and reporting tools.The tools support retrieval of data from multiple sources and provide output that allows users to view and analyze financial and acquisition data via metric reporting and scorecards, trend analysis, pivot tables, and graphs.The Data Analytics Desktop Tools Developer will be responsible for using Microsoft technologies to develop new tools and functionalities, and will be responsible for expanding the functionality of existing solutions to meet the needs of new requirements.This role will work closely with the client during all stages of development.ResponsibilitiesAutomate the process of integration of multiple sources of Accounting and Financial data for the USINDOPACOM.Create, enhance, and maintain reporting and dashboard solutions to improve the efficiency of daily operations.Provide reports to leadership and tenant units to support decision making.Identify possible data sources to integrate using current and past legacy systemsConvert all data sources to interface/link with Microsoft Access and/or ExcelIntegrate all data sources into one or multiple tables in a customized analytical format using MS AccessLink MS Access data sources to MS Excel Pivot Tables for multiple usersCreate ad hoc and canned reportsCreate advanced charts in MS ExcelDevelop VBA code in MS Office to automate data collection and integration processesCreate an automated e-mail notification capability using MS WordLead/Conduct training classes on MS Access, Excel, PowerPoint automation techniquesLead specialized analysis and development efforts for analysts and leadersTool development for the USINDOPACOM will include:Map or remap feeds into the integrated database/dashboard in the event the current data source is phased out and/or new sources are definedUtilize current data sources to streamline financial reporting and analysis of funds execution. Data sources include: Ships and Marine Air Logistics System (MALS); Automated Reconciliations Tracking System (Naval Supply Systems Command) (SMARTS)Collect, compile, and parse data daily to maintain the current integrated interface of the dashboard using applications that run from one or more data reporting sourcesMaintain the existing dashboard capabilities to report and display financial data using the data fields and pivot table formatsQualificationsBroad knowledge of the DoD environmentKnowledge of Navy accounting, budgeting, financial management, and acquisition processes and procedures (i.e., authorizations, product service codes, federal supply codes, object class codes, commitments, obligations, expenses, liquidations, expendtures)Knowledge and experience working with data evolving from a complete budget cycle, from formulation to actual execution year and close out, and how the information is captured in Navy transaction systemsKnowledge and experience using data from Navy financial, contracting, and supply systemsKn