Hybrid Transportation Finance & Analytics Lead

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

Benefits offered by this job

Hybrid schedule

Comprehensive benefits

Job summary

Significance, Inc. seeks a Senior Transportation Services Business Analyst to join our team supporting the Department of Health and Human Services (HHS).

The role focuses on advanced Excel modeling, budgeting, forecasting, and data mining to support funding and client billing for Transportation Services. Ideal candidates will drive dashboards and analytics, collaborate with program managers, finance teams, vendors, and IT, and help improve processes through automation.

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; experience in generating multiple reports from varying data sources on credit card/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.

Responsibilities

• Manage monthly client billing cycle and funding processes; drive client communications and follow-ups for all Transportation Services lines of business.
• Coordinate with the Federal Team to ensure FY funding contracts are created, submitted, and executed in the HHS invoicing system.
• Track and report funding status, client utilization, forecasting, and variances to support department recovery goals.
• 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 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 requirements and translate them into analytical solutions.
• Create and maintain dashboards and visualizations to communicate findings clearly.
• 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

Advanced Excel

Budget forecasting

Data mining

Financial reporting

Dashboards

Data analysis

Excellent communication

Independent worker

Cross-functional collaboration

Education

Bachelor's degree in Finance or related field

Tools

PivotTables

Power Query

Power Pivot

VBA/macros

Power BI

Tableau

Job description

Significance, Inc. seeks a Senior Transportation Services Business Analyst to join our team supporting the Department of Health and Human Services (HHS).

The role focuses on advanced Excel modeling, budgeting, forecasting, and data mining to support funding and client billing for Transportation Services. Ideal candidates will drive dashboards and analytics, collaborate with program managers, finance teams, vendors, and IT, and help improve processes through automation.