Senior Transportation Finance & Data Analyst (Hybrid)

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

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