Data modeler Jobs in Washington, DC

Senior Financial Analyst/Cost Modeler

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. The salary range (or hiring range) for this exempt position is: $135,000 to $145,000. In addition, we offer a variety of benefits, including company holidays, paid time off, health insurance, dental insurance, vision insurance, life and disability insurance, tuition reimbursement, as well as a 401K with company match. This job will be posted until filled or withdrawn.

Core Duties:

• 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

Travel Requirements 0 - 10% Job Requirements 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