Controlling Analyst

BMW Group; Richmond Hill; Hybrid; CAD 60,000 - 80,000; Full time

Job summary

A leading automotive company in Richmond Hill, Ontario, is seeking a Controlling Analyst to prepare and analyze financial data. The ideal candidate will have a degree in Finance or Accounting and experience in SQL and Tableau. Responsibilities include validating month-end data, conducting financial analysis, and creating visualizations. This role offers competitive compensation and benefits, as well as a hybrid work structure, requiring in-office attendance three times a week.

Benefits

Award-winning culture

Competitive compensation

Health and wellness benefits

Employee vehicle programs

Onsite cafeteria with nutritious meals

Qualifications

• 1-3 years of relevant, professional finance experience.
• Experience in a coding language, particularly SQL.
• Experience with Tableau is required.

Responsibilities

• Responsible for month end validation of data and report distribution.
• Assist in P&L submission process and variance analysis.
• Analyze financial data and provide recommendations.

Skills

Analytical skills

SQL scripting

Tableau

Microsoft Excel

Problem solving

Education

Degree in Finance or Accounting

MBA or Finance Designation (CPA, CMA, CFA)

Tools

SQL SSMS

MS Access

SAS

Hyperion

Job description

URL of this page was copied to paste buffer

Controlling Analyst

KEEP BUSINESS MOVING.

USE NUMBERS. CREATE JOY. BMW FINANCIAL SERVICES.

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.

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.
• 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 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.
• 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.

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.