Suitland,
MD
20746
US
Posted: 08/18/2023
2023-08-18
2023-11-01
Specialization: Other
Job Number: 2972
Salary / Pay Rate: $110,000.00
Job Description
Our client, a defense contractor in Suitland, MD needs a PowerBI Consultant.
Responsibilities
The successful candidate will provide data visualization and full financial management support to include cost estimation and analysis, budget formulation and execution, and financial reporting.
Specific duties may include:
- Develop, enhance, and maintain new dashboards and reports in PowerBI and/or Tableau using budgetary, Technology Business Management (TBM), and Capital Planning and Investment Control (CPIC)-related data.
- Extract, transform, and load (ETL) data before use in PowerBI or Tableau.
- Assist in the setup of new sites, shared servers, or alternative access methods as needed to house dashboards in Microsoft 365 and/or Tableau Server or Desktop environments.
- Lead training and troubleshooting regarding Budgetary, TBM, and CPIC Dashboards and reports for stakeholders.
- Act as a liaison to the Budget division for the creation of new cost collections and report on cost collection carry-forwards.
- Perform trend analysis coordination.
- Be responsible for inputting and maintaining profit and loss information, operating plans, budget planning documents, and vacancies in the federal finance system.
- Review budget with government staff in meetings.
- Coordinate funding for software, travel, and training with the Budget team regarding deobligations and reobligations
- Verify contract modifications within the financial system
- Provide financial data reporting to the division chief and variance reporting to all project sponsors
- Assist in data collection, data tracking, and document production by developing and producing budgetary reports and charts for Security and Exchange Commission (SEC) management using several systems.
- Develop budget variance analyses and projections that support budget execution and formulation with a focus on budget status, variance, and budget projections.
- Prepare monthly plan analyses using charts, tables, and graphs to inform management of budget status.
- Develop written budget justification narratives to support future budget requests.
- Develop briefing packages for program reviews for current and budget year status
- For IT investments, work closely with budget and CPIC staff to develop project tracking and status reports for the approved IT portfolio.
- Review and analyze program office budget requests consistent with management guidance.
- Interpret and assess the impact of updates to budget requests.
- Develop database reports from the system of record for project status on budget allocation and commitment status.
- Prepare budget templates to include detailed data for each project; develop reports for multiple-year budget formulation and operating plan status.
- Document procedures for the major requirements above and report on any challenges.
Required Qualifications
- 6+ years of professional experience
- Experience as a Federal employee or contractor
- Experience CREATING PowerBI or Tableau Dashboards
- Demonstrated experience assisting with the budget formulation process at a federal agency
- Strong experience with MS Office Suite, especially with MS Excel (i.E. Pivot tables, V-Lookups, data imports, batch files)
- Excellent communication skills and the ability to lead/participate in meetings with stakeholders
- BA/BS degree
- Ability to manage Data Visualization workstream independently and serve as direct Point of Contact (POC) for federal clients.
Preferred Qualifications
- 8+ years of professional experience
- Federal budget experience
- Tableau or PowerBI Certifications
- Understanding or experience with CPIC, TBM
- Experience utilizing SharePoint sites
- Familiarity with Purchase Requests (PRs)
- Certified Government Financial Manager® (CGFM®)
Share This Job:
Login to save this search and get notified of similar positions.
