Talent.com
Data Scientist
Data ScientistBDO Canada • Ottawa, ON, CA
Data Scientist

Data Scientist

BDO Canada • Ottawa, ON, CA
4 days ago
Job type
  • Full-time
Job description

Overview

Putting people first, every day. BDO is a firm built on positive relationships with our people and clients. Our professionals provide exceptional service, helping clients with advice and insight they can trust. We offer an award-winning environment that fosters a people-first culture with a high priority on personal and professional growth.

Your Opportunity

We are seeking a talented Data Scientist with a strong specialization in Data Analytics & Visualization to join our Innovation and Change team. This is a replacement role and 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.

As a member of the Data Analytics team, you will not just analyze data—you will be responsible for the "last mile" of our data strategy : translating complex internal data into sophisticated, interactive dashboards and data products for business users across the organization. You will work directly within our Databricks lakehouse and SQL data warehouses to architect data models, curated datasets, and predictive tools that enable firmwide insight generation.

Key Responsibilities

  • Dashboard Development : Design, build, and maintain advanced Power BI dashboards that track firm KPIs, workforce utilization, financial performance, and internal quality metrics. Design user-friendly visualizations that present complex data accessibly 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. Responsible for ETL processes 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.
  • 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 and sustainability of automated pipelines.
  • Governance : Ensure internal data handling complies with the firm’s 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 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 in 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.
  • Compensation

    The expected range of compensation for this role is $74,000 to $112,000.

    Why BDO?

    Our people-first approach to talent has earned us a spot among Canada’s Top 100 Employers for 2026. We’re committed to providing an environment where you can succeed in the following ways :

  • Engage with how we change and evolve, contributing to the success and growth of BDO in Canada.
  • Opportunities for learning and development across services, industries, and markets.
  • Support for personal goals outside of the office and making an impact in the community.
  • Giving back adds up : BDO engages with community initiatives and supports staff with local and national events.

    Total rewards that matter : Competitive total cash compensation, flexible benefits from day one, and a market-leading personal time off policy. We support overall wellness and reimburse wellness initiatives.

    Everyone counts : We are committed to a workplace culture of respect, inclusion, and diversity. If you require accommodation to complete the application process, please contact us.

    Flexibility : Our blended model supports working in the office, at client sites, or virtually, with accommodations or alternative arrangements as needed.

    Code of Conduct : Our Code of Conduct guides ethical decisions and trust with colleagues, clients, and the public.

    BDO may use AI-enabled tools to assist recruitment. AI does not replace human decision making, and all employment-related outcomes are made by BDO personnel.

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

    Ready to make your mark at BDO? Click “Apply now” to send your up-to-date resume to one of our Talent Acquisition Specialists.

    To explore other opportunities at BDO, check out our careers page.

    #J-18808-Ljbffr

    Create a job alert for this search

    Data Scientist • Ottawa, ON, CA

    Similar jobs
    Staff Applied AI Scientist - Ottawa, ON

    Staff Applied AI Scientist - Ottawa, ON

    Trend Micro • Ottawa
    Full-time
    Staff Applied AI Scientist - Ottawa, ON.Trend Micro, a global cybersecurity leader, harnesses AI to protect organizations and individuals across clouds, networks, devices, and endpoints.The Trend V...Show more
    Last updated: 25 days ago • Promoted
    SAP SuccessFactors Data Lead - ottawa

    SAP SuccessFactors Data Lead - ottawa

    Experis • ottawa, on, ca
    Full-time
    Our client, a leading organization in the public sector, is seeking a.As a SAP SuccessFactors Data Lead, you will be part of the HR and Data Management department supporting SAP HR modules.The idea...Show more
    Last updated: 11 hours ago • Promoted • New!
    Data Modeler — Agile DW & Analytics

    Data Modeler — Agile DW & Analytics

    CGI • Ottawa
    Full-time
    A leading IT consulting firm is seeking a skilled Data Modeler in Ottawa, Ontario.Candidates should have over 5 years of experience in data modeling, proficiency in Agile methodologies, and excelle...Show more
    Last updated: 7 days ago • Promoted
    Applied AI Scientist — Telecom Innovation Leader

    Applied AI Scientist — Telecom Innovation Leader

    Ericsson GmbH • Ottawa
    Full-time
    A leading technology firm in Ottawa is looking for an AI Data Scientist to drive innovative AI solutions in radio product development. The ideal candidate should possess a strong background in appli...Show more
    Last updated: 8 days ago • Promoted
    Vision AI Data Analyst - Pharma Manufacturing Insights

    Vision AI Data Analyst - Pharma Manufacturing Insights

    NTT DATA, Inc. • Ottawa
    Full-time
    A data solutions firm in Ottawa, Canada, is seeking an experienced Data Analyst with a background in pharmaceutical or life sciences manufacturing. Responsibilities include collecting and processing...Show more
    Last updated: 1 day ago • Promoted
    SAP SuccessFactors Data Lead - Experis

    SAP SuccessFactors Data Lead - Experis

    Experis • ottawa, on, ca
    Full-time
    Our client, a leading organization in the public sector, is seeking a.As a SAP SuccessFactors Data Lead, you will be part of the HR and Data Management department supporting SAP HR modules.The idea...Show more
    Last updated: 11 hours ago • Promoted • New!
    Data AnalystDeveloper (34507)

    Data AnalystDeveloper (34507)

    Myticas Consulting • Ottawa
    Full-time
    Our financial client is seeking a Data Analyst / Developer specialized in Power BI & Microsoft Fabric for a long term HYBRID contract. The Developer will support cyber strategy, analytics, AI enable...Show more
    Last updated: 2 days ago • Promoted
    Data Scientist

    Data Scientist

    Hydroone • Ottawa H2B, ON, Canada
    Full-time
    Select how often (in days) to receive an alert : .Hydro One is proud to be the largest electricity transmission and distribution provider in Ontario, serving nearly 1. We have a long history in the in...Show more
    Last updated: 18 days ago • Promoted
    Data Scientist / Developer

    Data Scientist / Developer

    IPV Holdings Ltd • Ottawa, Ontario, Canada
    Full-time
    Quick Apply
    Proficient and comfortable using : .Language (MUST) : NodeJS or JavaScript.Tool : Angular, Echarts, ApexChart.Language (MUST) : NodeJS or JavaScript, Python. Language (MUST) : Python, Shell, SQL.Databases...Show more
    Last updated: 4 days ago
    AI and Data - Data Architect (Snowflake)

    AI and Data - Data Architect (Snowflake)

    EY • Ottawa
    Full-time
    At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your u...Show more
    Last updated: 9 days ago • Promoted
    Data Insights Analyst — BI & Informatics (Flexible)

    Data Insights Analyst — BI & Informatics (Flexible)

    Ciena Corporation • Ottawa
    Full-time
    A telecommunications leader in Ottawa is seeking a Data Analyst to analyze complex datasets and develop dashboards using Power BI. The ideal candidate has 3–5 years of experience in data analysis an...Show more
    Last updated: 10 days ago • Promoted
    Data Analyst Developer (34507)

    Data Analyst Developer (34507)

    Myticas LLC • Ottawa
    Full-time
    Our financial client is seeking a Data Analyst / Developer specialized in Power BI & Microsoft Fabric.For a long term HYBRID contract, the Developer will support cyber strategy, analytics, AI enabl...Show more
    Last updated: 8 days ago • Promoted
    Remote Data Architect - Modernize Enterprise Data

    Remote Data Architect - Modernize Enterprise Data

    Orangutech • Ottawa H2B, ON, Canada
    Remote
    Part-time
    A public service organization is seeking an experienced Database Architect for a future opportunity.This role focuses on leading assessments and modernizing the enterprise data ecosystem.Candidates...Show more
    Last updated: 30+ days ago • Promoted
    Senior AI & Data Architect

    Senior AI & Data Architect

    US Tech Solutions • Ottawa
    Full-time
    Under the direction of the Assistant Director, Cyber Strategy and Awareness : .Design Copilot Studio agents that answer data questions and automate workflows (Power Automate, Dataverse, Microsoft Gra...Show more
    Last updated: 3 days ago • Promoted
    Consumer Insights Analyst : Data-Driven Storytelling

    Consumer Insights Analyst : Data-Driven Storytelling

    Reckitt • Ottawa
    Full-time
    A global health and hygiene company is seeking a Consumer Insights Analyst to enable data-driven decision making through managing consumer research and delivering actionable insights.Located in Ott...Show more
    Last updated: 10 days ago • Promoted
    Consumer Insights Analyst — Data-Driven Insights & Storytelling

    Consumer Insights Analyst — Data-Driven Insights & Storytelling

    Reckitt Benckiser LLC • Ottawa
    Full-time
    A global consumer goods company in Canada is looking for a Consumer Insights Analyst to manage consumer research and deliver actionable insights. The successful candidate will have a Bachelor's degr...Show more
    Last updated: 10 days ago • Promoted
    Data Analyst : AI-Driven Insights & Azure SQL Specialist

    Data Analyst : AI-Driven Insights & Azure SQL Specialist

    Xplore Inc. • Ottawa
    Full-time
    A leading broadband company in Canada is seeking a Data Analyst to enhance reporting and analytics.The role includes developing automated reports, writing SQL queries, and supporting data engineeri...Show more
    Last updated: 9 days ago • Promoted
    MSc - Large-scale Data-Driven Mineral Prospectivity Mapping

    MSc - Large-scale Data-Driven Mineral Prospectivity Mapping

    Employment and Social Development Canada • Ottawa
    Full-time +2
    MSc - Large-scale Data-Driven Mineral Prospectivity Mapping - Research Affiliate Program.Natural Resources Canada- Geoscience & Earth Monitoring Sector - Geological Survey of Canada - GSC-Central.C...Show more
    Last updated: 9 days ago • Promoted