Project Control Analyst

Job Summary:

The Project Controls Analyst supports project and financial success by managing and analyzing large datasets and financial records. This role requires advanced Excel skills, experience with purchase order tracking, financial forecasting, and working with relational databases or database-like platforms. The ideal candidate uses automation tools to improve processes, resolve data discrepancies, and communicate insights clearly. Telecom industry experience, Quickbase development, and familiarity with Power BI or Python are a plus.

Job Duties:

• Project Status and Forecast Tracking: Support Senior Managers, PMs, and Associate PMs by compiling and maintaining accurate project status and forecast data.

• PO Management: Manage receipt, tracking, and status of POs in alignment with project requirements, ensuring accuracy across telecom projects and markets.

• Project and Line-Item Tracking: Set up and track project line items, tasks, and requirements based on customer, market, or project scope.

• Run-Rate and Trend Analysis: Monitor PO usage, task completion, and database entries to evaluate run rates, detect delays, and identify trends.

• Financial Reporting: Prepare weekly and monthly reports on project financials (PO balances, revenues, expense forecasts) with clear insights and actionable recommendations.

• Project Status Updates: Compile and distribute internal and customer status reports, detailing progress, outstanding items, and next steps.

• Issue Troubleshooting: Investigate and troubleshoot data discrepancies, PO balance issues, missing POs, revenue fluctuations, and task completion variances for management review.

• Database & Automation Support: Maintain data integrity by monitoring, tracking, and updating database entries; create automated workflows to improve efficiency.

• PO Processing: Track change orders, verify processing, and support PO requests to ensure alignment with customer requirements.

• Billing Support: Monitor milestone completions and prepare billing detail files for the Finance team.

• Cost & Pricing Support: Prepare cost and pricing templates for management review and approval.

• Process Improvement: Identify and implement process optimizations for streamlined project, financial tracking, and automation workflows.

• Ad-Hoc Analysis and Reporting: Create custom reports, trackers, and dashboards to support team objectives and evolving project needs.

• Data Analysis: Analyze project and account statistics to identify delivery gaps and recommend improvements.

________________________________________

Job Requirements:

• Education: High School Diploma or GED required; AS/BS in Business Administration, Finance, Data Analytics, Computer Science, or related field preferred.

• Experience: 3+ years in a relevant role; telecom industry experience strongly preferred.

• Development Skills: Hands-on development experience with low-code platforms (e.g., Quickbase, Power Apps), including building custom applications—not just using existing ones.

• Relational Database Skills: Experience working with relational databases or database-like platforms (e.g., SQL, Quickbase), with the ability to migrate and manage large datasets currently maintained in Excel.

• Excel Expertise: Advanced Excel, including complex formulas, pivot tables, Power Query, and data visualization.

• Automation Tools: Experience with Power Automate or similar workflow automation tools.

• Analytical & 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: Able to write clear, professional emails and communicate effectively with customers, sales teams, and internal stakeholders.

• Attention to Detail: Organized, accurate, and thorough in data management and reporting.

________________________________________

Preferred Skills:

• Quickbase Development Expertise: Experience designing, building, and deploying Quickbase applications for business workflows.

• Python: Willingness and aptitude to learn scripting for automation and data processing.

• Power BI: Familiarity with building reports and dashboards using data models and DAX functions.

• Telecom Project Knowledge: Understanding of telecom project lifecycles and terminology.