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/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: