Developer Desktop Analytics

Overview

Teksouth Corporation has a current opportunity for two (2) Access/Excel Developers.

Excellent opportunity to take your career to the next level. Teksouth is a boutique analytical service provider for federal and non-federal customers. We work closely with clients and develop tools with an emphasis on improving the efficiency and effectiveness of the organizations we serve by helping them leverage data to make better decisions.

These positions will be located at Aberdeen Proving Grounds, MD. Must Have Army or DoD Financial systems experience and an Active SECRET Clearance.

Responsibilities

Job Description:

The Developers are responsible for integrating and automating multiple sources of Accounting, Financial, Personnel, and Logistics (Supply Chain) data for the DoD and other government organizations using the Microsoft Office Suite (Access, Excel, PowerPoint, Word, SharePoint, InfoPath, 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

* Create advanced charts in excel

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

* Create an automated e-mail notification capability using MS Word

* Lead/Conduct training classes on MS Access, Excel, PowerPoint automation techniques

* Lead specialized analysis and development efforts for analysts and leaders

Qualifications

Possesses basic understanding of the DOD environment and Financial Management and Accounting processes and procedures.Must be an Expert in MS Access and Excel Must know how to link data between Microsoft Access, Excel, PowerPoint, SharePoint, Word, and Outlook Must have a basic understanding of Visual Basic for Applications Must be proficient in other Microsoft applications – MS Word, PowerPoint, & SharePoint Must possess outstanding interpersonal communication skills. The ability to communicate to analysts and senior leadersPossesses a demonstrated ability to work collaboratively across a large organization, managing diverse tasks, requirements, and commitments.Must have an ACTIVE Secret security clearance

Skills and Education requirements:

* Master's Degree with 5 years of experience

* Bachelor's degree with 9 years' experience

* No degree and 15 years of relevant experience

* Knowledge for Army Accounting systems including GFEBS and SOMARDS

* ARMY Finance and Payroll & Personnel experience preferred

* Financial Management Data Systems: GFEBS, SOMARDS, STANFINS

Human Resources Data Systems:

CPOL: Civilian Personnel On Line.

CAPPMIS: Career Acquisition Personnel and Position Management Information System.

DCPDS: Defense Civilian Personnel Data System.

IPERMS: Interactive Personnel Electronic Records Management System.

FMS WEB: Force Management System.

EPROBE (PBG: Program Budget Guidance, AUDITS): Planning Programming Budget Business Operating System.

TED: Total Employee Development.

MIRARS: Manpower Information Retrieval and Reporting System.

FDM: Financial Disclosure Management

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