Job Summary:
The Project Controls Analyst will support project and financial success by tracking, analyzing, and managing essential data. This role requires advanced Excel skills, a data-driven approach to financial tracking, and the ability to recognize patterns, identify discrepancies, and resolve issues. Experience with Purchase Order (PO) tracking, financial analysis, and project databases (preferably Quickbase) is ideal. Proactivity, attention to detail, task ownership, resourcefulness, and a willingness to learn are key, with Python and PowerBI knowledge as a plus.
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.