BI / Data Analyst Intern

BMW Group Financial Services Canada is offering an internship, within its Controlling team. By design, the Controlling team is structured to provide functions within Financial Services, while also ensuring alignment with other functions. The high priority projects are (1) supporting new business development (2) enhancing the retailer and customer experience by leveraging data and customer experience and (3) data optimization project which is designed to increase data awareness, improve data access and reduce barriers to entry for those without a traditional data background.

You will be working out of the BMW Financial Services’ corporate HQ which is based out of Richmond Hill, Ontario.
A team that is highly invested in your personal and professional development.
Position to lead and enhance an organization undergoing a data transformation and operational efficiency.
Exposure and involvement in a wide range of business topics – from Financial Reporting, Risk, Remarketing and Overall business performance.
Freedom to develop and shape new reporting, analysis and the execution of department objectives.

Gathering data from source tables using self or pre-developed SQL scripts.
Managing internal reporting databases and meeting monthly reporting deadlines.
Application of mathematical and analytical frameworks to help drive sound business decisions with ability to document approach and back-test results.
Creating data visualizations in Tableau and Excel.
Driving automation of reports and ensuring data accuracy.
Engaging with other teams to support Internal Control System (ICS) process map updates, internal control point validation and testing.
Supporting members of the Controlling team with ongoing tasks or ad-hoc projects, as required.

Current student or recent graduate majoring in Finance/Accounting, Business Administraton related majors preferred. Additional studies in Statistics, Data Science, Data Analytics is considered an asset.
Experience within Business Intelligence, Financial Services, Business Development or Accounting.
Proven ability to visualize and present data within Tableau/Powerpoint.
Strong knowledge in MS Office, particularly Excel, PowerPoint and Visio as a plus.
Experience in a coding language; in particular working level experience in SQL is preferred.
Scripting or using ‘drag and drop’ databasing programs (such as SQL SSMS, MS Access, SAS, Hyperion, etc) is nice to have.
Analytical, pragmatic and skilled in visualizing data (both structure and end product).
CPA/CFA candidates are preferred.

Flexible working models. **
World-class office space.
Fully stocked coffee/tea bar.

** To be eligible for this role, candidates are expected to work from our Head Office in Richmond Hill, Ontario three times in a week.
BMW Group Canada does not discriminate against applicants based on race, national or ethnic origin, colour, religion, sex, sexual orientation, gender identity, or disability or any other status or condition protected by applicable federal, provincial or territorial law.