Project Manager

This position requires onsite work; no telework is allowed.

About the role

The Telecom Services & Expense Management Unit team provides telecom services support, expense, and financial management for MTA IT. The incumbent will assist in establishing and optimizing processes for the unit, including management and monitoring of spending, analysis, forecasting, financial planning, invoice audit and expense analysis, variance reporting, procurement forecasting, contract modifications, and vendor payments.

Responsibilities

• Demonstrate expert-level proficiency in SQL, advanced analytics platforms such as Tableau, and work effectively with large data reports to identify cost savings opportunities and optimize expenditures, including invoice overcharges from carriers.
• Establish and optimize processes for:
  • Preparation and audit of invoices, wireless plans, and wireless equipment purchases from all carriers.
  • Budget variances and expense reports for the department, ensuring data integrity.
  • Reviewing Cost Benefit Analyses (CBAs) and ROI.
  • Analyzing vendor expenses and comparing them to contract funding.
  • Preparing budget expense variance reports.
  • Preparing reports and analyses for Machine-to-Machine accounts, forecasts, expense reports, and business forecasts.
  • Preparing status reports on in-process and completed projects, indicating budget and timeline adherence.
  • Preparing and evaluating mid-year and year-end forecasts, monitoring spending, and securing rollover of unspent funds.
  • Tracking planned and actual expenses in support of the annual budget process.
  • Investigating and resolving overcharges and anomalies found during audit and analysis of wireless vendor accounts.
• Database Administration & Maintenance:
  • Manage existing database: backups, restores, indexing, performance tuning.
  • Monitor database health, storage, query performance, and job schedules.
  • Ensure data integrity, enforce constraints, and maintain normalization.
• Data Ingestion & Loading:
  • Create, manage, and optimize ETL/ELT pipelines.
  • Load data from files, APIs, vendor portals, Excel, and external systems.
  • Validate incoming data, handle malformed records, and manage staging tables.
  • Automate imports with stored procedures, scripts, or scheduled jobs.
• SQL Coding & Advanced Querying:
  • Write complex SQL queries (joins, windows, CTEs, aggregation).
  • Debug and optimize slow queries.
  • Build views, materialized views, functions, and stored procedures.
  • Use partitioning and indexing strategies to improve performance.
• Data Modification & Structure Updates:
  • Safely add/modify tables, columns, constraints, and relationships.
  • Refactor existing code with backward compatibility.
  • Manage schema migrations and version control for SQL scripts.
  • Plan and execute changes without disrupting production systems.
• Security & Access Control:
  • Manage user roles, permissions, and least privilege access.
  • Implement auditing, logging, and compliance controls.
  • Secure data at rest and in transit; evaluate risks before changes.
• Troubleshooting & Incident Support:
  • Diagnose failed jobs, ingestion errors, missing data, or corrupted records.
  • Investigate slow queries or lock/contention issues.
  • Use logs, execution plans, and profiling to identify root causes.
• Client & Stakeholder Advisory:
  • Translate technical database concepts into clear business impacts.
  • Recommend data models, workflow changes, and architecture improvements.
  • Provide guidance on reporting, analytics, and operational constraints.
  • Set expectations for delivery timelines and resource requirements.
• Documentation & Knowledge Transfer:
  • Document database structures, ETL pipelines, major queries, and workflows.
  • Create onboarding guides, runbooks, and change management notes.
  • Provide training or walkthroughs for non-SQL stakeholders.
• Modern Platform Skills (Cloud-Friendly):
  • Deploy and manage databases in cloud platforms (Azure SQL, AWS RDS, etc.).
  • Understand datalake integration, pipelines, and blob storage workflows.
  • Use DevOps/CI tools for automated deployments and testing.

Requirements

• Master's degree in Finance, Accounting, or Economics preferred.
• 10 years of experience in Telecom Services & Expense Management.
• Experience with project-based financial management, telecom expense management, budgeting/forecasting, and/or auditing is a plus.
• In-depth invoice analysis and audit experience.
• Ability to independently compile, research, and perform in-depth analysis of projects and data.
• Excellent problem-solving skills and analytical capabilities.
• Prior forecasting and reporting experience required; strong financial background.
• Strong communication, analytical, and data organization/interpretation skills.
• Proven ability to multi-task, work under pressure, and meet tight deadlines.
• Attention to detail and accuracy.
• Superior skills with Microsoft Office applications (Excel, PowerPoint, Word, Outlook).
• Outstanding organizational and quantitative skills, with experience managing and resolving complex resource allocation problems.
• Ability to perform high-volume work accurately and independently.
• Ability to gather business requirements and outline business needs.
• Ability to perform financial analysis using various financial systems.
• Excellent written and oral communication skills.
• Experience with PeopleSoft Finance Modules and ServiceNow Reporting Modules.
• Expert-level SQL support skills.

Normal office environment; no additional risk factors.