Data Analytics Developer

Teksouth, Montgomery, AL (United States)

Category: Programming

Posted on: 20 Nov 2020

SQL

Job Description

Teksouth Corporation (www.teksouth.com) is currently searching for a Data Analytics Developer at Redstone Arsenal, AL. (Huntsville area/Northern Alabama) This position will be located onsite at Redstone Arsenal and will require an Active Secret Clearance that can be verified in JPAS.

The U.S. Army Space and Missile Defense Command (USASMDC) G8 Resource Management team provides executive management of accounts, program execution, planning/programming/budgeting, management sciences, and manpower by ensuring that suitable manpower structure and resources are available, and that adequate funds are received from the Office of the Secretary of Defense, the Missile Defense Agency, Department of the Army and others to support the USASMDC mission and vision. 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.

Responsibilities:

Automate the process of integration of multiple sources of Army Accounting, Financial, Budget, Personnel, and Logistics data

Develop, maintain, and customize desktop analytic tools using approved Microsoft products

Create reporting and dashboard solutions to improve the efficiency of daily operations

Provide reports to leadership and tenant units to support decision making

Conduct requirement gathering meetings and document identified requirements; design and develop desktop tools implementing approved requirements

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

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

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

Perform daily data loads from source data systems

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

Create advanced charts and dashboards in MS Excel and MS PowerBI

Perform quality checks on a routine basis for all tools and deliverables

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

Lead/Conduct training classes on tools developed in MS Access, Excel, PowerBI, PowerPoint, and automation techniques

Lead specialized analysis and development efforts for analysts and leaders

Required Skills & Knowledge:

Broad knowledge of the DoD financial environment

Broad knowledge of DoD Financial Management, Accounting, and Budgeting processes and procedures

General knowledge of Army Financial, Accounting, and Budgeting systems, including GFEBS and SOMARDS

Proficiency in Microsoft Access, Excel, SQL, and Visual Basic for Applications (VBA)

Proficiency in tools/techniques to link data between Microsoft Access, Excel, and PowerBI

Proficiency in other Microsoft applications – MS Word, PowerPoint, and SharePoint

Demonstrated ability to communicate with clients, from analysts to senior DoD/Army officials

Demonstrated ability to work collaboratively across a large organization, managing diverse tasks, requirements, and commitments

Demonstrated ability to document processes and procedures and provide guidance on execution of developed tools

Understanding of CMMI framework Must have an ACTIVE Secret security clearance

Education:

BS/BA degree in computer science, information systems, engineering, business, or other related scientific or technical discipline and a minimum of four (4) years of general experience in DoD Financial Management

No degree is required with eight (8) years of DoD Financial Management experience

Physical requirements:

Work sitting or standing at a desk, cubicle, or conference table for extended periods of time (1-3 hours), with the ability to shift positions while working: sit, stand, pace, adjust positioning in any of those without issue

Use standard office equipment such as computers, phones, photocopiers, filing cabinets, and facsimile machines.

Ability to work in a tempered climate-control office environment May be required to lift and/or move up to 15 pounds

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.com

 

 

Company DescriptionSince 1982, Teksouth has delivered operational excellence and innovation to our clients. Our customers count on our innovative information solutions and services to deal with their most pressing challenges. Our solutions range from assisting customers with putting already owned resources to best use to delivering best practices across the whole range of IT infrastructure and data integration projects.


Want more jobs like this?

Apply Now

By clicking "Apply Now" or "Subscribe and Apply" you will be redirected to an external website. By clicking "Subscribe & Apply" you give TechieJobs consent to process and store your data, and send you job alerts to provided email.

Job Source: Ziprecruiter (Will expire by: 2021-01-04 00:00:00)

Apply Now

Quick poll
How did COVID-19 affect your employment?
  • Nothing's changed
  • I now work from home
  • My salary decreased
  • I lost my job

* This poll is anonymous.