Senior Financial Analyst/Cost Modeler (RMU)

Capefox•Arlington, TX

15d

About The Position

Cape Fox subsidiary, Kwaan Tech, LLC, is seeking a highly organized and motivated Senior Financial Analyst/Cost Modeler to support the Resource Management Unit (RMU) for a federal government client. The position will support budget strategy and planning, service level agreements, interagency agreements, legislative proposals, cost assessments and fee setting, rulemaking, and audit and management control processes. This position is contingent upon contract award.

Requirements

Must hold a bachelor’s degree
10 years of experience in project or programming management
Expert knowledge and demonstrated use of Activity Based Costing (ABC) methodology
Expertise in working with large data extracts and files, including sorting expenditure data to format for fee modeling purposes
Knowledge and skills in utilizing user fee statutes, regulations, and policies
Skills in advanced data analytic tools, including Python, R, SQL
Experience conducting risk analysis and statistical forecasting
Data visualization skills, particularly in Power BI, R, and/or Tableau strongly preferred
Expert knowledge of data collection, manipulation, modeling, and analysis
Familiarity with federal financial systems preferred
Experience in providing documents, responding to findings, and creating responses for external audiences, including General Accountability Office (GAO) and Office of the Inspector General (OIG) audits
Must possess excellent verbal and written communication skills
Must possess a customer service approach, to include but not limited to a people-first attitude, problem-solving, and maintaining the highest standards of personal/professional ethics
Must be Proficient in the use of Microsoft applications (MS Word, PowerPoint, and Excel)
Knowledge of and skill in use of various virtual meeting platforms to include Microsoft Teams, Webex, and Zoom with the ability to adapt to using other various remote work tools
Expert knowledge of and skill in applying analytical and evaluative techniques in order to plan, schedule, and analyze complex processes
Department of State experience required
Experience performing consular activities and processes, strongly preferred
Must be a U.S. citizen with a valid U.S. passport and possess or obtain/maintain a minimum Secret clearance
Must have authorization to work in the United States as defined by the Immigration Reform Act of 1986

Nice To Haves

Data visualization skills, particularly in Power BI, R, and/or Tableau strongly preferred
Familiarity with federal financial systems preferred
Experience performing consular activities and processes, strongly preferred

Responsibilities

Functions as a Cost Modeler/Senior Financial Analyst performing expert analysis, coordination, and running of the Cost-of-Service Model (CoSM) software for the RMU
Drafts and delivers annual cost model updates per requirements from designated Government Point of Contact in collaboration with team
Serves as Costing expert for consular services
Uses knowledge of consular services and functions to verify the assumptions and calculations in the cost model
Recommends fees for consular and reimbursable services in accordance with applicable laws, regulations, and policies to ensure cost recovery
Analyze unit costs to account for various scenarios that affect changes in workload, resources, costs, and policies
Maintains multiple auditable versions of annual cost model data sets with multiple permutations that reflect various phases of the federal budget cycle and policy requirements
Uses advanced data analysis tools, including SQL, R, and Python, to integrate data from multiple sources for analysis and integration into the cost modeling software
Recommends and implements changes to the model structures and processes to improve the balance of efficiency, accuracy, and precision of the annual cost analysis
Applies expert knowledge of consular services, fees, and collection authorities to assist with revenue and carryforward analysis
Updates Standard Operating Procedures for maintaining the cost model, data collection integration, and data structure
Trains colleagues on the model, data collection, and software to support a whole team’s effort in efficient and accurate cost modeling
Participation in all team meetings is directed to include topics such as planning, preparation, data collection and analysis, data validation, modeling, model data validation, unit cost analysis, and fee and revenue analysis
Provides expert recommendations and innovations to take full advantage of cost modeling techniques, software, and policies to improve efficiency and accuracy of cost models
Other duties as required by the team and /or assigned by RMU leadership