Enter Job Description...
This job is with Encode Inc, a fully owned subsidiary of LanceSoft.
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.
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.
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.
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.