Data Engineer

Dye & Durham; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading company in legal technology seeks a Data Engineer to develop and manage data pipelines. This role involves working with Databricks and Power BI, focusing on data integrity and architecture while collaborating with the Global Analytics team. Ideal candidates will thrive in fast-paced environments and bring innovative solutions to data challenges.

Benefits

Healthcare

Pension

Company discounts

Wellness programs

Paid days off for moving or volunteering

Qualifications

• 3+ years of experience in data engineering or analytics engineering role.
• Strong expertise in Databricks and Power BI.
• Experience with SQL and Python programming languages.

Responsibilities

• Maintaining the D&D Global Data Warehouse with ETL / ELT for 25+ data sources.
• Collaborating on new data source implementations related to business acquisitions.
• Monitoring data quality and query performance.

Skills

Data modelling

ETL / ELT development

APIs

SQL

Python

Databricks

Power BI

AWS

Azure

GCP

Education

Bachelor's degree in Computer Science or related field

Job description

We are seeking a Data Engineer with strong expertise in Databricks and Power BI to help us build and scale a modern analytics foundation. This role is critical to supporting the Global Analytics team in delivering timely, accurate, and actionable insights across the organization.

You will be responsible for the end-to-end development and management of data pipelines and infrastructure—from ingestion and transformation to delivery and reporting. A core part of the role includes implementing and maintaining Medallion Architecture (Bronze, Silver, Gold layers) in Databricks to ensure data is clean, governed, and reusable across multiple use cases.

We’re looking for someone who thrives in unstructured environments, enjoys building from the ground up, and is motivated to make a tangible impact. The ideal candidate combines strong technical ability with a practical, delivery-focused mindset.

Key Responsibilities

• Technical Proficiency : Strong expertise in Databricks and Power BI is essential, along with solid skills in SQL or Python. Familiarity with cloud platforms (AWS, Azure, or GCP), ETL / ELT development, APIs, and database modeling
• Data Architecture Understanding : Strong grasp of data warehousing principles, data processing patterns, and best practices for analytical infrastructure
• Builder Mentality : Capable of designing systems from scratch; operates well in ambiguous, fast-changing environments without relying on predefined processes, but can create them when needed
• Delivery-Oriented : Prioritizes execution—can ramp up quickly, identify inefficiencies, and take ownership of delivering working solutions
• Growth Mindset : Curious, adaptive, and willing to learn new tools to meet business and technical needs
• Documentation & Discipline : Values clear documentation, version control, and QA / testing as part of a sustainable engineering practice
• Cost-Conscious Engineering : Understands the trade-offs between performance, scalability, and cost when working with cloud and data resources

Duties will include, but not be limited to the following :

• Maintaining the D&D Global Data Warehouse, including managing the ETL / ELT processes for 25+ data sources and associated product / customer mapping tables
• Collaborating with internal and external stakeholders to implement new / supplementary data sources related to business acquisitions
• Monitoring data quality, job execution times, job success / failure and query performance in order to ensure maximum data availability, with support for back-up solutions
• Collaborating with the Global Analytics team on delivery of reports / dashboards / analyses, including building / maintaining Excel & Power BI reports
• Supporting the Global Analytics Director with establishing governance processes related to the data warehouse and the long-term data roadmap

Skills, Knowledge & Expertise

• 3+ years of relevant experience in a data engineering or analytics engineering role; must be able to demonstrate knowledge and experience with data modelling, ETL / ELT development principles, APIs and data warehousing concepts
• Strong verbal and written communication skills to clearly convey technical information, manage and professionally communicate regarding the health and integrity of systems
• A high level of attention to detail problem-solving skills, and a passion and curiosity for data and data-driven decision making
• Be a team player with the ability to collaborate well across global functional groups
• Experience with one or more programming languages, such as SQL (highly-preferred), R or Python
• Strong hands-on experience with Databricks and Power BI
• Familiarity with cloud integration platforms like Boomi is a plus but not mandatory
• Able to commute to our Toronto office – this is an on-site position

At Dye & Durham we strive to be visionaries! As a leader in our field, we ensure our employees are ready for the next challenge in their journey with us by offering internal and external training opportunities. We offer competitive salaries and a whole host of benefits including healthcare, pension, company discounts, wellness programs, and paid days off to move house or volunteer for your favorite charity.

Do you share our DNA?

• We ask how tomorrow can be better than today
• We are passionate about solving our customer's challenges
• Our ideas break boundaries
• We value different perspectives and encourage dialogue
• We take ownership and celebrate together

Dye & Durham is a global leader in legal technology. The company’s three categories of integrated solutions – practice management, data insights and due diligence, and client onboarding – give solicitors the essential tools they need to run their firms, from client acquisition to case management and legal accounting, and everything in between.

Trusted by thousands of legal practitioners globally, Dye & Durham helps law firms achieve more growth with less effort.