Project Control Analyst - Finance and Accounting

Job Summary:

Tundra Federal, an Akima company, is seeking a talented Project Controls Analyst due to recent business growth. If you are looking for an organization where you can grow your career, come talk to us. We continue to win new work, and we have great managers who will help you grow professionally in a dynamic team environment.

This position reports directly to the Project Control Director and works closely with the PM on a large program. The ideal person will know how to build, analyze and share reports generated in Cognos and/or PowerBI and will be an exceptional communicator. If you have a solid grasp of CostPoint, if you know EACs and ETCs, and work regularly with Excel, we have a great opportunity for you! Come make a move to us as your next career home.

Job responsibilities:

• Assist Project Managers and operation leads in all duties related to financial and performance, planning, tracking, and reporting.

• Initiate, monitor and maintain proper project setup in Deltek Costpoint

  • Process includes project number structure, funding setup, revenue and billing formula setup, project ceilings, labor categories, billing rates, rate sequence, project workforce, etc.

• Provide customer reporting deliverables with tight turnaround times.

• Financial Management:

  • Works with the PM to develop and maintain project cost baselines and budgets.

  • Monitors project actuals and resolves time charging and non-labor cost allocation issues.

  • Monitors outstanding project commitments (e.g., travel, subcontracts)

  • Develops monthly project financial forecasts/EACs and conducts variance analysis.

  • Monitors and communicates the project’s burn rate against funding remaining.

  • Initiates and routes at risk forms for projects that are required to perform at risk.

  • Performs detailed quarterly unbilled analysis.

  • Communicates project status and findings to Project and Operations Management monthly at a minimum.

• Month End Close

• Consistently meets all required deadlines (contract modifications, project setup changes, accruals, revenue adjustments, at risk approvals)

  • Documents project status each month on SharePoint to support corporate month-end close reviews.

• Proactively monitor project timecards, ensure timecard errors are identified and corrections are processed in timely manner.

• Ensure accuracy of project-related expense reports and ensure timely processing.

• Project A/R and A/P:

  • Ensure subcontract/vendor payments are processed and coded correctly and in timely fashion.

  • Provide customer specific invoice backup.

  • Review and approve draft invoices prior to submission to customer.

  • Monitor billing and payment status of customer invoices.

  • Perform monthly accrual calculations.

  • Assists PM with invoice collection.

  • Helps reconcile cash applications if needed.

• Assist project team with:

  • Work authorizations

  • Identifying and analyzing project risk

  • Development and execution of internal and external project reviews

  • Initiating Purchase Requisitions and goods receipts in Deltek Costpoint’s Procurement module

  • Generation, analysis and communication of internal financial reports

  • Communicating timecard and expense practices for the project

  • Funding notifications to the customer (i.e. 75% letters)

Minimum Qualifications:

• Bachelor’s degree in Accounting or Business related field preferred.

• Minimum of 5 years related experience providing project accounting support for services contracts for federal government contractors.

• Deltek CostPoint Project Module Proficiency.

• Solid knowledge of project setup in Deltek CostPoint.

• Ability to work independently, self-motivated, proactive.

• Track record of delivering well-organized and accurate work.

• Strong written and verbal communication skills.

• Proven ability to work well with accounting, contracts, and project personnel to accomplish tasks.

Equipment and Applications

• MS Excel Proficiency (Vloopkup / SUMIF formulas, pivot tables, etc.)

• Cognos reporting experience (query studio or report studio a plus)

• Power BI

• Deltek Time and Expense

• Strong skills in MS Word, PowerPoint, and Microsoft Project

• Experience using and configuring MS SharePoint team sites