More jobs:
Business Analyst II
Job in
Aurora, Kane County, Illinois, 60505, USA
Listed on 2026-09-30
Listing for:
Lancesoft
Full Time
position Listed on 2026-09-30
Job specializations:
-
Business
Business Intelligence, Data Analyst
Job Description & How to Apply Below
Business Operations & Financial Analyst (Smartsheet Focus) Contract Position | Grid Automation CTO PMO Position Summary
The Grid Automation CTO PMO is seeking a contractor to support PMO operations, financial planning, headcount management, executive reporting, and Smartsheet-based business process automation.
This role will partner with PMO leadership, Finance, HR, Product, and Engineering teams to improve visibility, reporting efficiency, and data-driven decision making across the CTO organization.
This position is approximately 50% Business Operations & Financial Management and 50% Smartsheet Development & Automation.
Technical Skills- Must Have
- 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.
- Smartsheet Mastery:
- Nice To Have
- High Financial Analysis
- Headcount Planning
- Executive Dashboard Development
- Python Automation & Integrations
- Data Analytics
- Medium Power BI
- PMO Operations Support
- Project Coordination
- Process Improvement
Must be flexible with working hours - eastern and central hours preferred. There will be several morning calls.
Key Responsibilities- Financial Planning & Operations Support annual operating plan (OP), forecasting, and budget planning activities.
- Track and report OpEx, Cap Ex, 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.
- Headcount & Workforce Planning
- Track headcount plans, hiring forecasts, vacancies, and contractor staffing.
- Maintain workforce reporting and organizational metrics.
- Reconcile staffing data across Finance, HR, and business systems.
- Smartsheet Development & Automation
- 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.
- Data Analytics & Reporting
- 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.
- Technical Automation
- Develop lightweight Python-based automations and integrations.
- Automate Smartsheet-to-Excel reporting processes.
- Support data validation, quality checks, and dashboard refresh activities.
- 3+ years supporting business operations, PMO, financial planning, budgeting, or workforce planning.
- Experience with:
- Budget management (OpEx & Cap Ex)
- 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.
- Critical Smartsheet Development & Administration
- Budget Planning & Forecast Management
- Advanced Excel & Reporting
- High Financial Analysis
- Headcount Planning
- Executive Dashboard Development
- Python Automation & Integrations
- Data Analytics
- Medium Power BI
- PMO Operations Support
- Project Coordination
- Process Improvement
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×