Business Analyst , Data & Analytics - New Grad (January 2027)

BDO Canada; Oakville; On-site; CAD 60,000 - 92,000; Full time

Job summary

BDO Canada is seeking a Data Analytics/Data Engineer New Grad to join our growing client-facing team on a full-time permanent basis.

This net-new role will involve delivering analytics solutions, creating data models for industries such as Natural Resources, Finance, Manufacturing, Distribution, and Retail, and building data pipelines and BI capabilities to empower clients with fast, reliable insights.

Qualifications

• Post-secondary education in engineering or computer science or equivalent work experience
• Good experience with Azure Databricks, Azure Data Factory and Azure Data Lake
• Programming experience in Python
• Strong attention to data quality and ability to adapt to changing client requirements
• Experience with Hadoop ecosystem (Spark, Data Lake, Hive, HDFS, Impala) is a plus
• Knowledge of ETL, ELT, Lambda and Kappa data architectures
• Experience with Microsoft SQL Server Analytics stack (Core SQL, SSIS, SSRS, SSAS)
• Experience with SQL and NoSQL databases
• Knowledge of CI 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

Responsibilities

• Engage directly with clients and drive implementation of analytics solutions
• Design and develop data models for enterprise projects across industries
• Build real-time data capture, transformation, and data warehouse capabilities
• Collaborate with engineers to optimize data queries and data pipelines
• Develop dashboards and automated reports to support data-driven decisions
• Stay current with new analytics technologies and deliver state-of-the-art solutions

Skills

Python

Data modeling

ETL/ELT

CI/CD

Data visualization

Education

Engineering or Computer Science degree

Tools

Azure Databricks

Azure Data Factory

Azure Data Lake

SQL Server Analytics stack

SQL/NoSQL databases

Docker

Power BI

Tableau

Spark

Job description

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

In BDO Consulting we may look for opportunities to engage you on projects across businesses.

BDO Digital

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

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

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.

At BDO, our people experience is guided by three core pillars—Do work with genuine care, Do what matters with purpose, and Do what's next - shaping how we support our people, serve our clients, and grow together.

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.
• We foster a collaborative, inclusive environment where your ideas are valued, and you can do your best work with genuine care and purpose
• We encourage innovation and forward thinking, empowering you to embrace what's next and help shape the future of our firm

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 comprehensive benefits from day one, and a flexible personal time off policy. We're committed to supporting your overall wellbeing and provide reimbursement for wellness initiatives that fit your lifestyle.

Everyone counts:

We are committed to creating a workplace where employees can participate fully, contribute meaningfully and succeed without barriers. We are dedicated to fostering a workplace defined by respect, fairness, and a true sense of belonging for everyone. We recognize and celebrate the unique experiences, identities, and perspectives that each of us bring – and that these experiences strengthen how we work together. Our commitment extends to ensuring that our application process is both inclusive and accessible. 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 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 personnel.

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