VBA/Excel/Power BI Expert

Clearance Level
Financial Analysis
Atlanta, Georgia

REQ#: RQ68242

Travel Required: None
Requisition Type: Regular

At GDIT, people are our differentiator. GDIT is your place. You make it your own by embracing autonomy, seizing opportunity, and being trusted to deliver your best every day.

We think. We act. We deliver. There is no challenge we can’t turn into opportunity.

General Dynamics Information Technology – Federal Civilian Division is currently looking for a Financial Management/Budget Analyst (Excel/VBA expert) to join our team in support of the Centers for Disease Control and Prevention (CDC) – Center for Global Health (CGH). This position is for fulltime employment, will be located onsite at the customer’s location in Atlanta, Georgia and within the CGH Division of Global Health Protection (DGHP).     

CGH’s mission is to improve the health, safety, and security of Americans while reducing morbidity and mortality worldwide. They leverage CDC’s core strengths to advance four overarching global health goals: improving the health and well-being of people around the world, improving capabilities for preparing and responding to infectious diseases and emerging health threats, building country public health capacity and maximizing organizational capacity. (CDC’s domestic facilities are currently operating under “maximum telework” due to the COVID-19 pandemic. It is anticipated that this position will be 100% telework until CDC’s facilities begin to resume normal operations.)

Primary Responsibilities:

The purpose of this position is to support the Financial Management and Budget team to improve fiscal stewardship and build capacity of the Division’s staff. Candidate will use, troubleshoot and design complex Excel spreadsheets that include formulas, pivot tables, VBA, and connections to external databases to perform a variety of complex budget duties, utilizing a professional knowledge of budget principles and procedures in carrying out assignments. Responsibilities include:

  • Provide support to managers and program specialists in the budget formulation process.  Compile background and historical data and documentation to assist in the development of budget estimates and justifications and to identify operating costs.
  • Work with managers and program specialists in the development of annual work plans and schedules for the execution of approved budgets. Recommend reprogramming and adjustments to work plans to account for changes in funding levels, program changes, and unanticipated expenses.
  • Validate aggregated programmatic planning data for 30 branches/countries and aligning Integrated Program Planning (IPP) data to various reports and division metrics
  • Support the financial tracking and reporting for the Division
  • Collect, manipulate, analyze, evaluate, and display data using PowerBI Dashboards, Reports or other data delivery solutions to business stakeholders
  • Provide technical support and troubleshooting as needed on budget and financial tools
  • Perform budget development, formulation and/or execution functions for assigned programs or administrative budget areas.
  • Track obligations, expenditures and the flow of funds. Ensure fund availability for the processing of obligating documents.
  • Monitor, review and reconcile commitments, obligations, reimbursable orders, etc.  Assure that obligations incurred and resulting expenditures of funds are in accordance with pertinent laws and regulations.
  • Identify potential issues and provide recommendations for resolution of budgetary problems.
  • Identify opportunities and recommend process improvements to the budgetary processes, policies, and procedures.
  • Conduct data entry of financial information into Excel and other customer financial systems.
  • Compile data and prepare a variety of ad hoc and reoccurring reports and analyses related to financial management issues
  • Participate in special projects as required.

Required Qualifications:

  • Bachelor’s Degree in Finance, Accounting, IT or a related business discipline, or the equivalent combination of education, professional training, or work experience.
  • 2+ years of finance, business or IT experience.
  • Candidate must have at least two years of expert experience working with and be highly skilled in Microsoft Excel. (Candidate must pass an Excel skills test.)
  • Proven experience and familiarity with PowerBI
  • Experience and comfort working on Office365 online
  • Exposure to and understanding of Power Automate
  • Experience with basic automation (i.e., auto-generating Word documents/PDFs from Excel)
  • Experience with VBA, fluency preferred.
  • Must be U.S. citizen with the ability to obtain a National Agency Check with Inquiries (NACI) clearance.

Preferred Skills:

  • Demonstrated eagerness to identify and solve problems
  • Ability to learn new software systems and to utilize this expertise to provide client deliverables.
  • Excellent written and oral communication skills.
  • Knowledge of CDC and Federal budget processes, policies, procedures, and regulations
  • Costing, accounting and/or budgeting experience
  • Financial management experience

Attributes for Success:

  • Strong organizational skills and the ability to perform and prioritize multiple tasks seamlessly with excellent attention to detail
  • Demonstrated proactive approaches to problem solving with strong decision-making capabilities
  • Forward looking thinker, who actively seeks opportunities and proposes solutions
  • Analyze organizational goals and objectives, operating environment and business processes to determine most efficient methods of accomplishing work.
We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.

GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.