Job Overview
We are seeking a highly organized and analytical Project Coordinator – Financial & Systems to support project financial tracking, reporting, Smartsheet management, and business intelligence.
This is not a traditional field-based construction coordinator position. The role is primarily focused on the back-office financial and systems side of project management, including budgets, profit and loss, cost tracking, reporting, spreadsheets, Smartsheet development, and Power BI.
The ideal candidate is highly skilled in Excel and Smartsheet, understands project financials, and is comfortable building reports, dashboards, formulas, and automated workflows. This person should be able to take large amounts of project information and turn it into clear, accurate reporting for Project Managers and leadership.
Responsibilities
- Maintain and update project financial trackers, budgets, forecasts, and cost reports.
- Track project revenue, costs, gross profit, gross margin, and overall financial performance.
- Review project financials and identify variances, missing information, or potential issues.
- Assist Project Managers with understanding the financial position of their projects.
- Build, maintain, and improve advanced Excel spreadsheets and financial models.
- Manage and improve the company's Smartsheet environment.
- Create Smartsheet sheets, reports, dashboards, forms, formulas, and automated workflows.
- Develop automations for reminders, approvals, status updates, alerts, and reporting.
- Help standardize project tracking and reporting across the organization.
- Create management dashboards showing project status, revenue, cost, margin, schedule, and other key performance indicators.
- Support the development and maintenance of Power BI dashboards and reports.
- Assist with organizing, cleaning, and validating project and financial data used for reporting.
- Prepare weekly and monthly financial and operational reports for management.
- Maintain accurate project documentation and ensure project information remains current.
- Identify opportunities to reduce manual reporting and improve processes through automation.
- Coordinate with Project Managers, operations, billing, and accounting to ensure project data is accurate and complete.
Qualifications
- Strong experience with project financial tracking, accounting, financial analysis, or project controls.
- Advanced proficiency with Microsoft Excel, including formulas, lookups, pivot tables, conditional formatting, and financial modeling.
- Strong experience with Smartsheet, including dashboards, reports, formulas, forms, and automations.
- Experience managing or helping manage a Smartsheet environment is strongly preferred.
- Experience with Power BI or similar business intelligence/reporting tools.
- Strong understanding of profit and loss statements, budgeting, forecasting, cost tracking, and gross margin.
- Strong analytical and problem-solving skills.
- Excellent attention to detail and ability to work with large amounts of data.
- Ability to identify discrepancies and follow issues through to resolution.
- Strong organizational and communication skills.
- Ability to manage multiple projects and priorities in a fast-paced environment.
- Experience in construction, telecommunications, utilities, infrastructure, or another project-based industry is preferred.
Ideal Candidate
The ideal candidate is someone who is comfortable working with both financial information and technology. You should enjoy building spreadsheets, improving systems, creating dashboards, automating repetitive processes, and making financial information easier for management to understand.
We are looking for someone who can look at project data and quickly determine:
- Are we on budget?
- What is our current and projected margin?
- Are costs tracking correctly?
- Is the information in our systems accurate?
- What information does management need to see?
- Can a manual process be automated?
- Can Smartsheet or Power BI provide better visibility?
This position is best suited for someone who is financially analytical, technically capable, and highly proficient with Smartsheet and Excel.
Pay: $52,082.68 - $62,723.23 per year
People with a criminal record are encouraged to apply
Work Location: Hybrid remote in Dade City, FL 33526
