Analyze and manage complex datasets related to transportation operations, funding, and client billing.
Develop and maintain advanced Excel-based systems models for forecasting, variance analysis, and travel trend reporting.
Prepare and deliver monthly, quarterly, and annual budget and performance reports to HHS leadership.
Support funding processes, billing reconciliation, and accounting activities for Travel Program customers.
Conduct data mining and financial analysis to identify cost-saving opportunities and operational inefficiencies.
Monitor key performance indicators (KPIs) and support data-driven decision-making initiatives.
Collaborate with program managers, teams, vendors, and IT stakeholders to gather requirements and deliver analytical solutions.
Design and maintain dashboards and visualizations to communicate findings effectively.
Ensure compliance with all applicable federal, departmental, and systems reporting regulations.
Support audits by preparing documentation and assisting with resolution of findings.
Recommend and implement process improvements and automation strategies using Excel and related tools.

Requirements

Minimum of five (5) years of progressive experience as a Business Analyst or Systems Analyst, preferably within a government or public-sector environment.
Expert-level proficiency in Microsoft Excel, including PivotTables, advanced formulas, Power Query, Power BI, and VBA/macros.
Strong knowledge of budgeting, forecasting, cost analysis, and systems reporting principles.
Demonstrated experience extracting, cleansing, and analyzing large datasets from multiple data sources.
Proven ability to perform data mining and trend analysis to support strategic planning and cost control.
Experience generating recurring analytical and systems reports for leadership and stakeholders.
Strong analytical, problem-solving, and attention-to-detail skills.
Excellent written and verbal communication skills, including the ability to present complex data clearly.
Ability to work independently with minimal supervision while managing multiple priorities.
Demonstrated ability to collaborate effectively within cross-functional teams.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data analysisbudgetingforecastingcost analysisdata miningtrend analysisreportingprocess improvementautomationExcel

Soft Skills

analytical skillsproblem-solvingattention to detailwritten communicationverbal communicationindependencetime managementcollaboration