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

BDO Canada is a firm built on a foundation of positive relationships with their people and clients, and they are seeking a Data Analytics/ Data Engineer New Grad to join their client-facing team. The role involves engaging with clients to implement analytics solutions, designing industry-specific data models, and maintaining data management systems.

Responsibilities

• 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

Skills

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

Benefits

• Flexible benefits from day one
• Market leading personal time off policy
• Reimbursement for wellness initiatives that fit your lifestyle

Company Overview