APTIM→
Sr Project Controls Analyst at APTIM in San Diego, CA
Job Description
Job Overview
As a Sr. Project Controls Analyst with APTIM, you will have the chance to work on project teams using expertise in forecasting, change management, cost management, project budget analysis, earn value analysis, risk management, proposal support, estimate development, cashflow and other financial reporting tools. You will lead in the developing data structures and reporting tools and solutions for large and complex projects utilizing advanced Excel and Power BI knowledge. You will be expected to present to all levels of management. Additionally, you will work directly in CPM Schedule software (Primavera) to create, update, and analyze project schedules.
This position will primarily support the Remediation and Technical Services contracts for the Department of War/Defense and the EPA. These projects include remediation in accordance with CERCLA superfund processes, and laboratory and sampling support. Prior Experience with federal government contracting is preferred. Advanced Proficiency in Microsoft Excel is required. Proficiency in Primavera P6, including hands-on scheduling and maintenance, is desirable. Applicant will be based in the San Diego, CA or Denver, CO office. Periodic travel to project sites may be required.
Key Responsiblities:
Will perform tasks associated with both Cost Management/Control and CPM Scheduling. Includes in depth knowledge and leadership of, Risk/Contingency Management, and Earned Value Management. Will have developed an expert level of proficiency with Microsoft Excel/Power BI data management techniques.
Tasks will include performing, leading a team, or mentoring junior staff in the following:
- Perform Daily Weekly/Monthly Statusing of Project Cost Reports as required by contract
- Perform periodic project job site audits, surveillances, etc. as required.
- Perform reconciliation of budget vs. actual variances and identification of drivers.
- Support/Produce Client Invoicing per the contract
- Performing/Reporting monthly cash and billing forecasts
- Use of Microsoft Power BI to create graphical dashboards of excel data for use in management presentations or project specific data management and visualization solutions.
- Provide Professional recommendation and/or implementation of correct actions.
- Manages Financial aspects at the program level
- Performance of independent assessments of project processes and work products.
- Management and consolidation of joint venture financial data.
- Update schedules for accurate progress measurement and remaining duration either directly or with earned value tracking system data.
- Resource load schedules
- Input and document scope change activities into the schedule
- Independently perform the transformation of project estimating budget data into the cost breakdown structure and initiation of cost reporting tools/reports
- Preparation, processing, and tracking of change orders to ensure cost report budgets are current
- Perform Analysis and Forecasting of key cost categories by cost code
- Management of Earned value data, CPM schedule data, and risk/contingency data in developing a holistic picture of project performance.
- Perform monthly accrual of project costs and revenue for accrual method accounting and forecast development
- Development and Presentation of Cost Status and Forecast Reports to both internal and external stakeholders.
- Facilitate/Lead risk workshops, Management of Risk Register, identifying potential project risks and developing mitigation strategies.
- Coordinate with project managers and other team members to ensure accurate and timely reporting of project status and performance metrics.
- Establish and maintain project documentation and records, ensuring compliance with company policies and regulatory requirements.
- Negotiate contracts and agreements with vendors, subcontractors, and other external parties to secure the necessary periodic reporting data for cost status and forecasting.
- Interface directly in CPM schedule software to extract data, perform routine updating/progressing tasks, and create basic project schedules.
- Demonstrated ability to use technical concepts and industry standard project management tools and techniques to effectively coordinate project control activities and functions to creatively and effectively solve complex problems and identify correlated data to inform decision making.
- Strong written and verbal communication skills.
- Strong attention to detail and accuracy.
- Ability to maintain a high level of confidentiality.
- AACE and/or PMI Certification
- Understands the basic grammar/concepts of multiple professional disciplines and can work across discipline siloed teams to solve complex interrelated problems.
- Ability to visualize and articulate solutions to work across discipline teams and lead them to successful implementation.
- Willingness/Confidence to lead and mentor junior staff.
- Understanding of various contract structures Fixed Price, Unit Price, Cost Reimbursable and the implications that these structures have on project cost and revenue.
- Understanding of the fundamental concepts of accrual basis and double entry accounting.
- Familiarity with government contract reporting and FAR standards.
- Familiarity with Davis Bacon/Service Contract act and prevailing wages.
- Proficient in Microsoft Office, especially Excel.
- Familiarity with Power BI Data and extraction of datasets, and dashboard creation
- Proficient working in JD Edwards or other ERP Systems.
- Proficient Primavera P6 or Microsoft Project CPM scheduling software.
- Communicating and Interpreting project cost data to executive leadership of the organization and with Senior external leadership.
About APTIM
APTIM enhances the quality of the environment, wellbeing of people, resilience of communities, and opportunity for employees to make a difference, not just a living. A leading professional solutions firm, we specialize in environmental, sustainability, resilience, and infrastructure solutions. Our team of experts provide these integrated solutions for forward-thinking government agencies, commercial and industrial clients, and energy customers. Together, we create sustainable and resilient communities for all.
What you can expect from APTIM:
- Work that is worthy of your time and talent
- Respect and flexibility to live a full life at work and at home
- Dogged determination to deliver for our clients and communities
- A voice in making our company better
- Investment into your personal and professional development
As of the date of this posting, a good faith estimate of the current pay range for this position is $112,000 - $186,000 Per Year. Compensation depends on several factors including: experience, education, key skills, geographic location of the position, client requirements, external market competitiveness, and internal equity among other employees within APTIM.
Employee Benefits
APTM Federal Services is committed to providing an extensive range of benefits that protect and promote the health and financial well-being of our employees and their families through the APTIM Benefits Marketplace https://aptim.makeityoursource.com/.
- Medical, vision, and dental insurance: Through the marketplace, our employees can choose benefits from five metallic levels and several carriers to find the right benefits that work for them in their location.
- Company paid and optional Life insurance
- Short-term and long-term disability insurance
- Accident, Critical Illness, and Hospital Indemnity coverage
- Paid holidays, vacation, and sick leave (eligibility based on company policy and applicable law)
- 401(k) APTIM offers three 401k plans through the Aon Pooled Employer Plan (PEP). The specific plan you are eligible for depends on the business unit you are in. The details of the largest plan are found here:
Watch our video:
About APTIM - In Pursuit of Better