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

BDO Canada; Montreal; On-site; CAD 60,000 - 80,000; Full time

Job summary

A leading consulting firm in Montreal is seeking a New Grad Data & Analytics Consultant to deliver enterprise-level client engagements. You will work directly with clients to implement analytics solutions, design data models, and maintain data architectures. This full-time role is perfect for recent graduates with degrees in engineering or computer science and experience in data visualization tools like Power BI.

Benefits

Flexible benefits from day one

Competitive compensation

Market-leading personal time off policy

Qualifications

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

Responsibilities

• Engage directly with clients and drive the implementation of analytics solutions.
• Design and develop industry-specific data models for client projects.
• Develop, construct, test and maintain architectures such as databases.

Skills

Attention to detail

Adaptability

Data visualization

Programming in Python

Education

Post-secondary education in engineering or computer science

Tools

Azure Databricks

Power BI

SQL Server Analytics stack

Docker

Job description

Overview

Consultant, Data & Analytics - New Grad (January 2026) — BD0 Canada. Apply for the Consultant, Data & Analytics - New Grad (January 2026) role at BDO Canada.

Putting people first, every day 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

• 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 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 to deliver state-of-the-art Analytics solutions for our customers

Ready to Learn More

BDO Digital is looking for a New Grad Data Analytics Consultant / Data Engineer to join our growing client-facing team on a full-time permanent basis with various start dates available. The individual will own the responsibilities listed above.

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
• Assets : Experience with Apache Hadoop ecosystem (Spark, Data Lake, Hive, HDFS, Impala)
• Knowledge of ETL, ELT, Lambda and Kappa data architectures
• Experience with Microsoft SQL Server Analytics stack (Core SQL, SSIS, SSRS, SSAS)
• Experience working with SQL and NoSQL databases; knowledge of CI / CD tools and source control (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

Why BDO?

Our people-first approach has earned us a spot among Canada’s Top 100 Employers for 2025. We offer opportunities for learning and development, personal growth, and community involvement, plus flexible benefits from day one.

• Engage with how we change and evolve, contributing to BDO’s growth in Canada
• Opportunities for learning and development across services, industries, and markets
• Support for personal goals outside the office and community impact
• Giving back adds up : BDO is involved in local charity initiatives and supports staff with local and national events.
• Total rewards that matter : We pay for performance with competitive compensation, flexible benefits from day one, and a market-leading personal time off policy. We support overall wellness and provide reimbursements for wellness initiatives.
• Everyone counts : We are committed to a diverse, inclusive, and respectful workplace. If you require accommodation to complete the application process, please contact us.
• Flexibility : All BDO personnel are expected to spend some time in the office, at client sites, and virtually unless accommodations are in place. Our blended model supports flexible work arrangements to meet role expectations.
• Code of Conduct : Our Code of Conduct sets clear standards for ethical decision-making and trust with colleagues, clients, and the public.

With your consent, BDO Canada may use AI technology (Microsoft Copilot) to transcribe during preliminary conversations for note-taking purposes only. More information on BDO Canada’s Privacy Policy can be found here : Privacy Policy | BDO Canada.

Ready to make your mark at BDO? Click “Apply now” to send your up-to-date resume to one of our Talent Acquisition Specialists. To explore other opportunities at BDO, check out our careers page.

Seniority level

• Internship

Employment type

• Full-time

Job function

• Research, Analyst, and Information Technology

J-18808-Ljbffr