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

Type of Requisition:

Regular

Clearance Level Must Currently Possess:

None

Clearance Level Must Be Able to Obtain:

None

Suitability:

Public Trust/Other Required:

NACI (T1)

Job Family:

Data Visualization

Job Qualifications:

Skills:

Microsoft Access VBA, Microsoft Excel Data Analysis, Microsoft Power Apps, Microsoft Power Business Intelligence (BI), Power Query

Certifications:

Experience:

2 + years of related experience

US Citizenship Required:

No

Job Description:

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 not a challenge that we can’t turn into opportunity.

General Dynamics Information Technology – Federal Civilian Division is currently looking for a Budget Data Analyst (Power BI/Excel/VBA expert) to join our team in support of the Centers for Disease Control and Prevention (CDC) – Global Health Center (GHC).

GHC’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.

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 Power BI Dashboards, Power Apps, and Excel spreadsheets with heavy emphasis on the use of INDEX MATCH, formulas, pivot tables, VBA, and connections to external databases.

This role can be fully remote!

HOW A BUDGET DATA ANALYST WILL MAKE AN IMPACT:

• 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.
• Automate and optimize current budget processes to streamline stakeholder workflow
• Validate aggregated management and operations budget data for 40 branches/countries and aligning management and operations (M&O) data to various reports and division metrics
• Support the financial tracking and reporting for the Division
• Collect, manipulate, analyze, evaluate, and display data using Power BI 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.

WHAT YOU’LL NEED TO SUCCEED:

• 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 financial management, accounting, budgeting, business or IT experience.
• 2+ years of expert level working experience with Microsoft Excel. Specifically in the use of INDEX MATCH, nested IF statements, SUMIF, and COUNTIF functions.
• Proven expert level experience with Power BI & Power Query Editor
• Proven experience with SQL Databases
• Experience with Database Relationship Modeling
• Experience and comfort using Office365 online
• Exposure to and understanding of Power Platform: Power Apps, Power Automate
• Experience with basic automation (i.e., auto-generating Word documents/PDFs from Excel)
• Expert level experience with VBA
• Ability to obtain a National Agency Check with Inquiries (NACI) clearance.

ATTRIBUTES FOR SUCCESS:

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

GDIT IS YOUR PLACE:

• Full-flex work week to own your priorities at work and at home
• 401K with company match
• Comprehensive health and wellness packages
• Internal mobility team dedicated to helping you own your career
• Professional growth opportunities including paid education and certifications
• Cutting-edge technology you can learn from
• Rest and recharge with paid vacation and holidays

#GDITHealthSystems 

#GDITHealth

#GDITFedHealthJobs

The likely salary range for this position is $80,226 - $97,750. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Scheduled Weekly Hours:

40

Travel Required:

None

Telecommuting Options:

Remote

Work Location:

Any Location / Remote

Additional Work Locations:

Total Rewards at GDIT:

Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year. Paid leave and paid holidays are prorated based on the employee’s date of hire. The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

We are GDIT. A global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 30 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology.

We connect people with the most impactful client missions, creating an unparalleled work experience that allows them to see their impact every day. We create opportunities for our people to lead and learn simultaneously. From securing our nation’s most sensitive systems, to enabling digital transformation and cloud adoption, our people are the ones who make change real.

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