Data Scientist

Join to apply for the

Data Scientist

role at

BDO Canada

We are seeking a talented

Data Scientist

with a strong specialization in

Data Analytics & Visualization

to join our Innovation and Change team. This role is pivotal in transforming raw data into actionable insights that enhance operational efficiency, support audit, tax, and advisory engagements, and enable data‑driven decision‑making across the firm.

Key Responsibilities

Dashboard Development : Design, build, and maintain advanced Power BI dashboards that track firm KPIs, workforce utilization, financial performance, and internal quality metrics. You will design user‑friendly visualizations that present complex data in ways that are accessible to both technical and non‑technical stakeholders.

Data Modeling & Transformation : Write complex SQL queries and utilize Databricks to clean, aggregate, and structure raw data for visualization and data product layers. You will be responsible for the ETL processes required to collect and transform large datasets for reporting, analytics, and predictive modeling use cases.

Data Product Development & Maintenance : Design, build, and maintain curated data products—standardized, reusable, business‑ready datasets that serve as trusted sources of truth. Collaborate with business stakeholders to evolve data products based on emerging operational or analytical needs.

Predictive Analytics & Modeling : Develop, test, and deploy predictive models to support firmwide decision‑making and identify opportunities for optimization. Monitor and maintain model accuracy and effectiveness over time, ensuring ongoing performance alignment with business needs.

Stakeholder Collaboration : Partner with internal Finance, HR, Market Intelligence and Business teams to gather requirements and translate non‑technical business questions into visual data stories.

Communication & Storytelling : Clearly communicate technical analysis and results to stakeholders using data visualizations, reports, and presentations, ensuring insights are actionable.

Automation : Automate data refresh schedules and reporting workflows to replace manual Excel‑based processes. Ensure end‑to‑end reliability, monitoring, and sustainability of automated pipelines.

Governance : Ensure all internal data handling complies with our firm’s strict security, privacy, and compliance standards. Maintain documentation for data models, data products, predictive models, and analytical processes.

Qualifications

Education : Bachelor’s degree in Data Science, Computer Science, Engineering, Mathematics, or a related quantitative field.

SQL Mastery : Advanced proficiency in SQL (window functions, CTEs, stored procedures) with a demonstrated ability to write complex queries, optimize performance, and work with relational databases.

Databricks : Hands‑on experience with Databricks for data engineering, modeling, and analysis.

Power BI : Expert‑level skills in Power BI, including DAX, Power Query (M), and managing workspaces / gateways.

Communication : Strong ability to explain technical data insights to non‑technical accounting and finance professionals.

Preferred Qualifications

Experience working within a Professional Services, Financial Services, or CPA firm environment is an asset.

Knowledge of Python for statistical analysis or scripting outside of Databricks.

Familiarity with Azure cloud services (Azure Data Factory, Azure Data Lake).

Experience with predictive modeling or machine learning concepts.

Why BDO?

Our people‑first approach to talent has earned us a spot among Canada’s Top 100 Employers for 2025. This recognition is a milestone we’re thrilled to add to our collection of awards for both experienced and student talent experiences.

We provide :

Opportunities to drive change and growth as a key contributor to BDO Canada.

Extensive learning and development to become a better professional across services, industries, and markets.

Support for personal goals outside of the office and impact on the community.

EEO Statement

Everyone counts : We believe every employee should have the opportunity to participate and succeed. Through leadership by our Diversity, Equity and Inclusion Leader, we are committed to a workplace culture of respect, inclusion, and diversity. If you require accommodation to complete the application process, please contact us.

Seniority level

Entry level

Employment type

Full‑time

Job function

Engineering and Information Technology

#J-18808-Ljbffr