Data Scientist - Fulltime

Data Scientist Data Analytics & Visualization This replacement 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. As a member of the Data Analytics team, you will translate complex internal data into sophisticated, interactive dashboards and data products for business users throughout 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.

Design, build and maintain advanced Power BI dashboards that track firm KPIs, workforce utilisation, financial performance and internal quality metrics; user‑friendly visualisations for technical and non‑technical stakeholders.

Data Modeling &

• Transformation: Write complex SQL queries and use Databricks to clean, aggregate and structure raw data for visualisation and data product layers
• 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 as needs arise. Develop, test and deploy predictive models to support firm‑wide decision making and identify optimisation opportunities
• Partner with internal Finance, HR, Market Intelligence and Business teams to gather requirements and translate non‑technical business questions into visual data stories. 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 the firm’s security, privacy and compliance standards; maintain documentation for data models, data products, predictive models and analytical processes. 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 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. Strong ability to explain technical data insights to non‑technical accounting and finance professionals. 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. Competitive total cash compensation with performance‑based incentives. Flexible benefits from day one with a market‑leading personal time‑off policy.

Engagement in local charity initiatives and community events. Diversity, Equity and Inclusion commitment supporting all employees. Through leadership by our Diversity, Equity and Inclusion Leader, we are committed to a workplace culture of respect, inclusion and diversity, recognising and celebrating the valuable differences among each of us.

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. The model is a blended approach designed to support the flexible needs of our people, the firm and our clients. Our Code of Conduct sets clear standards for how we conduct business, 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. #