Transit Finance & Analytics Analyst

Metropolitan Transportation Authority; New York (NY); On-site; USD 89,000 - 115,000; Full time

Job summary

Metropolitan Transportation Authority is seeking a Transit Management Analyst to support Subways finance by developing budgets, monitoring spending, and delivering reports to leadership.

The role involves coordinating with divisions, preparing dashboards, and responding to senior leadership requests with financial analysis and data-driven insights. Strong skills in Power BI, Excel, and basic SQL are essential.

Qualifications

• Analytical, technical, and organizational skills with ability to manage multiple priorities.
• Proficiency in building, analyzing, and interpreting reports and dashboards using Power BI, Excel, and Office apps.
• Basic knowledge of SQL and use of DataLake for data access and interpretation.

Responsibilities

• Serve as liaison to divisions to budget and track materials, contracts, headcount, and overtime.
• Collaborate with peer teams and stakeholders on financial planning, budgeting, and reporting.
• Prepare monthly dashboards and financial/operational reports for management and stakeholders.
• Respond to ad hoc requests with financial analysis and supporting data.
• Provide data collection, analysis, and coordination support to Division Operations.

Skills

Analytical skills

Budgeting

Reporting & dashboards

Power BI

Excel

SQL basics

Communication

Data visualization

Education

Master's degree in a related field

Bachelor's degree with 2+ years in budget/financial administration

Tools

Power BI

Excel

SQL

Job description

Metropolitan Transportation Authority is seeking a Transit Management Analyst to support Subways finance by developing budgets, monitoring spending, and delivering reports to leadership.

The role involves coordinating with divisions, preparing dashboards, and responding to senior leadership requests with financial analysis and data-driven insights. Strong skills in Power BI, Excel, and basic SQL are essential.