Revenue Analyst
ABOUT COOLIT SYSTEMS INC.
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.
Position Summary
The Revenue Analytics 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.
Key Responsibilities
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, Supply Chain, Quality, Customer Service teams to support forecasting, reporting, and business analysis.
- Act as a partner for Business Development by providing timely reporting, data insights, and performance visibility.
- Collaborate with stakeholders to identify reporting requirements and improve visibility into commercial and operational performance.
Continuous Improvement
- Identify opportunities to automate recurring reporting and analytical processes.
- Improve forecasting tools, reporting templates, and dashboard functionality.
- Participate in ERP, CRM, and reporting improvement projects.
- Recommend process enhancements that improve reporting accuracy and efficiency.
WHO YOU ARE
Basic Qualifications
- Bachelor's degree in Finance, Accounting, Economics, Business, Mathematics, Statistics, Engineering, Data Analytics, or a related field.
Experience
- 2–3 years of experience in Finance, Business Analytics, FP&A, Revenue Analytics, Sales Operations, Data Analytics, or a related analytical role.
- Recent graduates with strong analytical skills are encouraged to apply.
Skills
- Strong Excel capability, including advanced formulas, pivot tables, and structured analysis.
- Exposure to BI/reporting tools such as Power BI, Tableau, Looker, or equivalent.
- Strong analytical judgment and the ability to connect numbers to business decisions.
- Clear written communication and strong executive-summary skills.
- High attention to detail, accuracy, and follow-through.
- Ability to work under deadline pressure in a fast-paced growth environment.
- Comfort partnering with leaders and asking probing questions when data does not make sense.
WHY COOLIT?
We strive to be an employer of choice and, as such, we believe in rewarding our employees with career and development opportunities that maintain and strengthen our culture while aligning to our vision and values.
Benefits
- Vacation and flex days, and paid company-wide shutdown during the holiday season.
- Comprehensive benefits including Dental, Drugs, Optical, Paramedical, and Health Spending. These costs are covered by CoolIT and are enacted from your first day.
- Dress for your day - in a casual yet professional environment.
- Retention rewards like The Big Coffee Break that reward tenure with additional vacation time and a monetary bonus.
- Company-funded RRSP contributions to support your long-term financial goals.
We thank every candidate in advance; however, only those selected for an interview will be contacted.
Successful candidates for this position will be required to undergo background checks including criminal records check and education verification.