Budget Data Analyst (Power BI/Excel/VBA expert)

$80,226 - $97,750/Yr

GD Information Technology, Inc. - Atlanta, GA

Full-time - Entry Level

Remote - Atlanta, GA

10,001+ employees

About the position

The Budget Data Analyst position at GDIT involves supporting the Financial Management and Budget team for the CDC's Global Health Center. The role focuses on improving fiscal stewardship and building the capacity of the Division's staff through the design and troubleshooting of complex Power BI dashboards, Power Apps, and Excel spreadsheets. The analyst will assist in budget formulation, track financial data, and recommend process improvements, all while working in a fully remote environment.

Responsibilities

• Provide support to managers and program specialists in the budget formulation process.
• Compile background and historical data to assist in the development of budget estimates and justifications.
• Work with managers in the development of annual work plans and schedules for executing approved budgets.
• Recommend reprogramming and adjustments to work plans based on funding changes and unanticipated expenses.
• Automate and optimize current budget processes to streamline stakeholder workflow.
• Validate aggregated management and operations budget data for 40 branches/countries.
• Support financial tracking and reporting for the Division.
• Collect, manipulate, analyze, evaluate, and display data using Power BI Dashboards and Reports.
• Provide technical support and troubleshooting on budget and financial tools.
• Perform budget development, formulation, and execution functions for assigned programs.
• Track obligations, expenditures, and the flow of funds.
• Ensure fund availability for processing obligating documents.
• Monitor, review, and reconcile commitments and obligations.
• Identify potential issues and provide recommendations for resolution of budgetary problems.
• Conduct data entry of financial information into Excel and other systems.
• Compile data and prepare various reports and analyses related to financial management issues.
• Participate in special projects as required.

Requirements

• Bachelor's Degree in Finance, Accounting, IT or a related business discipline or equivalent experience.
• 2+ years of financial management, accounting, budgeting, business or IT experience.
• 2+ years of expert level working experience with Microsoft Excel, including INDEX MATCH, nested IF statements, SUMIF, and COUNTIF functions.
• Proven expert level experience with Power BI & Power Query Editor.
• Experience with SQL Databases and Database Relationship Modeling.
• Experience and comfort using Office365 online.
• Exposure to Power Platform: Power Apps, Power Automate.
• Experience with basic automation (e.g., auto-generating Word documents/PDFs from Excel).
• Expert level experience with VBA.
• Ability to obtain a National Agency Check with Inquiries (NACI) clearance.

Nice-to-haves

• Knowledge of CDC and Federal budget processes, policies, procedures, and regulations.
• Demonstrated eagerness to identify and solve problems.
• Client relationship management and consulting experience.
• Ability to learn new software systems and utilize this expertise for client deliverables.
• Excellent written and oral communication skills.

Benefits

• 401K with company match
• Comprehensive health and wellness packages
• Full-flex work week
• Professional growth opportunities including paid education and certifications
• Paid vacation and holidays
• Paid parental leave
• Paid military leave
• Paid bereavement leave
• Paid jury duty leave
• Short and long-term disability benefits
• Life and accidental death and dismemberment insurance
• Critical illness and business travel accident insurance