Business Analyst
Summary
Six-month remote contract Business Analyst role placed via staffing firm Visium Resources, split between business operations/financial management (OpEx/CapEx budgeting, forecasting, headcount tracking, executive reporting) and Smartsheet development/automation, supported by advanced Excel, Power BI, and light Python scripting.
Introduction
Visium Resources has been asked to identify qualified candidates for this Business Analyst position. This position is a contract hire opportunity which is expected to be Remote, for a contract duration of six months.
Summary
Our client 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 organization.
This position is approximately 50% Business Operations & Financial Management and 50% Smartsheet Development & Automation.
Job Description:
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.
Details:
Qualified candidates would have the following:
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:
Smartsheet Development & Administration Budget Planning & Forecast Management Advanced Excel & Reporting
Financial Analysis Headcount Planning Executive Dashboard Development Python Automation & Integrations Data Analytics
Power BI PMO Operations Support Project Coordination Process Improvement
________________________________________________________________________________________________
Visium Resources is an award-winning employment firm with a mission to match talented individuals with highly successful organizations. At Visium, our company's success is based on your success. When you work with us, you are never 'just a number'. You are our most important asset. Here, you will know us by name through our regular visits to client sites and even occasional luncheons. We will always be there when you need assistance and will always go the extra mile to ensure that you are as successful as possible. Whether you're looking for contract, contract-to-hire or permanent opportunities, we firmly believe there is no employment agency that will work harder for you than Visium.
Visium Resources is an equal opportunity employer and values diversity. All employment is decided based on qualifications, merit and business need.