About the Role
The Telecom Services & Expense Management Unit provides IT support, expense management, and financial oversight for the MTA. This role focuses on establishing and optimizing processes for spending monitoring, financial planning, invoice auditing, expense analysis, and procurement forecasting.
Responsibilities
- Identify cost savings opportunities and optimize expenditures using SQL and Tableau.
- Prepare and audit invoices, wireless plans, and equipment purchases.
- Analyze budget variances and expense reports for data integrity.
- Review Cost Benefit Analyses (CBAs) and ROI.
- Analyze vendor expenses against contract funding.
- Prepare budget expense variance reports and business forecasts.
- Track planned and actual expenses for the annual budget process.
- Investigate and resolve overcharges and anomalies in wireless vendor accounts.
- Manage database administration including backups, indexing, and performance tuning.
- Create and optimize ETL/ELT pipelines for data ingestion.
- Write and debug complex SQL queries, views, and stored procedures.
- Manage schema migrations, security, and user access controls.
- Provide stakeholder advisory on business impacts and data architecture.
- Document database structures, workflows, and ETL pipelines.
Requirements
- 10 years of experience in Telecom Services & Expense Management.
- Prior forecasting and reporting experience.
- Strong financial background.
- Ability to independently compile, research, and perform in-depth analysis.
- Ability to gather business requirements and outline business needs.
- Ability to perform financial analysis using various financial systems.
- Must work onsite; no telework allowed.
Skills
- SQL (Expert level)
- Tableau
- Microsoft Office (Excel, PowerPoint, Word, Outlook)
- PeopleSoft Finance Modules
- ServiceNow Reporting Modules
- Database Administration
- ETL/ELT Pipeline Management
- Cloud Platforms (Azure SQL, AWS RDS)
- Budgeting (6+ years)
- Finance/Accounting (6+ years)
- SQL Server (6+ years)
Location
- New York, NY 10004
Work Type
- Onsite
- 12 Month Contract
Experience Level
- 10 years of experience
Education Level
- Master's degree in Finance, Accounting, or Economics preferred
About the Company
- Tri-Force Consulting Services is an MBE/SDB certified IT consulting firm established in 2000.
- Specializes in IT staffing, software development, systems integration, data analytics, automation, cybersecurity, and cloud technology.
- Core values include integrity, diligence, and technological excellence.
