Business Analyst II
Job Location:
Chicago, IL - USA
Monthly Salary:
Posted:
Application Deadline:
Vacancies:
Job Summary
Business Analyst IIBusiness Operations & Financial Analyst (Smartsheet Focus)
6 Months Contract
Remote
Must be flexible with working hours - eastern and central hours preferred.
There will be several morning calls.
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.
Key Responsibilities
Financial Planning & Operations 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. 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. Required Qualifications 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. Preferred Qualifications 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. Desired 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.
Nice To Have
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
Required Skills:
PIVOT TABLESFINANCIAL PLANNINGPYTHONPYTHON SCRIPTINGAUTOMATIONPOWER QUERYFINANCIAL MODELINGMICROSOFT POWER BI
