Finance Consultant Reporting Analyst with Security Clearance
SAIC
2024-11-06 01:46:22
McLean, Virginia, United States
Job type: fulltime
Job industry: I.T. & Communications
Job description
Description JOB DESCRIPTION: SAIC is looking for a candidate to provide Financial Reporting and Analysis, Strategic Financial Planning, Business Process Improvement, Benchmarking and Program Metrics support in a fast-paced and dynamic customer environment with broad impact to the customer's mission. This position supports the customer group and is responsible for developing integrate financial process and procedures to manage the complex budget. Responsibilities include, but are not limited to: Developing and maintaining spend plans Reconciles spend plans with actual and planned expenditures and recommends options to address potential over-or-underutilization of resources Perform short and long-term financial trend analysis leveraging data form all Sponsor financial services Assist personnel in researching and resolving resource and budget issues and questions Provides strategic and programmatic plans and budget support to Sponsor activities Assist with writing language to support and defend budgets for Sponsor as Lead Service Integrator (LSI) for intelligence Community and Service of common Concerns (SoCC) for Sponsor. Prepares supporting documents for budget exercises, over-guidance, unfunded calls, and reprogramming Prepare briefings , budget, spend plans and programmatic activities to support IC and Sponsor reporting requirements Coordinate, generate, complies and/or aggregates responses to fiscal requirements and tasking Facilitate discussions across diverse teams addressing long term (strategic) and short term (tactical) financial matters as they relate to program/project directives, goals, initiatives, etc. Continuously work with Sponsor staff and contractor team members to identify opportunities to improve financial tracking and reporting Stay current with Sponsor and Directorates Resource Management guidance and assist in creating and maintaining baseline practices and procedures that align with guidance Develop strategies and advise Sponsor on presentation and communication of historical and planned financial data to executive leaders and stakeholders Assist in identifying, designing, implementing, and improving integrated processes and procedures for financial reporting requirements Identify, design, implement and improve processes and procedures supporting periodic expense reporting Sponsor Qualifications Required Qualifications: Active TS/SCI W POLY Master's Degree + 15 years related experience, Bachelor's degree + 18 years related experience Ability to analyze and evaluate financial data to resolve inconsistencies, identify key issues, and propose solutions Intermediate/expert level proficiency with Microsoft Excel version on Sponsor systems to perform various types of data analysis -Proficient working with excel workbooks, worksheets, cells and ranges, tables, and worksheet formatting (e.g. including conditional formatting), printing, templates, data validation -Proficient working with formulas and functions to manipulate text, sorting with date and times, creating formulas that count/sum, creating formulas that lookup values without sorting data (e.g. index/match). -Proficient with creating pivot tables from data ranges and tables and adding slicers to assist with filtering data -Proficient with creating charts and graphs -Ability to create Excel dashboards and reports for data validation -Existing knowledge of willingness to learn Excel's Power Query and M-Language to perform various extract, transform, and load (ETL) processes to append, merge, and clean data for follow-on analysis -Existing knowledge or willingness to learn Excel's PowerPivot and DAX to add data to Excel's data model and create calculated fields and/or DAX measures to perform calculations Strong organizational and time management skills to address both planned and unplanned events Excellent oral and written communication skills with ability to adapt/tailor message and delivery based upon intended audience Proven ability to interact/collaborate and lead conversations with various levels of staff and contractor team members in highly matrixed organization Willingness to improve digital acumen and explore how best to leverage capabilities on Sponsor system to support Sponsor activities (e.g. Microsoft Power BI, Microsoft SharePoint, JIRA/Confluence, WordPress, etc.) SAIC accepts applications on an ongoing basis and there is no deadline. Covid Policy: SAIC does not require COVID-19 vaccinations or boosters. Customer site vaccination requirements must be followed when work is performed at a customer site.