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.
Job Requirements:High School Diploma or GED required; AS/BS in Business Administration, Finance, or a related field preferred.3+ years in a relevant role; telecom industry experience is a plus.Advanced Excel skills, including complex formulas, pivot tables, and data visualization, are essential.Experience with Quickbase and/or other relational databases for project and finance tracking and workflow management is preferred.Highly resourceful, with strong problem-solving skills, adaptability to changing priorities, and pattern-recognition abilities.Takes initiative, demonstrates strong follow-through, and is committed to task ownership.Capable of writing clear, professional emails and communicating effectively with customers, sales teams, and internal stakeholders.Flexible in adapting to changes, with a proactive approach to problem-solving and project ownership.Highly organized, with a focus on accuracy and quality in data management and reporting.Additional SkillsPython (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.
