Data Analyst Intern, Controlling (12 Months)
Top Benefits
About the role
A GOOD INTERNSHIP IS NEVER HANDS OFF. SHARE YOUR PASSION. Success requires teamwork. When experts share their knowledge and passion, ideas can develop quickly. This is what we call a good environment for innovation and that’s why we provide students and recent graduates an opportunity to not only listen, but also the opportunity to drive the business forward. We encourage you to bring your own ideas to the table – and give you the opportunity to really show what you can do.
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.
What to expect?
- You will be working out of the BMW Financial Services’ corporate HQ which is based out of Richmond Hill, Ontario.
- Opportunity and expectation to learn, collaborate and share new ideas and skills.
- 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.
- Fast-paced and high impact team environment.
- Providing meaningful input into critical business decisions.
- Freedom to develop and shape new reporting, analysis and the execution of department objectives.
Specific Responsibilities Include
- Gathering data from source tables using self or pre-developed SQL scripts.
- Managing internal reporting databases and meeting monthly reporting deadlines.
- Development or enhancement of new reports that drive business decisions.
- 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.
Qualifications
- 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).
- Willing to learn new skills, with no hesitation to dig into fine details.
- Excellent problem solving and critical thinking skills.
- Teamwork and communication skills.
- Open to both receiving and providing feedback.
- CPA/CFA candidates are preferred.
Benefits Of Working At BMW Group Canada Include
- An award-winning culture.
- Cutting edge innovation and creativity.
- Flexible working models. **
- 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.
BMW Group Canada is committed to attracting and retaining a diverse team of associates and creating an inclusive environment. 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.
About BMW Group Financial Services Canada
Overview
BMW Group Financial Services is an integral arm of the BMW Group and is represented in over 54 countries. With assets exceeding $140 billion, BMW Group Financial Services is one of the world's leading financial services entities.
BMW Group Financial Services Canada was established in 1994 and has grown to become one of the largest automotive finance entities in the country. Servicing over 150,000 Retail Customers, and our broad network of Retailers in Canada, BMW Group Financial Services Canada provides unparalleled service and professional auto financing advice.
Data Analyst Intern, Controlling (12 Months)
Top Benefits
About the role
A GOOD INTERNSHIP IS NEVER HANDS OFF. SHARE YOUR PASSION. Success requires teamwork. When experts share their knowledge and passion, ideas can develop quickly. This is what we call a good environment for innovation and that’s why we provide students and recent graduates an opportunity to not only listen, but also the opportunity to drive the business forward. We encourage you to bring your own ideas to the table – and give you the opportunity to really show what you can do.
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.
What to expect?
- You will be working out of the BMW Financial Services’ corporate HQ which is based out of Richmond Hill, Ontario.
- Opportunity and expectation to learn, collaborate and share new ideas and skills.
- 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.
- Fast-paced and high impact team environment.
- Providing meaningful input into critical business decisions.
- Freedom to develop and shape new reporting, analysis and the execution of department objectives.
Specific Responsibilities Include
- Gathering data from source tables using self or pre-developed SQL scripts.
- Managing internal reporting databases and meeting monthly reporting deadlines.
- Development or enhancement of new reports that drive business decisions.
- 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.
Qualifications
- 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).
- Willing to learn new skills, with no hesitation to dig into fine details.
- Excellent problem solving and critical thinking skills.
- Teamwork and communication skills.
- Open to both receiving and providing feedback.
- CPA/CFA candidates are preferred.
Benefits Of Working At BMW Group Canada Include
- An award-winning culture.
- Cutting edge innovation and creativity.
- Flexible working models. **
- 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.
BMW Group Canada is committed to attracting and retaining a diverse team of associates and creating an inclusive environment. 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.
About BMW Group Financial Services Canada
Overview
BMW Group Financial Services is an integral arm of the BMW Group and is represented in over 54 countries. With assets exceeding $140 billion, BMW Group Financial Services is one of the world's leading financial services entities.
BMW Group Financial Services Canada was established in 1994 and has grown to become one of the largest automotive finance entities in the country. Servicing over 150,000 Retail Customers, and our broad network of Retailers in Canada, BMW Group Financial Services Canada provides unparalleled service and professional auto financing advice.