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.