Senior Business Intelligence Data Engineer

A GOOD INTERNSHIP IS NEVER HANDS OFF.

SHARE YOUR PASSION.

We believe in creating an environment where our interns really can learn by doing  and where they are given their own areas of responsibility right from the start of their time with us. That’s why our experts will treat you as part of the team from day one, encourage you to bring your own ideas to the table – and give you the opportunity to really show what you can do.

The Senior Data Engineer will be responsible for building datasets and data assets for BMW Financial Services.

Key responsibilties include:

• Design and implement effective database solutions and models to store and retrieve company data.
• Design and develop scalable and robust pipelines for data consumption by downstream applications in support of advanced analytics.
• Identify opportunities for improvement of existing ETL processes to enhance data integrity and accuracy.
• Actively participate in solution design and modeling to ensure data products are developed according to best practices, standards, and architectural principles.
• Work closely with the data architect, database administrators, and BI developers to redefine our approach to data pipelines and principles if reusability.
• Assess database implementation procedures to ensure they comply with internal and external regulations.
• Create data products for Business Analysts in various teams to improve productivity.
• Respond to ad-hoc data requests within the organization in a timely manner.
• Educate staff members through training and individual support.
• Offer support by responding to data problems in a timely manner.

Qualifications

• University Degree required; Computer Science or Data Science, Statistical Analysis, Math, IT
• Minimum of 5 years professional experience in a related field
• Strong experience working in teams to perform ETL of data from a SQL Server
• Financial Services or auto industry experience is strongly preferred
• Expert in data warehouse concepts
• Expert in writing and analyzing SQL scripts
• Good understanding of dimensional modelling
• Hands on experience in various ETL tools such as Informatica and SSIS
• Support the creation, review, and maintenance of framework, policy, and procedure documentation relating to Data Quality.
• Management of Data Governance content (Business Glossary, Data Dictionary) with Data Quality statistics and other relevant meta data
• Participate in project teams and collaborate as a team to deliver business outcomes
• Self-motivated, results driven and strong attention to detail
• Demonstrated strong organizational and analytical skills
• Well-developed communication, collaboration, interpersonal and leadership skills with an ability to build and maintain effective relationships

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.
• Flexible working models. **
• Highly competitive compensation.
• Performance incentives programs.
• First-rate health and wellness benefits.
• Education reimbursement. 
• 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.