DATA ANALYST Full-time Job

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

BDC is a bank unlike any other. We are the only bank dedicated exclusively to the development of Canadian businesses. The only institution whose purpose is to promote the growth of the Canadian economy by focusing on the success of small and medium-sized businesses, with a human touch and a genuine presence. At BDC, were changing peoples and businesses lives for the better. Thats what makes us unique as a bank.