Senior Transportation Services Business Analyst

Significance Inc; Rockville (MD); Hybrid; USD 125,000 - 138,000; Full time

Job summary

Significance Inc is seeking a Senior Transportation Services Business Analyst to support the Transportation Services division for the Department of Health and Human Services. The role emphasizes budget forecasting, data mining, and advanced Excel modeling to drive program efficiency and accurate client billing.

The ideal candidate will have 5+ years in government/public sector analytics, expert Excel skills, and the ability to coordinate across cross-functional teams while maintaining compliance

Qualifications

• Bachelor’s degree in Finance, Accounting, Business Administration, Public Policy, or related field.
• 5+ years of progressive experience as a Business Analyst or Financial Analyst, preferably in government/public sector.
• Expert-level proficiency in Microsoft Excel, incl. PivotTables, formulas, VLOOKUP, Power Query, Power Pivot, VBA/macros.
• Strong budgeting, forecasting, cost analysis, and financial reporting experience.
• Ability to extract, clean, and analyze large datasets from multiple sources; report generation from transit program data.
• Experience with data mining and trend analysis to support data-driven decisions.
• Excellent written and verbal communication; ability to present complex data clearly.
• Ability to work independently and lead across a broad stakeholder group.

Responsibilities

• Manage monthly client billing cycle and funding processes; drive client communications for all TS lines of business.
• Coordinate with Federal Team to ensure FY funding contracts are created and tracked in the HHS invoicing system.
• Track funding status, utilization, forecasting, and variances to meet recovery targets.
• Develop advanced Excel-based financial models for forecasting, variance analysis, and reporting.
• Analyze large datasets related to operations and client billing to inform decisions.
• Provide monthly, quarterly, and annual budget reports to HHS leadership.
• Support funding, billing reconciliation, and accounting for Transit customers.
• Perform data mining to identify cost savings and efficiency improvements.
• Collaborate with program managers, finance, vendors, and IT to gather requirements and translate into analytics.
• Create dashboards and visualizations to communicate findings clearly.
• Ensure compliance with federal and departmental financial regulations and reporting.

Skills

Advanced Excel skills

Budget forecasting

Data mining & analysis

Financial reporting

Strong communication skills

Independent worker

Cross-functional collaboration

Education

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

Tools

Microsoft Excel (PivotTables, formulas)

PivotTables

Power Query

Power Pivot

VBA/macros

Power BI

Tableau

Job description

At Significance, we believe the best results come from investing in great people. As a woman-owned consulting firm supporting federal civilian and Department of Defense customers, we bring together talented professionals who are passionate about solving complex challenges and making a meaningful impact.

We're proud of the culture we've built - one rooted in trust, collaboration, respect, and genuine relationships. Our people are empowered to share ideas, grow their careers, and deliver exceptional results while supporting missions that matter. It's a culture we're proud of, and one that has earned us recognition as a Washington Business Journal Best Place to Work for seven consecutive years.

Significance, Inc. is seeking a Senior Transportation Services Business Analyst to join our growing team supporting the Department of Health and Human Services (HHS). This position requires the ability to obtain and maintain a Public Trust and is expected to support a hybrid schedule with approximately 1-2 days onsite per week.

We are seeking an experienced and highly analytical Senior Business Analyst to support the Transportation Services (TS) division within the Department of Health and Human Services (HHS). The ideal candidate will have advanced Microsoft Excel skills, along with experience in budget forecasting, accounting principles, and data mining and analysis. The selected candidate will play a key role in supporting critical budget and funding activities across TS while helping drive program efficiency through process improvement and automation.

Required Skills:

• Responsible for the monthly client billing cycle and funding processes; driving client communications and follow up on required client actions for all lines of business within Transportation Services (TS)
• Responsible for working with the Federal Team on ensuring FY funding contracts are created, submitted, executed, finalized to properly establish in the HHS Invoicing system for client billing.
• Responsible for tracking and maintaining reporting on funding status, client utilization, forecasting and identifying variances to ensure the Department’s required recovery on services provided.
• Develop and maintain advanced Excel-based financial models for budget forecasting, variance analysis, and trend reporting.
• Analyze and manage complex datasets related to operations and client billing.
• 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 uncover cost-saving opportunities and operational inefficiencies.
• Collaborate with program managers, finance teams, vendors, and IT to gather business requirements and translate them into analytical solutions.
• Create and maintain dashboards and visualizations to communicate findings clearly and effectively.
• Ensure compliance with all federal and departmental financial regulations and reporting requirements.
• Recommend and implement process improvements and automation strategies using Excel and other tools.
• 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; experience in generating multiple reports from varying data sources on credit card/trn transit program trends/behaviors
• Proven experience in data mining and trend analysis to support analyzing and presenting program specific data and translating into key business decisions.
• 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 in a clear and concise manner.
• Must be able to work independently with limited direction; ability to multitask and be a self‑starter is critical.
• Ability to lead and work collaboratively across a broad team of stakeholders.

Desired Skills:

• Knowledge of Government Financial systems, G-Invoicing, PRICES, UFMS, & CAM
• Transit Program Policy experience a plus
• Experience working with government funding, budgeting or HHS-related Transit programs.
• Knowledge of public sector forecasting and accounting frameworks.
• Experience with data visualization tools such as Power BI or Tableau.
• Processing Mapping Experience (Visio, etc.)
• Knowledge of government credit card regulations, policies & procedures

$125,000 - $138,000 a year

At Significance, your base pay is one part of your total compensation package and is determined within a range. Our pay ranges are based on the local cost of labor benchmarks for each specific role, level, and geographic location.

We carefully consider a wide range of factors when determining compensation, including but not limited to experience; job-related skill sets; relevant education or training; and other business and organizational needs. The salary range listed is for the level at which this job has been scoped. In the event that you are considered for a different level, a higher or lower pay range would apply. This position is also eligible for a comprehensive and generous benefits package.

We are an E-Verify Employer

https://e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster.pdf

https://www.e-verify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf