Business Analyst

COMPANY OVERVIEW

JTI is a growing, progressive, and team-oriented company rooted in family values. We know that our employees are our number one asset. We not only encourage, but foster an environment that promotes professional growth, internal promotions, continuing education, and a safe work environment.

We are proud to employ a team of dedicated professionals with expertise in electrical construction, mechanical fabrication and installation, engineering, and controls and automation fields who are leaders in their disciplines. We strive to be an excellent strategic partner for clients, providing solutions and adding value to their businesses.

POSITION OVERVIEW

The Business Analyst serves as the analytical backbone of JTI’s financial and operational reporting. This role bridges accounting, project management, and executive decision-making by maintaining job cost reporting, Work-in-Progress (WIP) schedules, and Percentage-of-Completion (POC) revenue recognition analysis. The ideal candidate combines deep accounting knowledge with advanced Excel capabilities to deliver actionable insights on project profitability, billing accuracy, and financial forecasting across JTI.

PRIMARY RESPONSIBILITIES

• Develop, maintain, and distribute monthly WIP (Work-in-Progress) schedules and POC (Percentage-of-Completion) reports for all active projects, ensuring revenue recognition aligns with ASC 606 / GAAP standards.
• Prepare and analyze job cost reports, comparing estimated costs to actual costs, and identify variances in materials & overhead (M&O) and labor & subcontractor (L&S) categories.
• Build and maintain complex Excel-based financial models for project profitability analysis, forecasting, and scenario planning using advanced formulas, pivot tables, Power Query, and macros/VBA.
• Reconcile project billings against costs to identify over/under billing positions and produce monthly billing variance reports for project managers and executive leadership.
• Partner with project managers to review contract values, change orders, estimated costs at completion (EAC), and profit fade/gain trends on a project-by-project basis.
• Support month-end and year-end close processes by preparing journal entries related to WIP adjustments, revenue recognition, and cost accruals.
• Analyze historical project data to identify trends in cost overruns, margin erosion, and billing timing to support continuous improvement in estimating and project execution.
• Create and maintain dashboards and executive summary reports that provide real-time visibility into project financial health, backlog, and cash flow projections.
• Assist with annual budgeting and quarterly reforecasting by gathering project-level inputs and consolidating into company-wide financial plans.
• Collaborate with accounting, operations, and estimating teams to ensure consistency and accuracy of financial data across all systems.
• Support internal and external audit processes by preparing WIP schedules, supporting documentation, and responding to auditor inquiries.
• Continuously improve reporting processes, templates, and workflows to increase efficiency, accuracy, and timeliness of financial deliverables.

LEADERSHIP RESPONSIBILITIES

• N/A

QUALIFICATIONS

EDUCATION and/or EXPERIENCE: SPECIALIZED KNOWLEDGE AND SKILLS:

• Bachelor’s degree in Accounting, Finance, Business Administration, or related field required.
• 3–5 years of experience in financial analysis, cost accounting, or project accounting, preferably in construction, engineering, or a project-based industry.
• Strong understanding of WIP (Work-in-Progress) accounting, Percentage-of-Completion (POC) revenue recognition, and job costing methodologies.
• Expert-level proficiency in Microsoft Excel including advanced formulas (INDEX/MATCH, SUMIFS, XLOOKUP, array formulas), pivot tables, Power Query, conditional formatting, data validation, and VBA/macros.
• Working knowledge of GAAP, specifically ASC 606 revenue recognition standards as applied to long-term contracts.
• Experience with ERP/accounting systems (e.g., Foundation, Sage, Viewpoint, Procore, or similar construction/project accounting software) preferred.
• Strong analytical and problem-solving skills with exceptional attention to detail and data accuracy.
• Ability to communicate complex financial information clearly to non-financial stakeholders including project managers and executive leadership.
• Experience preparing schedules and supporting documentation for internal and external audits.
• Self-motivated with the ability to manage multiple priorities, meet deadlines, and work independently in a fast-paced environment.
• Proficiency in Microsoft Office Suite (Word, Outlook, PowerPoint) and familiarity with business intelligence tools (Power BI, Tableau) is a plus.

EQUIPMENT & APPLICATIONS /WORKING CONDITIONS & PHYSICAL DEMANDS:

• Sitting for Extended Periods – Spending long hours at a desk working on a computer, reviewing plans, or handling paperwork.
• Typing and Computer Use – Engaging in frequent keyboard and mouse use for emails, reports, scheduling, and documentation.
• Reading and Reviewing Documents – Handling blueprints, contracts, and reports, which may require prolonged focus and visual strain.
• Occasional Lifting and Carrying – Moving documents, plans, or office supplies, typically up to 10-25 lbs.
• Repetitive Hand and Finger Movements – Writing, typing, and using office equipment such as printers and phones.
• Walking and Standing – Moving between office spaces, attending meetings, and sometimes walking through job sites.
• Driving or Traveling – Visiting job sites or attending off-site meetings as necessary.
• Wearing PPE as Needed – Donning safety gear (e.g., hard hat, safety glasses, boots) when visiting active construction sites