Teksouth Corporation - Gardendale Finance Manager/Data Analytics in Fort Bragg, North Carolina
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.
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
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
# of Openings 1