D3 Air and Space Operations has an opening for Systems Data Integration Support at Langley AFB, VA.
Start Date: 2 Mar 15.
Responsibilities:
Extract data from AF standard financial data systems. (Daily & Monthly)
Reformat and incorporate extracted data into existing MS Office spreadsheets, databases, reports, and slides. (Daily & Monthly) Generate staff work as assigned (i.e. Staff Summary Sheets, one liners, bullet background papers, etc.). Prepare briefings and impact statements in response to budget initiatives and program changes.
Create, modify, and maintain new or existing Excel workbooks, spreadsheets, pivot tables, graphs, ActiveX controls, and Visual Basic for Applications (VBA) modules,.
Create, modify, and maintain new or existing Access databases, tables, queries, reports, VBA modules, and SQL queries.
Create, modify, and maintain new or existing SharePoint sites, sub-sites, lists, folders, groups, surveys, and permissions.
Query data sets and cross-link MS Office applications to provide useful information for leadership
Create, modify, and maintain new or existing PowerPoint slides, charts, and graphs.
Create ad hoc spreadsheets, databases, and reports to support daily operations. (approximately 10 times per week)
Enhance current MS Office automation capabilities and develop new technical approaches to streamline data availability and analysis.
Qualifications:
Possess an Associate’s Degree in IT and 4 years working in an IT field; or 5 years’ experience in an IT field.
Two (2) years' experience with AF financial management databases and processes.
Five (5) years’ experience writing both MS Virtual Basic for Applications (VBA) and Structured Query Language (SQL) programming languages.
Three (3) years’ experience creating backend databases and frontend user interfaces (using forms) in MS Access 2010.
Two (2) years’ experience designing/creating SharePoint 2010 sites.
D3 Air and Space Operations governs all employment related decisions without regard to an individual's race, color, sex, religion, national origin, age, disability, veteran status or any other protected classification.
[EEO/AA/Protected Veterans/Individuals with Disability employer].