Lead telecom expense and financial management processes: establish audit and forecasting workflows, analyze invoices and vendor costs, manage databases and ETL, build advanced SQL reports and dashboards, advise stakeholders, and document processes to optimize spending and ensure budget compliance.
Title: Project Manager
Duration: 12 Month
Client: MTA
Location: New York, NY 10004
Note: THIS POSITION WILL REQUIRE CONSULTANT TO WORK ONSITE. NO TELEWORK WILL BE ALLOWED FOR THIS ROLE.
I. SUMMARY OF THE FUNCTION/ROLE
The Telecom Services & Expense Management Unit team provides Telecom Services support, Expense and Financial management support for the MTA IT. The incumbent candidate will assist in establishing and optimizing processes for the Telecom Services & Expense Management Unit, including but not limited to, establishing processes for management and monitoring spending, analysis, forecasting, financial planning, invoice audit and expense analysis, variance reporting and analysis, forecasting procurement requirements for new purchases, contract modifications, and vendor payments.
II. MAJOR RESPONSIBILITIES/ACCOUNTABILITIES
Demonstrated expert level proficiency in SQL, advanced analytics platforms such as Tableau, and the ability to work effectively with large data reports to ensure accuracy in identifying cost savings opportunities and optimizing expenditures and invoice overcharges from carriers.
Establish/Optimize process for the preparation and audit invoices, wireless plans and wireless equipment purchases from all carriers, budget variances/ expense reports for the department; Analyze report for data integrity.
- Establish/Optimize process to Review Cost Benefit Analyses (CBAs) and ROI.
- Establish/Optimize process to Analyze vendor expenses and compare to funding of contract.
- Establish/Optimize process to Prepare budget expense variances reports
- Establish/optimize preparation of reports, and analyses in areas such as Machine-to-Machine accounts, forecasts, expense reports, and business forecasts
- Establish/Optimize preparation status reports on in-process and completed projects. To indicate if projects are within budget parameters from both a dollar and time perspective.
- Establish/Optimize process to prepare and evaluate mid-year and year-end forecasts, monitor spending, and secure rollover of unspent funds
- Establish/Optimize process to track planned and actual expenses in support of the annual budget process
- Establish/Optimize process to Investigate and resolve overcharges and anomalies found during audit and analysis of wireless vendors accounts
Administration & Maintenance Database
- 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 data‑lake integration, pipelines, and blob storage workflows.
- Use DevOps/CI tools for automated deployments and testing
RISKS
- Normal office environment and not subject to any additional risk
III. QUALIFICATIONS
Experience and Education 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 a plus
- In-depth invoice analysis and audit
- Ability to independently compile, research and perform in-depth analysis of projects and data
- Excellent problem-solving skill 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 is required
- Superior skills with Microsoft Office applications (Excel, PowerPoint, Word, Outlook)
- Outstanding organizational and quantitative skills as well as 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 system
- Excellent written and oral communications skills
- PeopleSoft Finance Modules
- ServiceNow Reporting Modules
Additional Skills and Information:
SQL Expert-Level Support Skills
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.
- Write complex SQL queries (joins, windows, CTEs, aggregation).
- Debug and optimize slow queries.
Modern Platform Skills (Cloud‑Friendly)
- Deploy and manage databases in cloud platforms (Azure SQL, AWS RDS, etc.).
- Understand data‑lake integration, pipelines, and blob storage workflows.
- Use DevOps/CI tools for automated deployments and testing
Skills
- Budgeting 6 + Years
- Finance/Accounting 6 + Years
- SQL Server 6 + Years
- Structured Query Language (SQL) 6 + Years
About Us:
Since 2000, Tri-Force Consulting Services (Https://Triforce-Inc.Com) Has Been An Mbe/Sdb Certified It Consulting Firm In The Philadelphia Region. Tri-Force Specializes In It Staffing, Software Development (Web And Mobile Apps), Systems Integration, Data Analytics, System Automation, Cybersecurity, And Cloud Technology Solutions For Government And Commercial Clients. Tri-Force Works With Clients To Overcome Obstacles Such As Increasing Productivity, Increasing Efficiencies Through Automation, And Lowering Costs. Our Clients Benefit From Our Three Distinguishing Core Values: Integrity, Diligence, And Technological Excellence. Tri-Force Is A Six-Time Winner Among The Fastest-Growing Companies In Philadelphia And A Four-Time Winner On The Inc. 5000 List Of The Nation's Fastest-Growing Companies.
Similar Jobs
Professional Services • Design
The Senior Project Manager at Vocon manages complex projects, oversees teams, coordinates resources, and develops strategic plans to ensure successful project delivery and client satisfaction.
Top Skills:
AutocadBluebeam RevuClearviewNewformaRevit
Professional Services • Design
The Project Manager leads small to medium-sized projects, ensuring alignment with client objectives, overseeing project execution, budget management, and coordinating with design and technical teams throughout the project lifecycle.
Top Skills:
AutocadBluebeam RevuClearviewNewformaPm SoftwareRevit
AdTech • Agency • Digital Media • Marketing Tech • Analytics
The Project Manager will oversee projects from concept to completion across various media, managing timelines, budgets, and client interactions while ensuring high-quality delivery.
Top Skills:
Project Management
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
