Telecomm Expense Data Analyst

Our Transportation Client in Downtown, NYC is looking for a 12+month Telecommunication Data Analyst strong with SQL and Excel. This will be 2-3 days a week onsite so much be local in NYC., · Role is highly manual and involves extensive data entry from PDFs to Excel.

• Position is 80% auditing, 20% audit/categorization.
• Review of Telecommunication reports and invoices
• Job is not financial reporting but rather auditing and data processing.
• Key skills: tolerance for manual work, attention to detail

Manual Data Entry and Auditing Process · Manual review of PDF invoices required due to lack of Excel conversion.

• Identifiers used to categorize billing types (international, excess, etc.) for pivot table analysis.
• Monthly reports from Telecommunication that do not match invoices dollar-for-dollar.
• Need accurate Excel reports from Telecommunication to align with invoices.

Job Structure, Skills, and Process Flows · Process is highly manual: audit files, extract data, enter into Excel, analyze invoices.

• Requires recording names, phone numbers, business units (e.g., NYC Transit, Metro North, LIRR), and expense causes from invoices.
• Position is not financial reporting; primarily focused on auditing and data organization.

Do you have experience in Tableau?, Manager is looking for a telecommunications expense expert somebody that very detailed oriented that has excellent experience with Excel that can analyze thousands of records from AT&T, Telecommunication ETC...

· In-depth experience with data analytics tools like 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.

• In depth analytical skills and excellent problem-solving abilities for addressing complex challenges
• Manage high-level data reports, performing in-depth analysis of reports and communicating results to leadership, Familiarity with ServiceNow and Peoplesoft
• In-depth experience with Excel spreadsheets, pivot tables, databases, PowerPoint, AI tools, and other relevant tools. SQL is good knowledge.
• Experience in developing reports, presentations, and Power BI dashboards
• Able to identify, recommend, and lead cost-saving opportunities and process improvements
• Superior Financial and analysis skills.
• Superior invoice analysis, reporting large data analysis and vendor payments.
• Experience in Telecom Expense Management, in managing telecom expenses, auditing telecom wireless, wired data usage and charges.
• Outstanding written and verbal communication skills - ability to summarize and explain complex information

$60 - $80 an hour - Contract