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.ResponsibilitiesPlay an integral role in our delivery practice as we execute on enterprise level client engagements through our various industry specializationsEngage 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 budgetDesign and develop industry-specific data models for client projects in industries such as Natural Resources, Finance, Manufacturing and Distribution, and RetailWork with other engineers to enhance data models and improve data query efficiency; create complex data queries to facilitate ad hoc and exploratory analyticsBuild real-time data capture and transformation functionality across all products and build out technology stack for Business Intelligence and Data WarehouseClean 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 analyticsDevelop, construct, test and maintain architectures such as databases and large-scale data processing systems; design, construct, install, test and maintain highly scalable data management systemsEmploy a variety of languages and tools (e.g. scripting languages) to marry systems togetherBuild or recommend data visualization tools and business intelligence tools such as interactive dashboards and automated reports, to enable leaders to make swift, fact-based decisionsRemain up to date of development technologies, both current and future in order to deliver state-of-the-art Analytics solutions for our customersSkillsPost-secondary education in engineering or computer science or equivalent work experienceGood experience working with Azure Databricks, Azure Data Factory and Azure Data LakeProgramming experience in PythonStrong attention to the quality of work delivered (attention to detail)Able to adapt quickly to changing client requirementsExperience using the Apache Hadoop ecosystem (Spark, Data Lake, Hive, HDFS, Impala) to tackle 'big data' problemsKnowledge of ETL, ELT, Lambda and Kappa data architecturesExperience with the Microsoft SQL Server Analytics stack including: Core SQL, SSIS, SSRS, SSASExperience working with SQL and NoSQL databasesKnowledge of Continuous Integration and Source Control systems (e.g. Gradle, Maven, Bamboo, TeamCity, Git)Data Visualization experience in Power BI, Tableau, or similarExposure to data science, machine learning or statisticsSome experience using DockerBenefitsFlexible benefits from day oneMarket leading personal time off policyReimbursement for wellness initiatives that fit your lifestyleCompany OverviewBDO Canada is a consulting firm that provides auditing, outsourcing, taxation, assurance, and financial advisory services. It was founded in 1921, and is headquartered in Toronto, Ontario, CAN, with a workforce of 1001-5000 employees. Its website is http://www.bdo.ca/en/pages/default.aspx.