Data Analyst

We are banking at another level.

Choosing BDC as your employer means working in a healthy, inclusive, and skilled workplace that puts forward the best conditions to bring together unique teams where employees are empowered to act. It also means being at the centre of ambitious economic and financial projects to see further and to do things differently, to fuel the success of Canadian entrepreneurs.

Choosing BDC as your employer also means:

• Flexible and competitive benefits, including an Employee Savings and Investment Plan where BDC matches part of your voluntary contributions, a Defined Benefit Pension Plan, a $750 wellness and health care spending account, to name a few   

• In addition to paid vacation each year, five personal days, sick days as necessary, and our offices are closed from December 25 to January 1

• A hybrid work model that truly balances work and personal life

• Opportunities for learning, training and development, and much more... 

POSITION OVERVIEW

We are looking for a strong data analyst to join our Client Analytics team within the Marketing and Communications (MarCom) department. The person will work with the other analysts and together will ensure the continuous evolution and maintenance of marketing datasets. They will have to manipulate a variety of data coming from Google Analytics, the CRM, our marketing automation tools and other and act as the primary liaison between the Marketing and IT departments to document, prioritize and coordinate the datasets change requests.

The ideal candidate should be proficient in SQL and Power BI to be able to support the analysts by creating or updating SQL codes and Power BI datasets. They will have experience with Databricks, SQL, and data modeling.

They should be comfortable working in an evolving environment where curiosity and flexibility are key to adapt to new tools and processes.

CHALLENGES TO BE MET

• Own and maintain various Marketing datasets, ensuring their continuous evolution.

• Develop, design, and maintain complex and large Power BI datasets and dashboards.

• Improve Power BI datasets performance.

• Extract, transform, and load (ETL) data from various sources into Power BI.

• Write codes in DAX and in Power Query.

• Develop, maintain, and optimize SQL codes including views and stored procedures.

• Communicate effectively with reporting analysts to understand their requirements and translate them into actionable data solutions.

• Provide automation support to analytical teams around data-centric needs.

• Ensure data quality and accuracy through monitoring and validation.

• Build queries and workflows in Databricks and SSMS to build datasets for Marketing & Communications (Marcom) reports.

• Develop and review code used by all the data analysts in the department.

• Support team of data analysts with data knowledge or with debugging

• Design and implement data models to support business requirements.

• Troubleshoot data issues and perform root cause analysis.

• Design and document data solutions and models in collaboration with BI, data specialists, architects, data modelers, data scientists, and project/product team.

• Be the Power BI and Databricks subject matter expert.

• Provide training and support on Power BI and Databricks for Marketing analysts.

• Stay updated with the latest Power BI and Databricks features and best practices.

• Be the bridge between Marketing and IT, enable collaboration and data democratization.

WHAT WE ARE LOOKING FOR

• Bachelor’s degree in Computer Science, Information Technology, Marketing, or a related field.

• Minimum 3 years of experience in creating, maintaining, and understanding SQL codes, 3 years of experience in maintaining and evolving Power BI datasets (including DAX and Power Query) and 1 years of experience in Databricks

• Proven experience in effectively communicating with reporting analysts and coordinating between marketing and IT departments.

• Excellent problem-solving skills and attention to details.

• Strong organizational and project management skills with a minimum of 2 years of experience in a similar role.

• Experience with multidimensional data modeling.

• Experience in managing Marketing data an asset (such as Google analytics, Marketing automation systems (SAP, Eloqua…)

• Experience with code migrations across different environments an asset.

• Experience using GIT versioning is an asset.

• Good understanding of SQL optimization techniques and of multidimensional database schemas.

• SQL Server Management Studio (SSMS), advance knowledge of Power BI and Google Analytics

• Experienced in Databricks.

• Ability to review own work and minimize errors. Strong attention to detail.

• Curiosity and ability to acquire technical skills very quickly. Fast learner. Strong problem-solving skills.

• Strong interpersonal, teamwork skills. Strong organizational skills, ability to estimate and deliver on expectations and communicate hurdles.

• Demonstrated ability to work both independently and as part of a team in an autonomous way.

• Bilingual french and english

#INDHP 

Proudly one of Canada’s Top 100 Employers and one of Canada’s Best Diversity Employers, we are committed to fostering a diverse, equitable, inclusive and accessible environment where all employees can thrive and feel empowered to bring their whole selves to work. If you require an accommodation to complete your application, please do not hesitate to contact us at accessibility@bdc.ca.

While we appreciate all applications, we advise that only the candidates selected to participate in the recruitment process will be contacted.