Job Duties:•Project Status and Forecast Tracking: Supports Senior Managers, PMs, and Associate PMs in compiling and maintaining accurate project status and forecast data.•PO Management: Manages receipt, tracking, and status of POs in alignment with project requirements, ensuring accuracy across telecom projects and markets.•Project and Line-Item Tracking: Ensures accurate setup and ongoing tracking of project line items, tasks, and requirements based on customer, market, or project scope.•Run-Rate and Trend Analysis: Regularly monitors PO usage, task completion, and database entries to evaluate run-rates, detect delays, and identify trends.•Regular Financial Reporting: Prepares weekly and monthly reports on project financials, including PO balances, revenues, and expense forecasts, with highlighted insights.•Project Status Updates: Compiles internal and customer status reports, detailing progress, and outstanding items, and effectively communicating these to relevant stakeholders.•Issue Troubleshooting and Flagging: Investigate and troubleshoot data discrepancies, PO balance issues, missing POs, revenue run-rate fluctuations, and task completion variances for management review.•Database Support: Ensures data integrity by monitoring, tracking, and updating database entries as needed.•PO Processing: Tracks change orders, verifies processing, and supports PO requests, ensuring alignment with customer requirements.•Billing Support: Monitors milestone completions and prepares billing detail files for the Finance team.•Cost and Pricing Support: Prepares cost and pricing templates for management review and approval.•Process Improvement: Identifies and implements optimizations for streamlined project and financial tracking processes.•Ad-Hoc Analysis and Reporting: Creates custom reports, trackers, and analyses to support team objectives and adapt to evolving project needs.•Data Analysis: Analyzes project and account statistics to identify delivery gaps and propose improvements.
Job Requirements
- ducation: High School Diploma or GED required; AS/BS in Business Administration, Finance, or a related field preferred.
- Experience: 3+ years in a relevant role; telecom industry experience is a plus.
- Excel Expertise: Advanced Excel skills, including complex formulas, pivot tables, and data visualization, are essential.
- Database Proficiency: Experience with Quickbase and/or other relational databases for project and finance tracking and workflow management is preferred.
- Analytical and Data-Centric Mindset: Highly resourceful, with strong problem-solving skills, adaptability to changing priorities, and pattern-recognition abilities.
- Proactive Ownership: Takes initiative, demonstrates strong follow-through, and is committed to task ownership.
- Stakeholder Communication: Capable of writing clear, professional emails and communicating effectively with customers, sales teams, and internal stakeholders.
- Adaptability and Initiative: Flexible in adapting to changes, with a proactive approach to problem-solving and project ownership.
- Attention to Detail: Highly organized, with a focus on accuracy and quality in data management and reporting.
- Additional Skills:
- Python (Preferred): An aptitude for learning new tools and using available resources for independent learning.
- PowerBI (Preferred): Familiarity with tables and basic functions for data visualization and reporting.
Report job
