Revenue Account Analyst

Summary

The Revenue Recognition/WIP Analyst is responsible for the accurate and timely management of Shelton Energy’s revenue recognition and work-in-progress (WIP) reporting. This position maintains financial schedules, analyzes unbilled revenue, reconciles WIP activity, and supports accurate financial reporting. The ideal candidate is self-motivated, detail-oriented, thorough, and comfortable working within recurring weekly and monthly deadlines.

This position is expected to be onsite in our Lafayette, LA office.

Duties and Responsibilities

Weekly Reporting

• Run weekly reports in Sage and review the results for completeness and accuracy.
• Maintain Excel spreadsheets containing timesheet, revenue, and WIP data.
• Add and organize worksheets, create and maintain formulas, and update summary pages.
• Verify spreadsheet calculations and investigate missing, unusual, or inconsistent information.
• Coordinate with accounting, billing, operations, and project personnel to resolve discrepancies.
• Complete all weekly reporting responsibilities according to established deadlines.

Unbilled Revenue

• Review unbilled revenue and WIP balances in accordance with Company policy.
• Inquire about and investigate aged, unusual, or unsupported unbilled amounts.
• Obtain supporting information and explanations from the appropriate personnel.
• Track unresolved items and follow up until they are supported, billed, adjusted, or otherwise resolved.
• Escalate exceptions and potential policy issues to management in a timely manner.
• Maintain clear documentation supporting findings and adjustments

Process and Department Support

• Maintain organized records and consistent processes for recurring weekly and monthly activities.
• Communicate questions and discrepancies clearly and professionally.
• Recommend improvements to spreadsheets, reconciliations, and reporting processes.
• Assist with audit requests and other accounting projects related to revenue recognition and WIP.
• Protect confidential employee, customer, financial, and Company information.

Monthly Revenue Recognition and WIP

• Manage current-period revenue recognition and WIP spreadsheets throughout the monthly close process.

• Update schedules with current timesheet, billing, revenue, and project information.

• Reconcile monthly WIP entries to Sage and applicable supporting schedules.

• Research and resolve differences between the general ledger, WIP schedules, and source data.

• Prepare or support WIP and revenue recognition entries for management review.

• Ensure monthly schedules are complete, accurate, and retained with appropriate documentation.

• Assist the Controller and accounting team with related month-end close activities.

Qualifications

Education & Experience

• Associate’s or Bachelor’s Degree in Accounting, Finance, Business, or related field. Equivalent work experience may be considered in lieu of degree.
• 2+ years experience in project accounting or auditing preferred.
• Strong Microsoft Excel skills, including formulas, data organization, and summary reporting.
• Strong attention to detail and a commitment to producing complete, accurate, and well-supported work.
• High analytical, organization, problem-solving, and time-management skills.
• Excellent written and verbal communication skills.
• Experience with Sage or similar accounting software preferred.

Core Competencies

Attention to detail, thoroughness, accountability, ethical-decision making, professional communication, adaptable, strong time management and organizational skills, ability to work in a fast-paced construction environment, strong analytical and problem-solving abilities.

Workingconditions/PhysicalRequirements/Travel

The job operates in a professional office environment using standard office equipment. Occasionally the job will operate in a field environment.

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools, or controls; reach with hands and arms; climb stairs; see, talk, or hear. The employee must occasionally lift or move office products and supplies, up to twenty pounds.

Core days are typically Monday through Friday from 8:00 a.m. to 5:00 p.m., but hours are flexible and may extend outside of the core day with primary function being 100% completion of weekly billings. This position may require weekend and/or holiday work.

Additional Duties

The above statements are typically assigned to employees in this position. They are not to be construed as an exhaustive list of their duties and responsibilities. The Company reserves the right to assign or reassign duties and responsibilities to the job at any time.

Direct Reports/Position Reporting

This position has no direct reports. The Accounts Payable/Payroll Specialist reports to the Controller.