The Controlling Analyst, reporting to the National Manager, Controlling, will be responsible for the preparation and analysis of data for financial reporting and forecast/planning. Responsibilities include the validation of month end reporting data; conducting analysis on actual performance vs budget/forecast; validating sales program proposals; supporting new business development; maintenance and creation of Tableau dashboards; and data optimization projects.
Specific Responsibilities include:
- Responsible for the month end validation of data and distribution of reports.
- Assist in the submission process of the P&L & B/S. Support with P&L variance analysis.
- Assist in verifying the Chart of Accounts are accurate and up-to-date.
- Gather and analyze data from source tables using self or pre-developed SQL scripts.
- Managing internal reporting databases.
- Monthly update of the management reports.
- Analyze financial data (esp. new business PCII) and provide findings/recommendations for improving sales programs simulation and back testing.
- Support business lines with required financial impact analysis.
- Provide ad hoc analysis as required.
- Development or enhancement of new reports that drive business decisions.
- Application of mathematical and/or statistical frameworks to help drive sound business decisions with ability to conduct robust analysis, simulation and forecast, validate/back-test results and fine tune finance/risk models.
- Driving automation of reports and ensuring data accuracy.
- Creating data visualizations in Tableau and Excel.
- Create and maintain financial models to assist in the annual forecast/budget cycles.
Qualifications:
- Degree in Finance or Accounting is preferred.
- MBA, Finance Designation (CPA, CMA, CFA) or near completion is an asset.
- 1-3 years of relevant, professional finance experience (financial analyst experience is preferred).
- Experience in a coding language; in particular working level experience in SQL scripting or using ‘drag and drop’ databasing programs (such as SQL SSMS, MS Access, SAS, Hyperion, etc).
- Experience with Tableau is required, experience with R or Python is an asset.
- Analytical, pragmatic and skilled in visualizing data (both structure and end product).
- Advanced PC skills (MS Word, Excel, Access & PowerPoint).
- Strong mathematical aptitude and proven analytical skills.
- Excellent problem solving and critical thinking skills.
- Excellent communication and interpersonal/teamwork skills.
- Strong self-learning capability.
- Excellent time management skills.
- Ability to work in a fast-paced and high-demand environment.
Benefits of working at BMW Group Canada include:
- An award-winning culture.
- Cutting edge innovation and creativity.
- Incredible BMW, MINI and Motorrad employee vehicle/motorcycle programs.
- Flexible working models. **
- Highly competitive compensation.
- Performance incentives programs.
- First-rate health and wellness benefits.
- Education reimbursement.
- World-class office space.
- Fresh & nutritious meals in our amazing fully staffed, and subsidized, onsite cafeteria.
- Fully stocked coffee/tea bar.
** We encourage interested candidates who may legally work in Canada to apply for the role. Our organization follows a hybrid work structure. To be eligible for this role, candidates are expected to work from our Head Office in Richmond Hill, Ontario three times in a week.
At the BMW Group, we place great importance on equal treatment and equal opportunities. Our recruiting decisions are based on the personality, experience, and skills of the applicants.
Learn more here.
