Senior Transportation Services Business Analyst

Jobtailor; Rockville (MD); On-site; USD 90,000 - 130,000; Full time

Job summary

Jobtailor is seeking a Financial Analyst to support the Transportation Services division within the Department of Health and Human Services in Rockville, MD. The role focuses on budgeting, forecasting, funding cycles, and complex data analysis to drive cost-saving insights and process improvements.

The ideal candidate will have 5+ years of government/public sector experience, expert Excel skills, and experience with HHS invoicing, G-Invoicing, and financial reporting tools.

Qualifications

• Bachelor’s degree in Finance, Accounting, Business Administration, Public Policy, or a related field.
• 5+ years of progressive experience as a Business Analyst or Financial Analyst, preferably in a government or public sector environment
• Expert-level proficiency in Microsoft Excel, including PivotTables, advanced formulas, VLOOKUP, Power Query, Power Pivot, and VBA/macros
• Strong understanding of budgeting, forecasting, cost analysis, and financial reporting
• Demonstrated ability to extract, clean, and analyze large datasets from multiple sources
• Proven experience in data mining and trend analysis
• Familiarity with accounting software systems and financial reporting tools
• Strong attention to detail and problem-solving skills
• Excellent written and verbal communication skills, with the ability to present complex data clearly and concisely
• Ability to work independently with limited direction; multitasking and self-starting ability
• Ability to lead and work collaboratively across a broad team of stakeholders
• Knowledge of Government Financial systems, G-Invoicing, PRICES, UFMS, and CAM
• Transit Program Policy experience a plus
• Experience with government funding, budgeting, or HHS-related Transit programs
• Knowledge of public sector forecasting and accounting frameworks
• Experience with Power BI or Tableau
• Processing Mapping experience, such as Visio
• Knowledge of government credit card regulations, policies, and procedures
• Must comply with applicable U.S. employment authorization requirements as an E-Verify employer

Responsibilities

• Support the Transportation Services division within the Department of Health and Human Services
• Manage the monthly client billing cycle and funding processes
• Drive client communications and follow up on required client actions across Transportation Services lines of business
• Work with the Federal Team to establish, submit, execute, and finalize FY funding contracts in the HHS Invoicing system
• Track and report funding status, client utilization, and forecasting; identify variances
• Develop and maintain advanced Excel-based financial models for budget forecasting, variance analysis, and trend reporting
• Analyze and manage complex operations and client billing datasets
• Provide monthly, quarterly, and annual budget reports to HHS leadership and stakeholders
• Support funding processes, billing reconciliation, and accounting processes for Transit customers
• Conduct data mining to identify cost-saving opportunities and operational inefficiencies
• Collaborate with program managers, finance teams, vendors, and IT to gather requirements and develop analytical solutions
• Create and maintain dashboards and visualizations
• Ensure compliance with federal and departmental financial regulations and reporting requirements
• Recommend and implement process improvements and automation strategies using Excel and other tools

Skills

Excel advanced

Budgeting

Forecasting

Data analysis

Data mining

Power BI

Tableau

VBA/macros

PivotTables

VLOOKUP

Communication

Education

Bachelor’s degree in Finance, Accounting, Business Administration, Public Policy

Tools

Power BI

Tableau

Visio

HHS Invoicing System

Accounting Software Systems

G-Invoicing

PRICES

UFMS

CAM

Job description

• Support the Transportation Services division within the Department of Health and Human Services
• Manage the monthly client billing cycle and funding processes
• Drive client communications and follow up on required client actions across Transportation Services lines of business
• Work with the Federal Team to establish, submit, execute, and finalize FY funding contracts in the HHS Invoicing system
• Track and report funding status, client utilization, and forecasting; identify variances
• Develop and maintain advanced Excel-based financial models for budget forecasting, variance analysis, and trend reporting
• Analyze and manage complex operations and client billing datasets
• Provide monthly, quarterly, and annual budget reports to HHS leadership and stakeholders
• Support funding processes, billing reconciliation, and accounting processes for Transit customers
• Conduct data mining to identify cost-saving opportunities and operational inefficiencies
• Collaborate with program managers, finance teams, vendors, and IT to gather requirements and develop analytical solutions
• Create and maintain dashboards and visualizations
• Ensure compliance with federal and departmental financial regulations and reporting requirements
• Recommend and implement process improvements and automation strategies using Excel and other tools

Requirements

• Bachelor’s degree in Finance, Accounting, Business Administration, Public Policy, or a related field
• 5+ years of progressive experience as a Business Analyst or Financial Analyst, preferably in a government or public sector environment
• Expert-level proficiency in Microsoft Excel, including PivotTables, advanced formulas, VLOOKUP, Power Query, Power Pivot, and VBA/macros
• Strong understanding of budgeting, forecasting, cost analysis, and financial reporting
• Demonstrated ability to extract, clean, and analyze large datasets from multiple sources
• Proven experience in data mining and trend analysis
• Familiarity with accounting software systems and financial reporting tools
• Strong attention to detail and problem-solving skills
• Excellent written and verbal communication skills, with the ability to present complex data clearly and concisely
• Ability to work independently with limited direction; multitasking and self-starting ability
• Ability to lead and work collaboratively across a broad team of stakeholders
• Knowledge of Government Financial systems, G-Invoicing, PRICES, UFMS, and CAM
• Transit Program Policy experience a plus
• Experience with government funding, budgeting, or HHS-related Transit programs
• Knowledge of public sector forecasting and accounting frameworks
• Experience with Power BI or Tableau
• Processing Mapping experience, such as Visio
• Knowledge of government credit card regulations, policies, and procedures
• Must comply with applicable U.S. employment authorization requirements as an E-Verify employer

Core Competencies

Demonstrates expert-level proficiency in Microsoft Excel for financial modeling, budgeting, and forecasting, alongside strong analytical skills for data mining and trend analysis. Capable of managing complex datasets and ensuring compliance with federal financial regulations while collaborating effectively with diverse stakeholders.

Highest-signal resume keywords

• Expert-Level Proficiency In Microsoft Excel
• Budgeting And Forecasting
• Data Mining And Trend Analysis
• Government Financial Systems Knowledge
• Experience With Power BI Or Tableau

ATS Optimization Keywords

Hard Skills

• Financial Modeling
• Budget Forecasting
• Variance Analysis
• Data Analysis
• Cost Analysis
• Financial Reporting
• VLOOKUP
• Power Query
• VBA/Macros
• PivotTables

Soft Skills

• Attention To Detail
• Problem-Solving Skills
• Written And Verbal Communication
• Multitasking Ability
• Collaboration Skills

Industry Keywords

• Government Funding
• Public Sector
• Transit Program Policy
• Financial Regulations
• G-Invoicing
• PRICES
• UFMS
• CAM
• U.S. Employment Authorization
• E-Verify

Tools & Technologies

• HHS Invoicing System
• Accounting Software Systems
• Power BI
• Tableau
• Visio