Controlling Analyst

Having an eye for detail and being particular about accurate numbers is essential to the smooth running of our business. We are looking for individuals to join our team of precise-minded people dedicated to adding value to our customers and to our business. So if you’d thrive in a team that values high work standards and learning opportunities, where every team member is recognised and valued, join us in driving the future of operations in business mobility. Responsibilities 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. 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. 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. Ability to work in a fast-paced and high-demand environment. Benefits An award-winning culture. Cutting edge innovation and creativity. Incredible BMW, MINI and Motorrad employee vehicle/motorcycle programs. Highly competitive compensation. First-rate health and wellness benefits. 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. A t 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. #J-18808-Ljbffr