Senior Business Intelligence Data Engineer

Bayerische Motoren Werke Aktiengesellschaft; Richmond Hill; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading automotive company in Richmond Hill is looking for a Senior Business Intelligence Data Engineer. The ideal candidate will design robust data solutions and manage ETL processes while ensuring data integrity. Candidates should have at least 5 years of experience, strong SQL skills, and a background in financial services or the auto industry. Join us for a competitive salary and hybrid work environment.

Benefits

Award-winning culture

Competitive compensation

Health and wellness benefits

Subsidized onsite cafeteria

Employee vehicle program

Qualifications

• Minimum of 5 years professional experience in a related field.
• Strong experience with ETL of data from SQL Server.
• Expert in writing and analyzing SQL scripts.
• Financial Services or auto industry experience is strongly preferred.

Responsibilities

• Design and implement database solutions to store and retrieve data.
• Develop scalable and robust data pipelines for analytics.
• Identify opportunities to improve existing ETL processes.
• Create data products for Business Analysts to improve productivity.

Skills

SQL scripting

ETL processes

Data Governance

Dimensional modelling

Analytical skills

Communication skills

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

Select how often (in days) to receive an alert:

Senior Business Intelligence Data Engineer

SPREAD ENTHUSIASM. SHAPE THE FUTURE.

SHARE YOUR PASSION.

Knowing the destination isn't enough: you need to know how to get there. Build up your own networks, exploit new ideas, consistently take the initiative. Inspire other people with your enthusiasm. That's the only way to give ideas the power that allows them to become true innovations.

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

• 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

• 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 writing and analyzing SQL scripts
• Good understanding of dimensional modelling
• 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.
• 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.