Senior Business Intelligence Data Engineer

BMW M Motorsport / BMW Group; Richmond Hill; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading automotive company is seeking a Senior Data Engineer to build datasets and enhance data integrity for their Financial Services division. The ideal candidate will have at least 5 years of experience, particularly in ETL processes and SQL scripting within the financial or auto sectors. This role supports a hybrid work environment, requiring in-office presence three times a week.

Benefits

Award-winning culture

Flexible working models

Competitive compensation

Health and wellness benefits

Education reimbursement

Onsite cafeteria with fresh meals

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.

Responsibilities

• Design and implement effective database solutions.
• Develop scalable and robust data pipelines.
• Improve existing ETL processes for data integrity.

Skills

ETL processes

SQL scripting

Data governance

Dimensional modelling

Collaboration

Job description

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

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.

Learn more here.