Data Scientist

Putting people first, every day
BDO is a firm built on 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 return, 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 & 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. Create user‑friendly visualizations 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. Manage ETL processes for large datasets.
• 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 stakeholders to evolve data products.
• Predictive Analytics & Modeling: Develop, test, and deploy predictive models to support firmwide decision‑making and identify optimization opportunities. Monitor model accuracy over time.
• Stakeholder Collaboration: Partner with 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 through data visualizations, reports, and presentations, ensuring actionable insights.
• Automation: Automate data refresh schedules and reporting workflows to replace manual Excel processes. Ensure end‑to‑end reliability and sustainability of pipelines.
• Governance: Ensure all data handling complies with security, privacy, and compliance standards. Maintain documentation for models and analyses.

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 and optimize performance.
• 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 workspace management.
• 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 has earned us a spot among Canada’s Top 100 Employers for 2025. BDO offers extensive learning and development opportunities, community‑impact initiatives, competitive compensation, flexible benefits, and a culture of inclusion and diversity. The firm supports wellness initiatives and upholds a strict Code of Conduct.

Ready to make your mark? Click “Apply now” to send your resume to a Talent Acquisition Specialist. Explore other opportunities on our careers page.

Seniority level

Entry level

Employment type

Full‑time

Job function

Engineering and Information Technology