
Consultant, Data & Analytics - New Grad (January 2026)
- Vancouver, BC
- $67,000-101,000 per year
- Permanent
- Full-time
- 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
- 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; client 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.
- 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 and 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