Senior/Manager, Business Intelligence Consultant

Type: Permanent | Full time | Remote work

Position Overview:

We are looking for a senior, hands-on consultant to become the technical authority for our legal finance data layer. You will own how Elite 3E and Aderant data is extracted, modelled and delivered. You will lead the move of reporting from on-premises SQL Server to Microsoft Fabric, and you will work directly with law firm finance leaders to make sure the numbers are right.

This role suits someone who enjoys both engineering and consulting: working in pipelines and DAX, and explaining to a finance director why a figure is what it is.

Responsibilities:

- Own and develop our ETL framework for Elite 3E and Aderant, across legacy SQL Server/SSIS/SSAS pipelines and their Microsoft Fabric replacements.
- Design and build Fabric lakehouse and warehouse solutions using a medallion architecture, Data Factory pipelines, notebooks and incremental loading.
- Lead client migrations from on-premises to Fabric, from planning and build through reconciliation and cutover.
- Design star-schema semantic models for law firm finance, covering time, WIP, billing, collections, AR, realisation, utilisation and profitability, and write efficient, well-structured DAX.
- Reconcile reporting to 3E and Aderant source data and agree data accuracy with client finance teams.
- Run discovery sessions with law firm stakeholders and turn their questions into clear data requirements.
- Coach and review the work of other consultants, and help set our development and documentation standards.




- Help shape how the division uses AI tools, from Copilot in Fabric and Power BI to AI-assisted development and testing.

Qualifications:

- Expert back-end knowledge of Elite 3E and/or Aderant (Expert/Sierra): the finance data model, key tables and relationships, and common data issues. Working knowledge of the other system.
- 7+ years building data warehouses and ETL in production, including SQL Server and SSIS or equivalent.
- Hands-on delivery experience in Microsoft Fabric , including at least one production lakehouse or warehouse build or migration.
- Expert Power BI semantic modelling and DAX, including performance tuning.
- A solid understanding of law firm finance metrics: WIP, lockup, realisation, utilisation and matter profitability.
- Client-facing consulting experience, with confidence presenting to finance directors and CFOs.
- Practical, everyday use of AI tools in data development.
- The right to work in the UK, Canada or the US.

Working requirements:

- Fully remote, with occasional travel to client sites and industry events.
- North American candidates will need to be available 08:00–12:00 ET each working day to overlap with our UK-based team and clients.
- Most client discovery happens remotely over Microsoft Teams.

Datolite Solutions works with law firms and with sensitive data, the successful candidate must pass our comprehensive background check process. Datolite Solutions is an equal opportunity employer. All applications for this role will be considered; however, only short-listed candidates will be contacted.

📌 Senior/Manager, Business Intelligence Consultant (Greater Toronto Area)
🏢 Datolite Solutions
📍 Greater Toronto Area