Consultant, Data & Analytics - New Grad (May 2026)

BDO Canada · Toronto, ON

On site
Full-time
CA$76,000 / year
Toronto, ON

This role may have been filled. Drop your résumé and we'll check if it's still open — or find you similar roles.

Job highlights

Engage with clients to implement analytics solutions.
Design and develop industry-specific data models.
Enhance data models and improve query efficiency.
Build data capture and transformation functionality.
Develop and maintain data architectures and systems.

About the role

Data & Analytics Consultant - New Grad

BDO is a firm built on a foundation of positive relationships with our people and our clients. Each day, our professionals provide exceptional service, helping clients with advice and insight they can trust. In turn, we offer an award-winning environment that fosters a people-first culture with a high priority on your personal and professional growth.

Your Opportunity

BDO Digital is looking for a Data Analytics/ Data Engineer New Grad to join our growing client-facing team on a full-time permanent basis. This is a net new role and responsibilities will include:

Play an integral role in our delivery practice as we execute on enterprise level client engagements through our various industry specializations.
Engage directly with clients and drive the implementation and successful end user experience of analytics solutions; execute on engagements and collaborate with the client and delivery team to ensure that any applicable milestones and deliverables are met on time and on budget.
Design and develop industry-specific data models for client projects in industries such as Natural Resources, Finance, Manufacturing and Distribution, and Retail.
Work with other engineers to enhance data models and improve data query efficiency; create complex data queries to facilitate ad hoc and exploratory analytics.
Build real-time data capture and transformation functionality across all products and build out technology stack for Business Intelligence and Data Warehouse.
Clean data: review for data inconsistencies and identify opportunities to improve data collection process; Wrangle/Munge data: transform or map data from one raw data form into another format with the intent of making it more appropriate and valuable for analytics.
Develop, construct, test and maintain architectures such as databases and large-scale data processing systems; design, construct, install, test and maintain highly scalable data management systems.
Employ a variety of languages and tools (e.g. scripting languages) to marry systems together.
Build or recommend data visualization tools and business intelligence tools such as interactive dashboards and automated reports, to enable leaders to make swift, fact-based decisions.
Remain up to date of development technologies, both current and future in order to deliver state-of-the-art Analytics solutions for our customers.

How do we define success for your role?

You demonstrate BDO's core values through all aspect of your work: Integrity, Respect and Collaboration.
You understand your client’s industry, challenges, and opportunities; clients describe you as positive, professional, and delivering high quality work.
You identify, recommend, and are focused on effective service delivery to your clients.
You share in an inclusive and engaging work environment that develops, retains & attracts talent.
You actively participate in the adoption of digital tools and strategies to drive an innovative workplace.
You grow your expertise through learning and professional development.

Your Experience And Education

Post-secondary education in engineering or computer science or equivalent work experience.
Good experience working with Azure Databricks, Azure Data Factory and Azure Data Lake.
Programming experience in Python.
Strong attention to the quality of work delivered (attention to detail).
Able to adapt quickly to changing client requirements.

The following are considered an asset:

Experience using the Apache Hadoop ecosystem (Spark, Data Lake, Hive, HDFS, Impala) to tackle "big data" problems.
Knowledge of ETL, ELT, Lambda and Kappa data architectures.
Experience with the Microsoft SQL Server Analytics stack including: Core SQL, SSIS, SSRS, SSAS.
Experience working with SQL and NoSQL databases.
Knowledge of Continuous Integration and Source Control systems (e.g. Gradle, Maven, Bamboo, TeamCity, Git).
Data Visualization experience in Power BI, Tableau, or similar.
Exposure to data science, machine learning or statistics.
Some experience using Docker.

The expected range of compensation for this role is $60,000 to $92,000.

Why BDO?

Our people-first approach to talent has earned us a spot among Canada’s Top 100 Employers for 2026. This recognition is a milestone we’re thrilled to add to our collection of awards for both experienced and student talent experiences.

Our firm is committed to providing an environment where you can be successful in the following ways:

We enable you to engage with how we change and evolve, being a key contributor to the success and growth of BDO in Canada.
We help you become a better professional within our services, industries, and markets with extensive opportunities for learning and development.
We support your achievement of personal goals outside of the office and making an impact on your community.

Giving back adds up: Where company meets community. BDO is actively involved in our communities by supporting local charity initiatives. We support staff with local and national events where you will be given the opportunity to contribute to your community.

Total rewards that matter: We pay for performance with competitive total cash compensation that recognizes and rewards your contribution. We provide flexible benefits from day one, and a market leading personal time off policy. We are committed to supporting your overall wellness beyond working hours and provide reimbursement for wellness initiatives that fit your lifestyle.

Everyone counts: We believe every employee should have the opportunity to participate and succeed. Through leadership by our Diversity, Equity and Inclusion Leader, we are committed to a workplace culture of respect, inclusion, and diversity. We recognize and celebrate the valuable differences among each of us, including race, religious beliefs, physical or mental disabilities, age, place of origin, marital status, family status, gender or gender identity and sexual orientation. If you require accommodation to complete the application process, please contact us.

Flexibility: All BDO personnel are expected to spend some of their time working in the office, at the client site, and virtually unless accommodations or alternative work arrangements are in place.

Our model is a blended approach designed to support the flexible needs of our people, the firm and our clients. It’s about creating work experiences that meet everyone’s needs and providing flexibility to adjust when, where and how we work to meet the expectations of our role.

Code of Conduct: Our Code of Conduct sets clear standards for how we conduct business. It reflects our shared values and commitments and includes guiding principles to help us make ethical decisions and maintain trust with each other, our clients, and the public.

BDO Canada may use artificial intelligence enabled tools to support certain aspects of the recruitment process. While these tools assist our teams, our use of AI does not replace human decision making, and all employment-related outcomes are made by BDO Canada personnel.

More information on BDO Canada’s Privacy Policy can be found here: Privacy Policy | BDO Canada

Key skills/competency

Data Analysis
Data Engineering
Python
Azure Databricks
Azure Data Factory
Azure Data Lake
SQL
Data Modeling
ETL/ELT
Business Intelligence

Skills & topics

Data Analytics Consultant
Data Engineer
New Grad
BDO Canada
Python
Azure Databricks
Azure Data Factory
Azure Data Lake
SQL
Data Modeling
ETL
BI
Business Intelligence
Consulting
Technology
Entry Level

How to get hired

Tailor your resume: Highlight experience with Python, Azure Databricks, Azure Data Factory, and Azure Data Lake, and showcase any Big Data or BI tool experience.
Craft a compelling cover letter: Emphasize your client-facing skills, problem-solving abilities, and eagerness to learn and grow within BDO's people-first culture.
Prepare for technical questions: Be ready to discuss data modeling, ETL/ELT processes, SQL queries, and your approach to data cleaning and transformation.
Demonstrate cultural fit: Show how your values align with BDO's Integrity, Respect, and Collaboration by sharing examples of teamwork and client focus.
Ask insightful questions: Inquire about team structure, client engagement examples, and professional development opportunities to show your engagement and interest.

Technical preparation

Master Python for data manipulation and scripting.,Practice Azure Databricks, Data Factory, and Data Lake.,Build complex SQL queries for data analysis.,Understand ETL/ELT processes and data modeling.

Behavioral questions

Describe a time you adapted to client needs.,Share an example of prioritizing work quality.,How do you demonstrate collaboration and respect?,Discuss your approach to continuous learning.

Frequently asked questions

What are the key technical skills required for the Data & Analytics Consultant - New Grad role at BDO Canada?: For the Data & Analytics Consultant - New Grad position at BDO Canada, essential technical skills include programming experience in Python, and experience with Azure Databricks, Azure Data Factory, and Azure Data Lake. Strong attention to detail and the ability to adapt to changing client requirements are also crucial. Familiarity with SQL and concepts like ETL/ELT and data visualization tools are highly beneficial.
What kind of client work can I expect as a Data & Analytics Consultant at BDO Canada?: As a Data & Analytics Consultant at BDO Canada, you will play an integral role in client-facing engagements. This involves directly engaging with clients to drive the implementation of analytics solutions, designing industry-specific data models for sectors like Natural Resources and Finance, and collaborating with delivery teams to meet project milestones and deliverables.
What is BDO Canada's approach to work-life balance and flexibility for new graduates?: BDO Canada emphasizes a people-first culture and offers a flexible work model. While personnel are expected to work from the office, client sites, and virtually, this blended approach is designed to support the needs of employees, the firm, and clients, allowing for adjustments in when, where, and how work is done.
How does BDO Canada support professional growth for new graduates in data analytics?: BDO Canada is committed to fostering professional growth through extensive learning and development opportunities. They aim to help new graduates become better professionals by providing exposure to various services, industries, and markets, encouraging expertise development, and supporting the achievement of personal and career goals.
What are BDO Canada's core values, and how are they reflected in the Data & Analytics Consultant role?: BDO Canada's core values are Integrity, Respect, and Collaboration. For the Data & Analytics Consultant role, success is defined by demonstrating these values in all work aspects, understanding client needs, delivering high-quality, professional service, and contributing to an inclusive and engaging work environment.
What is the salary range for the Data & Analytics Consultant - New Grad position at BDO Canada?: The expected compensation range for the Data & Analytics Consultant - New Grad role at BDO Canada is between $60,000 and $92,000 annually.
Are there opportunities to work with Big Data technologies at BDO Canada?: Yes, experience with the Apache Hadoop ecosystem, including Spark, Data Lake, Hive, HDFS, and Impala, is considered an asset for the Data & Analytics Consultant role. This indicates BDO Canada works on 'big data' problems and values candidates with relevant experience in this area.
What is the application process like at BDO Canada for new graduate roles?: To apply for the Data & Analytics Consultant - New Grad role at BDO Canada, you should click 'Apply now' and submit your up-to-date resume. BDO Canada may use AI-enabled tools to support aspects of the recruitment process, but all employment outcomes are determined by BDO Canada personnel.

About the role

Data & Analytics Consultant - New Grad

Your Opportunity

BDO Digital is looking for a Data Analytics/ Data Engineer New Grad to join our growing client-facing team on a full-time permanent basis. This is a net new role and responsibilities will include:

Play an integral role in our delivery practice as we execute on enterprise level client engagements through our various industry specializations.
Engage directly with clients and drive the implementation and successful end user experience of analytics solutions; execute on engagements and collaborate with the client and delivery team to ensure that any applicable milestones and deliverables are met on time and on budget.
Design and develop industry-specific data models for client projects in industries such as Natural Resources, Finance, Manufacturing and Distribution, and Retail.
Work with other engineers to enhance data models and improve data query efficiency; create complex data queries to facilitate ad hoc and exploratory analytics.
Build real-time data capture and transformation functionality across all products and build out technology stack for Business Intelligence and Data Warehouse.
Clean data: review for data inconsistencies and identify opportunities to improve data collection process; Wrangle/Munge data: transform or map data from one raw data form into another format with the intent of making it more appropriate and valuable for analytics.
Develop, construct, test and maintain architectures such as databases and large-scale data processing systems; design, construct, install, test and maintain highly scalable data management systems.
Employ a variety of languages and tools (e.g. scripting languages) to marry systems together.
Build or recommend data visualization tools and business intelligence tools such as interactive dashboards and automated reports, to enable leaders to make swift, fact-based decisions.
Remain up to date of development technologies, both current and future in order to deliver state-of-the-art Analytics solutions for our customers.

How do we define success for your role?

You demonstrate BDO's core values through all aspect of your work: Integrity, Respect and Collaboration.
You understand your client’s industry, challenges, and opportunities; clients describe you as positive, professional, and delivering high quality work.
You identify, recommend, and are focused on effective service delivery to your clients.
You share in an inclusive and engaging work environment that develops, retains & attracts talent.
You actively participate in the adoption of digital tools and strategies to drive an innovative workplace.
You grow your expertise through learning and professional development.

Your Experience And Education

Post-secondary education in engineering or computer science or equivalent work experience.
Good experience working with Azure Databricks, Azure Data Factory and Azure Data Lake.
Programming experience in Python.
Strong attention to the quality of work delivered (attention to detail).
Able to adapt quickly to changing client requirements.

The following are considered an asset:

Experience using the Apache Hadoop ecosystem (Spark, Data Lake, Hive, HDFS, Impala) to tackle "big data" problems.
Knowledge of ETL, ELT, Lambda and Kappa data architectures.
Experience with the Microsoft SQL Server Analytics stack including: Core SQL, SSIS, SSRS, SSAS.
Experience working with SQL and NoSQL databases.
Knowledge of Continuous Integration and Source Control systems (e.g. Gradle, Maven, Bamboo, TeamCity, Git).
Data Visualization experience in Power BI, Tableau, or similar.
Exposure to data science, machine learning or statistics.
Some experience using Docker.

The expected range of compensation for this role is $60,000 to $92,000.

Why BDO?

Our firm is committed to providing an environment where you can be successful in the following ways:

We enable you to engage with how we change and evolve, being a key contributor to the success and growth of BDO in Canada.
We help you become a better professional within our services, industries, and markets with extensive opportunities for learning and development.
We support your achievement of personal goals outside of the office and making an impact on your community.

Flexibility: All BDO personnel are expected to spend some of their time working in the office, at the client site, and virtually unless accommodations or alternative work arrangements are in place.

More information on BDO Canada’s Privacy Policy can be found here: Privacy Policy | BDO Canada

Key skills/competency

Data Analysis
Data Engineering
Python
Azure Databricks
Azure Data Factory
Azure Data Lake
SQL
Data Modeling
ETL/ELT
Business Intelligence

How to get hired

Tailor your resume: Highlight experience with Python, Azure Databricks, Azure Data Factory, and Azure Data Lake, and showcase any Big Data or BI tool experience.
Craft a compelling cover letter: Emphasize your client-facing skills, problem-solving abilities, and eagerness to learn and grow within BDO's people-first culture.
Prepare for technical questions: Be ready to discuss data modeling, ETL/ELT processes, SQL queries, and your approach to data cleaning and transformation.
Demonstrate cultural fit: Show how your values align with BDO's Integrity, Respect, and Collaboration by sharing examples of teamwork and client focus.
Ask insightful questions: Inquire about team structure, client engagement examples, and professional development opportunities to show your engagement and interest.

Frequently asked questions

What are the key technical skills required for the Data & Analytics Consultant - New Grad role at BDO Canada?

For the Data & Analytics Consultant - New Grad position at BDO Canada, essential technical skills include programming experience in Python, and experience with Azure Databricks, Azure Data Factory, and Azure Data Lake. Strong attention to detail and the ability to adapt to changing client requirements are also crucial. Familiarity with SQL and concepts like ETL/ELT and data visualization tools are highly beneficial.

What kind of client work can I expect as a Data & Analytics Consultant at BDO Canada?

As a Data & Analytics Consultant at BDO Canada, you will play an integral role in client-facing engagements. This involves directly engaging with clients to drive the implementation of analytics solutions, designing industry-specific data models for sectors like Natural Resources and Finance, and collaborating with delivery teams to meet project milestones and deliverables.

What is BDO Canada's approach to work-life balance and flexibility for new graduates?

BDO Canada emphasizes a people-first culture and offers a flexible work model. While personnel are expected to work from the office, client sites, and virtually, this blended approach is designed to support the needs of employees, the firm, and clients, allowing for adjustments in when, where, and how work is done.

How does BDO Canada support professional growth for new graduates in data analytics?

BDO Canada is committed to fostering professional growth through extensive learning and development opportunities. They aim to help new graduates become better professionals by providing exposure to various services, industries, and markets, encouraging expertise development, and supporting the achievement of personal and career goals.

What are BDO Canada's core values, and how are they reflected in the Data & Analytics Consultant role?

BDO Canada's core values are Integrity, Respect, and Collaboration. For the Data & Analytics Consultant role, success is defined by demonstrating these values in all work aspects, understanding client needs, delivering high-quality, professional service, and contributing to an inclusive and engaging work environment.

What is the salary range for the Data & Analytics Consultant - New Grad position at BDO Canada?

The expected compensation range for the Data & Analytics Consultant - New Grad role at BDO Canada is between $60,000 and $92,000 annually.

Are there opportunities to work with Big Data technologies at BDO Canada?

Yes, experience with the Apache Hadoop ecosystem, including Spark, Data Lake, Hive, HDFS, and Impala, is considered an asset for the Data & Analytics Consultant role. This indicates BDO Canada works on 'big data' problems and values candidates with relevant experience in this area.

What is the application process like at BDO Canada for new graduate roles?

To apply for the Data & Analytics Consultant - New Grad role at BDO Canada, you should click 'Apply now' and submit your up-to-date resume. BDO Canada may use AI-enabled tools to support aspects of the recruitment process, but all employment outcomes are determined by BDO Canada personnel.