PMO Financial Analyst (Smartsheet & Automation)

Lancesoft; Illinois; Hybrid; USD 90,000 - 120,000; Full time

Job summary

Grid Automation CTO PMO is seeking a contract Business Operations & Financial Analyst to support PMO operations, financial planning, headcount management, and Smartsheet-based automation. The role partners with Finance, HR, Product, and Engineering to improve visibility, reporting efficiency, and data-driven decisions across the CTO organization.

The position is split 50/50 between Business Operations & Financial Management and Smartsheet Development & Automation, with flexibility for morning

Qualifications

• 3+ years supporting business operations, PMO, financial planning, budgeting, or workforce planning.
• Experience with OpEx & CapEx budgeting, forecasting, and variance analysis.
• Contractor and headcount tracking with executive reporting.
• Advanced Smartsheet experience: dashboards, reports, forms, workflows, cross-sheet references, and complex formulas.
• Advanced Excel skills: Pivot Tables, Power Query, financial modeling, and dashboard development.
• Strong analytical, communication, and stakeholder management skills.

Responsibilities

• Financial Planning & Operations Support for annual operating plan, forecasting, and budgeting.
• Track OpEx, CapEx, contractor spend, labor costs, and investments.
• Maintain budget forecasts, spending reports, and variance analysis.
• Develop executive dashboards, KPIs, and leadership reporting packages.
• Partner with Finance and leaders to support planning and reporting.
• Headcount & Workforce Planning: track plans, forecasts, vacancies, contractor staffing.
• Smartsheet Development & Automation: design/maintain dashboards, reports, forms, workflows.
• Data Analytics & Reporting: create Excel reports and dashboards; support Power BI.
• Technical Automation: develop Python-based automations and Smartsheet integrations.

Skills

Financial planning

Budgeting

Headcount planning

Executive reporting

Forecasting

Contractor tracking

Stakeholder management

Analytical thinking

Tools

Smartsheet

Python

Excel

Power BI

Job description

Grid Automation CTO PMO is seeking a contract Business Operations & Financial Analyst to support PMO operations, financial planning, headcount management, and Smartsheet-based automation. The role partners with Finance, HR, Product, and Engineering to improve visibility, reporting efficiency, and data-driven decisions across the CTO organization.

The position is split 50/50 between Business Operations & Financial Management and Smartsheet Development & Automation, with flexibility for morning