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

Data Scientist

BDO Canada • Ottawa, ON, CA
6 days ago
Job type
  • Full-time
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

We are seeking a talented Data Scientist with a strong specialization in Data Analytics & Visualisation 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 firm‑wide insight generation.

Key Responsibilities

  • Dashboard Development : Design, build, and maintain advanced Power BI dashboards that track firm KPIs, workforce utilisation, financial performance, and internal quality metrics. You will design user‑friendly visualisations that present complex data in ways that are accessible to both technical and non‑technical stakeholders.
  • Data Modelling & Transformation : Write complex SQL queries and utilise Databricks to clean, aggregate and structure raw data for visualisation and data product layers. You will be responsible for the ETL processes required to collect and transform large datasets for reporting, analytics and predictive modelling use cases.
  • Data Product Development & Maintenance : Design, build, and maintain curated data products – standardised, 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 & Modelling : Develop, test and deploy predictive models to support firm‑wide decision‑making and identify opportunities for optimisation. 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 visualisations, 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, optimise performance and work with relational databases.
  • Databricks : Hands‑on experience with Databricks for data engineering, modelling 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 modelling or machine learning concepts.
  • 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 2025. This recognition is a milestone we’re thrilled to add to our collection of awards for both experienced and student talent experiences.

    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.
  • 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 recognises and rewards your contribution. We provide flexible benefits from day one and market‑leading personal time off policy. We are committed to supporting your overall wellness beyond working hours and provide reimbursement for wellness initiatives that fit your lifestyle.

    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. We recognise and celebrate the valuable differences among each of us, including race, religious beliefs, physical or mental disabilities, age, place of origin, marital status, family status, gender or gender identity and sexual orientation. 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.

    With your consent, BDO Canada may use AI technology (Microsoft Copilot) to transcribe during preliminary conversations, solely for the purpose of note‑taking and not for other purposes, such as resume review, evaluation or selection of candidates.

    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
    Senior Data Scientist, Power Systems Analytics

    Senior Data Scientist, Power Systems Analytics

    Hydroone • Ottawa H2B, ON, Canada
    Full-time
    A leading electricity provider in Ontario is seeking an experienced Data Scientist to join their team.The role involves leading data science practices, performing analysis on operational data, and ...Show more
    Last updated: 7 days ago • Promoted
    Data Analyst - Swoon

    Data Analyst - Swoon

    Swoon • ottawa, on, ca
    Full-time
    Business Intelligence Analyst (Contract).Technology / Digital Advertising / Analytics.We’re looking for a Business Intelligence Analyst to help shape and strengthen an analytics foundation that sup...Show more
    Last updated: 2 days ago • Promoted
    Product Manager, AI-First Data-Centric Specialist

    Product Manager, AI-First Data-Centric Specialist

    Qohash • ottawa, on, ca
    Full-time
    You thrive in fast-paced, evolving environments, demonstrate a strong sense of accountability, and embrace the unknown with curiosity and determination. We value people who are not only technically ...Show more
    Last updated: 22 hours ago • Promoted • New!
    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: 14 days ago • Promoted
    Seismic Data Analyst (Hybrid, 12-Month Contract)

    Seismic Data Analyst (Hybrid, 12-Month Contract)

    Nanometrics Inc. • Ottawa
    Full-time +1
    A global leader in seismic solutions is seeking a Data Analyst to support real-time monitoring and data processing.The role requires a post-secondary degree in sciences, strong computer skills, and...Show more
    Last updated: 7 hours ago • Promoted • New!
    Consumer Insights Analyst — Data-Driven Insights & Storytelling

    Consumer Insights Analyst — Data-Driven Insights & Storytelling

    Reckitt • Ottawa
    Full-time
    A global hygiene and health company in Ottawa is searching for a Consumer Insights Analyst.This role focuses on supporting data-driven decision making by managing consumer research programs and ana...Show more
    Last updated: 7 hours ago • Promoted • New!
    Data Intelligence Analyst : Power BI & AI-Driven Insights

    Data Intelligence Analyst : Power BI & AI-Driven Insights

    Ciena • Ottawa
    Full-time
    A leading technology company in Ottawa is seeking a Data Analyst to transform data into valuable insights.You will analyze complex datasets and develop dashboards using Power BI, while collaboratin...Show more
    Last updated: 13 hours ago • Promoted • New!
    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: 7 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: 13 hours ago • Promoted • New!
    Data Analyst - ottawa

    Data Analyst - ottawa

    Swoon • ottawa, on, ca
    Full-time
    Business Intelligence Analyst (Contract).Technology / Digital Advertising / Analytics.We’re looking for a Business Intelligence Analyst to help shape and strengthen an analytics foundation that sup...Show more
    Last updated: 2 days ago • Promoted
    Data Analyst

    Data Analyst

    Nanometrics Inc. • Ottawa
    Full-time +1
    Manager, Data Centre Operations.With 40 years of seismic technology and industry application experience, we are a global, award‑winning company providing monitoring solutions and equipment for stud...Show more
    Last updated: 7 hours ago • Promoted • New!
    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
    Product Manager, AI-First Data-Centric Specialist - Qohash

    Product Manager, AI-First Data-Centric Specialist - Qohash

    Qohash • ottawa, on, ca
    Full-time
    You thrive in fast-paced, evolving environments, demonstrate a strong sense of accountability, and embrace the unknown with curiosity and determination. We value people who are not only technically ...Show more
    Last updated: 22 hours ago • Promoted • New!
    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: 7 hours ago • Promoted • New!
    Data Analyst

    Data Analyst

    Swoon • ottawa, on, ca
    Full-time
    Business Intelligence Analyst (Contract).Technology / Digital Advertising / Analytics.We’re looking for a Business Intelligence Analyst to help shape and strengthen an analytics foundation that sup...Show more
    Last updated: 2 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: 7 hours ago • Promoted • New!
    Analyst, Business Intelligence & Data Informatics

    Analyst, Business Intelligence & Data Informatics

    Ciena • Ottawa
    Full-time
    As the global leader in high-speed connectivity, Ciena is committed to a people-first approach.Our teams enjoy a culture focused on prioritizing a flexible work environment that empowers individual...Show more
    Last updated: 13 hours ago • Promoted • New!
    UGC Data Science Lead : AI & Experiments

    UGC Data Science Lead : AI & Experiments

    Scribd, Inc. • Ottawa
    Full-time
    A leading digital content platform is seeking a Lead Data Scientist to take responsibility for measurable outcomes in the User Generated Content ecosystem. This role requires the candidate to develo...Show more
    Last updated: 13 hours ago • Promoted • New!