linkedin
Business Analyst III
CAMP Systems International, Inc.
Montreal, CAN
Full Time
Senior
1 weeks ago
Power BIMicrosoft ExcelData AnalysisFinancial ModelingRevenue AssuranceBilling Validation
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
Power BIMicrosoft ExcelData Analysis
About the Role
CAMP Systems is seeking a Business Analyst III to support budgeting, forecasting, revenue assurance, billing validation, and sales compensation analysis. The role involves developing Power BI dashboards, performing detailed data analysis, and collaborating with Sales, Billing, Finance, and Operations teams.
Key Skills for This Role
Power BIMicrosoft ExcelData AnalysisFinancial ModelingRevenue AssuranceBilling Validation
Responsibilities
- Develop annual and quarterly budgets aligned with company goals
- Perform financial reporting on customer billings and accurately calculate and budget royalties
- Build financial forecasts based on historical trends, market conditions, and operational inputs
- Create scenario based financial models to predict best case, worst case, and most likely outcomes
- Perform detailed validation of billed, unbilled, and book of business data to identify discrepancies, gaps, and revenue leakage
- Analyze royalties, contingency payments, credits, and billing variances at line item level and summarize root causes for stakeholders
- Investigate billing anomalies, missing transactions, and timing mismatches, and recommend corrective actions
- Iterate on existing sales compensation models that align with strategic business goals
- Analyze sales compensation data to evaluate the effectiveness of current incentive plans and identify opportunities to optimize them
- Develop, publish, refresh, and validate Power BI dashboards and Excel models that provide visibility into billing, credits, and variances
- Continuously look for opportunities to automate manual reporting processes
- Support ad hoc investigations by performing customer account analysis and identifying ARR and the products to which customers have subscribed
Requirements
- Bachelor’s in Business, Finance, Analytics, Business Intelligence, Information Systems, or a related field
- 3 5 years of experience in business analytics, sales analytics, revenue assurance, billing validation, or related analytical roles
- Strong understanding of billing, revenue, reconciliation, and variance analysis principles
- Advanced Excel skills and experience building or validating BI reports and dashboards, preferably in Power BI
- High level of comfort working with large, complex datasets and performing detailed line item investigations across multiple systems
- Demonstrated ability to work independently and take ownership of deliverables from start to finish
- Exceptional attention to detail
- An automation mindset: actively looks for ways to replace manual, repetitive work with scalable solutions
- Strong communication and stakeholder management skills
- Experience with Acumatica, HubSpot, ERP/CRM platforms, and cross system data mapping or reconciliation is considered an asset
Full Job Posting
About CAMP Systems
- CAMP Systems is the trusted leader in aircraft compliance and health management, serving the global business aviation industry.
- We support over 20,000 aircraft and 33,000 engines on our platforms, with partnerships with more than 1,300 maintenance facilities and parts suppliers worldwide.
What You Will Experience
- We are seeking a Business Analyst III who thrives on ownership, brings relentless curiosity to data problems, and holds themselves to a high standard of accuracy and completeness.
- This individual will work directly with the Sales, Billing, Finance, and Operations teams to support budgeting and forecasting, revenue assurance, billing validation, sales compensation analysis, and business intelligence reporting.
Responsibilities
- Develop annual and quarterly budgets aligned with company goals.
- Perform financial reporting on customer billings and accurately calculate and budget royalties.
- Build financial forecasts based on historical trends, market conditions, and operational inputs.
- Create scenario based financial models to predict best case, worst case, and most likely outcomes.
- Work closely with department heads to ensure budget assumptions are realistic and data driven.
- Perform detailed validation of billed, unbilled, and book of business data to identify discrepancies, gaps, and revenue leakage.
- Analyze royalties, contingency payments, credits, and billing variances at line item level and summarize root causes for stakeholders.
- Investigate billing anomalies, missing transactions, and timing mismatches, and recommend corrective actions.
- Iterate on existing sales compensation models that align with strategic business goals.
- Analyze sales compensation data to evaluate the effectiveness of current incentive plans and identify opportunities to optimize them.
- Develop, publish, refresh, and validate Power BI dashboards and Excel models.
- Continuously look for opportunities to automate manual reporting processes.
You have
- Bachelor’s in Business, Finance, Analytics, Business Intelligence, Information Systems, or a related field.
- 3 5 years of experience in business analytics, sales analytics, revenue assurance, billing validation, or related analytical roles.
- Strong understanding of billing, revenue, reconciliation, and variance analysis principles.
- Advanced Excel skills and experience building or validating BI reports and dashboards, preferably in Power BI.
- High level of comfort working with large, complex datasets and performing detailed line item investigations across multiple systems.
- Demonstrated ability to work independently and take ownership of deliverables from start to finish.
- Exceptional attention to detail.
- An automation mindset: actively looks for ways to replace manual, repetitive work with scalable solutions.
- Strong communication and stakeholder management skills.
- Experience with Acumatica, HubSpot, ERP/CRM platforms, and cross system data mapping or reconciliation is considered an asset.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career