Financial Planning & Analysis - Analyst

Hunt, Guillot & Associates LLC; Ruston (LA); On-site; USD 70,000 - 100,000; Full time

Job summary

Hunt, Guillot & Associates LLC is seeking a technically strong FP&A Analyst in Ruston, LA to own weekly P&L models for multiple business units and support annual budgeting and forecasting cycles. You’ll automate steps and deliver insights that help leaders understand margins and resource needs.

You will learn each business unit’s operations, drive improvements to reporting, and collaborate with stakeholders to provide clear, actionable financial analysis.

Qualifications

• Bachelor's degree in accounting, finance, economics, MIS, or a similar field.
• Three or more years of relevant finance, accounting, or analytics experience.
• Working knowledge of core financial statements and experience building or maintaining financial models.
• Strong proficiency in Excel, with working knowledge of Power Query and Excel automations.

Responsibilities

• Independently own the weekly profit and loss models for an assigned set of business units, taking full ownership of two to three models within the first 30 days.
• Build and maintain working knowledge of each assigned business unit's operations (service offerings, cost structure, client base, and key drivers) and use it to interpret results rather than merely report them.
• Quickly suggest, pitch to the team, and execute improvements that simplify the user experience for business unit leaders and aggressively automate model creation.
• Support forecasting and budgeting through variance analysis, suggest formulas or templates that improve forecast accuracy, and work with business unit leaders to produce forecasts where appropriate.
• Work directly with the business to determine what data is required and where it lives, and deliver it in an easily digestible format.
• Carry FP&A and data analysis projects from inception to completion.
• Work within HGA's reporting stack (Deltek Vantagepoint, Vantagepoint SQL database, Prophix, Power BI, and Excel) to deliver actionable reporting, independently validating data to source

Skills

Ownership

Data analysis

Cross-functional communication

Curiosity about business

Adaptability

Problem solving

Collaboration

Discretion with privileged data

Education

Bachelor's degree (Accounting/Finance)

Tools

Deltek Vantagepoint

Vantagepoint SQL

Prophix

Power BI

Excel

SQL

Job description

Financial Planning & Analysis - Analyst
Accounting Ruston , Louisiana Direct Hire Sep 28, 2026

HGA is looking for a technically strong FP&A Analyst who wants to understand the business behind the numbers. In this role, you'll take direct ownership of core financial planning deliverables and find better ways to build them, all while learning how each of our business units wins, staffs, and delivers its work.

Position Overview

The FP&A Analyst will own the weekly profit and loss models for an assigned set of business units. The analyst will also support business unit leaders through the annual operating expense budget and full profit and loss forecast cycles, and deliver ad-hoc reporting. The expectation is that the analyst will automate manual steps and make outputs more readable and more useful to the leaders who rely on them. Doing this well starts with the business, not the spreadsheet. You'll learn each assigned business unit as its own operation: how it wins work, how it staffs and delivers that work, what drives its margin, and what a good month looks like. We're looking for someone who is hungry to understand how the business works and who pays attention to the trends that point a business unit toward success or toward trouble. The role is built to grow. An analyst who demonstrates strong ownership, sound technical judgment, and credibility with business unit leadership will be mentored toward leading the execution and strategy of HGA's primary FP&A deliverables. The analyst will be entrusted with highly privileged labor cost and compensation data, so a high degree of discretion is required.

Key Responsibilities

Independently own the weekly profit and loss models for an assigned set of business units, taking full ownership of two to three models within the first 30 days

Build and maintain working knowledge of each assigned business unit's operations (service offerings, cost structure, client base, and key drivers) and use it to interpret results rather than merely report them

Quickly suggest, pitch to the team, and execute improvements that simplify the user experience for business unit leaders and aggressively automate model creation

Support forecasting and budgeting through variance analysis, suggest formulas or templates that improve forecast accuracy, and work with business unit leaders to produce forecasts where appropriate

Work directly with the business to determine what data is required and where it lives, and deliver it in an easily digestible format

Carry FP&A and data analysis projects from inception to completion

Work within HGA's reporting stack (Deltek Vantagepoint, Vantagepoint SQL database, Prophix, Power BI, and Excel) to deliver actionable reporting, independently validating data to source

Required Qualifications

Bachelor's degree in accounting, finance, economics, management information systems, or a similar field

Three or more years of relevant finance, accounting, or analytics experience

Working knowledge of core financial statements and experience building or maintaining financial models

Strong proficiency in Excel, with working knowledge of Power Query and Excel automations

Preferred Qualifications

Experience with financial modeling, budgeting, and forecasting

Working understanding of relational database structure (tables, keys, joins, and data grain) and the ability to write SQL queries

Experience with Deltek ERP software (Vision or Vantagepoint) and its underlying database structure

Proficiency in Power BI, including dashboard creation and semantic model setup and maintenance

Background in or understanding of engineering consulting services or other professional consulting services

Skills and Abilities

Takes independent ownership of recurring deliverables and consistently meets a fixed weekly production schedule

Validates their own output before it leaves their desk, reconciling results to known totals rather than trusting a query because it ran

Genuinely curious about how work is won, staffed, delivered, and billed, and treats that understanding as a prerequisite to good analysis

Observes trends that point toward success or toward trouble, and raises them with clear supporting data

Loves problem solving and collaborates well both within and outside the FP&A group

Translates financial results for non-financial audiences and communicates with individuals at all levels of the organization

Reacts promptly and efficiently to shifting priorities, demands, and timelines

Eager to learn, understand, and apply new technologies

Exercises discretion and sound judgment with privileged labor cost and compensation data

HGA is an Equal Opportunity Employer, including Veterans and individuals with disabilities.
#IND1