Teksouth Corporation - Gardendale Data Analytics (Active Secret Clearance) in Fort Bragg, North Carolina

Overview

Teksouth has a current position for a Data Analytics Analyst. This will be a FT, onsite position located in Ft Bragg, NC.

Candidate must have an Active Secret Clearance that can verified in JPAS.

Responsibilities

Job Description:

Data Automation Developer responsible for integrating and automating multiple sources of Accounting and Financial data for the US Army organizations using the Microsoft Office Suite (Access, Excel, PowerPoint, Word, etc.)

Identifies possible data sources to integrate using current and past legacy systems

Converts all data sources to interface/link with Microsoft Access and/or Excel

Integrates all data sources into one or multiple tables in a customized analytical format using MS Access

Links MS Access data sources to MS Excel Pivot Tables for multiple users Creates ad hoc and canned reports

Creates advanced charts in excel

Development in InfoPath forms stored in SharePoint

Report extractions completed daily to generate the customer’s Dashboard.

Record all request for assistance (RFAs) in the customer systems support center assistance tracker.

Develop VBA code in MS Office to automate data collection and integration processes

Lead/Conduct training classes on integrations/reporting tools

Qualifications

Working knowledge and report extraction capabilities in the follow government legacy accounting systems:

  • General Fund Enterprise Business System (GFEBS),

  • Global Combat Support System-Army (GCSS-Army),

  • Resource Management Tool (RMT),

  • Standard Finance System (STANFINS),

  • Operational data store (ODS),

  • Standard Operations and Maintenance Army Research Development System (SOMARDS),

  • Defense Travel System (DTS).

Extraction tools and basic method of producing customer dashboard include Access databases, SQL Server and PowerShell scripts.

Dashboard maintenance requires advanced Microsoft Excel and PowerPoint capabilities.

Obtain working knowledge of the Microsoft SharePoint libraries for Military Interdepartmental Purchase Request (MIPR) and Purchase Request & Commitment (PR&C) to include design, layout changes, connection to list and document libraries for each library.

Advanced skills using the Microsoft Suite (Access, Excel, Word & PowerPoint) customer dashboard creation includes producing databases, pivot-tables, and use of advanced Excel formulas.

Teksouth values and engages the diversity of its teammates, customers, and business partners.

EOE race/color/sex/sexual orientation/gender identity/disability/vet

www.teksouth.jobs

www.teksouth.com

ID 2018-1412

# of Openings 1

Category Information Technology