Controlling Analyst

Bayerische Motoren Werke Aktiengesellschaft; Richmond Hill; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A leading automotive company in Richmond Hill is seeking a Controlling Analyst to manage financial reporting and analysis. The role involves validating data and conducting variance analysis in a fast-paced environment. Ideal candidates will have a degree in Finance or Accounting and experience with Tableau and SQL scripting. This position offers competitive compensation and a hybrid work structure.

Benefits

Award-winning culture

Highly competitive compensation

First-rate health and wellness benefits

Employee vehicle/motorcycle programs

Fresh meals in onsite cafeteria

Qualifications

• 1-3 years of relevant finance experience, preferably as a financial analyst.
• Experience with Tableau and SQL scripting.
• Strong analytical and problem-solving skills.

Responsibilities

• Prepare and analyze financial reporting and forecasting data.
• Validate month-end reporting data and assist with P&L variance analysis.
• Develop and enhance reports that drive business decisions.

Skills

SQL scripting

Data visualization

Financial analysis

Critical thinking

Communication skills

Education

Degree in Finance or Accounting

MBA or Finance Designation (CPA, CMA, CFA)

Tools

Tableau

MS Excel

MS Access

Job description

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.