Business Analyst II

The Grid Automation CTO PMO is seeking a contractor to support business operations, financial planning, headcount management, executive reporting, and Smartsheet-based process automation. The role will partner with Finance, HR, Product, Engineering, and PMO leadership to improve reporting, data visibility, and decision-making through financial analysis, workforce planning, dashboards, and system integrations.

Responsibilities:

• Support annual operating plan (OP), forecasting, and budget planning activities
• Track and report 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 functional leaders to support planning and reporting activities
• Track headcount plans, hiring forecasts, vacancies, and contractor staffing
• Maintain workforce reporting and organizational metrics
• Reconcile staffing data across Finance, HR, and business systems
• Design and maintain Smartsheet solutions, dashboards, reports, forms, and workflows
• Automate reporting and business processes
• Develop executive and portfolio-level dashboards
• Build integrations between Smartsheet and Excel
• Support data migrations, synchronization, and governance activities
• Create advanced Excel reports, models, and dashboards
• Consolidate and analyze data from multiple systems
• Develop automated reporting processes and KPI dashboards
• Support Power BI reporting and visualization initiatives
• Develop lightweight Python-based automations and integrations
• Automate Smartsheet-to-Excel reporting processes
• Support data validation, quality checks, and dashboard refresh activities

Requirements:

• • Smartsheet Mastery: Advanced dashboarding, workflow automation, and cross-sheet integration
• Python/API Integration: Proficiency in using Python to bridge data between Smartsheet, Excel, and other enterprise systems
• Financial/HC Operations: Expertise in budgeting, headcount planning, and performing system reconciliations
• Project Governance: Ability to create portfolio rollups, program status reports, and executive-level KPI dashboards
• Must be flexible with working hours - eastern and central hours preferred
• There will be several morning calls
• 3+ years supporting business operations, PMO, financial planning, budgeting, or workforce planning
• Experience with: Budget management (OpEx & CapEx) Forecasting and variance analysis Contractor and headcount tracking Executive reporting
• Advanced Smartsheet experience, including dashboards, reports, forms, workflows, cross-sheet references, and complex formulas
• Advanced Excel skills, including Pivot Tables, Power Query, financial modeling, and dashboard development
• Strong analytical, communication, and stakeholder management skills
• Python scripting and automation experience
• Smartsheet API experience
• Microsoft Power BI and Power Automate experience
• PMO experience supporting engineering, product development, or R&D organizations
• Experience supporting CTO or executive leadership teams