Revenue Operations Analyst

Revenue Operations Analyst ABOUT COOLIT, AN ECOLAB COMPANY Founded in Calgary, Alberta in 2001, CoolIT Systems is the leading Direct Liquid Cooling technology provider for data centers, supercomputers, and desktop computers. We design and manufacture solutions used by the largest tech companies globally.  Recognized as one of The Americas' Fastest Growing Companies 2023 by the Financial Times and honored with the Deloitte Fast 50 Clean Technology award in 2022, as well as Deloitte Fast 500 distinctions in both 2021 and 2022, CoolIT's rapid growth is capturing global attention.  As demand for generative AI, high performance computing, and cloud solutions rapidly expands, there has never been a more exciting time to join our team.

Summary The Revenue Operations Analyst supports the Revenue Manager by maintaining forecasting models, validating data, updating material cost inputs, preparing business reporting, and performing detailed variance analysis. This role is responsible for identifying what changed within the business and quantifying the financial impact of those changes. The analyst will work across Finance, Business Development, Operations, Supply Chain, and Customer Service to ensure accurate and timely reporting while maintaining high standards of data integrity. The successful candidate will possess strong analytical skills, advanced Excel capabilities, and a passion for transforming complex data into actionable business insights. This role provides a strong foundation for career growth in Finance, Revenue Management, FP&A, or Business Analytics.

Revenue Forecast Support Maintain and update weekly, monthly, and quarterly revenue forecasting models. Validate forecast inputs and ensure data accuracy and completeness. Update bookings, backlog, shipments, and revenue assumptions within forecasting model. Support the weekly reforecast process and monthly forecast reviews. Track forecast changes and maintain forecast version control. Assist in preparing forecast reporting packages for management review. Material Cost Analysis & Forecast Support Maintain and update material cost inputs within the revenue forecasting model. Collect, validate, and reconcile material cost data from ERP and procurement systems. Monitor material pricing trends and identify significant cost movements. Analyze material cost variances versus forecast, budget, and prior periods. Quantify the impact of material cost changes on gross margin and profitability. Support the Revenue Manager in maintaining accurate material cost assumptions used in forecasting. Investigate unusual material cost fluctuations and escalate exceptions for review. Revenue & Margin Variance Analysis Perform detailed variance analysis against forecast, budget, prior month, and prior year results. Quantify revenue and product margin changes by: Volume Price Product mix Customer Region Material cost Identify key drivers behind changes in business performance. Summarize findings and prepare analysis for management review. Support month-end and quarter-end performance review processes. Data Management & Data Quality Surface data quality issues, process gaps, and reporting inefficiencies.  Maintain reporting datasets and ensure consistency across business reports. Identify and resolve data discrepancies and reporting issues. Support continuous improvement of data quality across systems and processes. Document reporting logic, calculations, and data sources. Reporting & Dashboard Development Develop and maintain recurring reports, scorecards, and performance dashboards. Produce weekly and monthly pipeline health reports for leadership. Build reports on funnel conversion, average deal size, cycle time, win rates, and productivity. Support MBRs, QBRs, annual planning, and ad hoc commercial analysis. Improve reporting efficiency through automation and standardization. Cross-Functional Partnership Partner closely with Business Development, Operations,