Summary/Objectives:
Trewon is seeking a Management Analyst to support our Federal Government client. The Management Analyst functions as an expert on management systems, techniques, processes, and technology that will optimize the Division's operations. The Management Analyst engages in analysis of administrative processes and/or Division programs, making recommendations for programs, policies, and activities. Specific processes may vary depending upon the directorate and/or office assigned, with activities, workflows, and systems/tools governed by SOPs that typically evolve over time.
Duties and Responsibilities:
- Resource-request development and analysis. Lead the analysis, assembly, and quality review of multi-appropriation, multi-component formulation submissions (Bureau Resource Request and supporting justifications), reconciling narrative and financial tables into a single internally consistent package that withstands OMB and Departmental scrutiny.
- Requirements and cost-driver modeling. Build and validate analytical models that decompose resource requirements into their underlying drivers — buying-power and inflation factors, position-level staffing and fill costs, and program-level unit costs — reconciling source data drawn from multiple Department systems of record that frequently do not agree with one another, and documenting every assumption so figures remain traceable and defensible under challenge.
- Congressional and OMB tasker response. Analyze and respond to time-sensitive congressional and OMB budget taskers, developing and reconciling figures across multiple funding scenarios and assessing the downstream impact of each on the Bureau’s other active budget submissions.
- Baseline integrity and version control. Resolve discrepancies among competing structural versions to a single authoritative baseline, enforce numerical consistency between narrative and financial tables, and maintain the structural and classification integrity of the submission end to end.
- Crosswalk analysis and leadership decision-support. Produce activity-based re-cuts and delta mapping (base to CBJ to request), compliance crosswalks, and leadership-ready briefings, infographics, and white papers that frame resource trade-offs for senior decision-makers.
Other skills:
- Must demonstrate excellent written and verbal communication skills.
- Must demonstrate proficiency in the use of Microsoft applications (Word, PowerPoint, and Excel).
- Maintains professional competence and specialized knowledge base by keeping abreast of emerging themes and best practices.
- Knowledge of and skill in applying analytical and evaluate techniques to plan, schedule and conduct studies and analyses of management functions or programs.
- Breadth of Diplomatic Security program and data-source knowledge. Substantive familiarity with the ins and outs of some DS programs and functions — no one knows every program, but the role requires real working depth across many — together with hands-on knowledge of at least some of the Department’s principal data sources (e.g., ILMS, GBI, GFMS, RFMS, HR reporting systems, SHIFTS) and the practical nuances of reconciling figures that rarely line up cleanly across them.
- Advanced quantitative modeling in Excel. High proficiency building complex multi-tab workbooks with layered formulas, cross-sheet links, input validation, and error-checking — and the discipline to keep them auditable and recalculation-clean.
- Federal budget formulation expertise. Expert knowledge of the budget cycle, OMB Circular A-11, and the structure and sequencing of resource-request and justification submissions.
- Analytical writing and synthesis. Proven ability to distill dense quantitative and programmatic material into clear, persuasive, decision-ready narrative for non-technical leadership and oversight audiences.
- Data visualization (Power BI). Experience designing and maintaining interactive dashboards and reports — including custom DAX measures — that give leadership real-time visibility into resource, staffing, and spending trends.
- Data transformation and process automation. Hands-on experience with Power Query, Power Automate, SharePoint, and Dataverse to design structured data intake and automate movement of large datasets in place of manual, email-based collection.
- Programmatic document production. Experience generating polished, brand-compliant deliverables (Word, PowerPoint, Excel) programmatically and performing precise, controlled edits to complex documents, including tracked changes.
- Appropriations-law familiarity. Familiarity with appropriations law sufficient to recognize statutory restrictions and object-class considerations and to flag compliance issues for counsel.
- Large-dataset preparation and validation. Skill in collecting, cleaning, structuring, and cross-checking sizable datasets — including selecting correct merge keys, handling non-unique identifiers, and validating internal consistency before figures are relied upon.
Qualifications:
The requirements listed above and below are the knowledge, skills, experience, and abilities required to perform this job successfully. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education Required
Work Environment
This position is fully onsite, five days per week, per our client. This role routinely uses standard office equipment such as computers, phones, photocopiers. The core working hours are 9 AM – 3 PM Monday through Friday. Employees will take a mandatory meal break to cover a minimum of 30 minutes. Manager may grant variance depending on client (government or prime contractor) flow-down specifications, upon employer application.
Work Authorization/Clearance
Clearance required: Secret or higher
