Talent.com
Data Engineer
Data Engineerfasken • Ottawa, ON, CA
Data Engineer

Data Engineer

fasken • Ottawa, ON, CA
2 days ago
Job type
  • Full-time
Job description

About Fasken

As a premier law firm with over 900 lawyers worldwide, Fasken is where excellence meets expertise. We are dedicated to shaping the future our clients want, precisely when it matters most. For more information, visit.

Your Role

Fasken is seeking a Data Engineer to join its growing Data Analytics & Engineering team. This role is ideal for a professional who is hands-on, detail-oriented, and passionate about building reliable, well-governed, and scalable data platforms.

You will be responsible for designing, building, and maintaining data warehouses and lakehouses in Microsoft Fabric, developing robust data pipelines, ensuring ongoing data integrity, and supporting analytics and governance initiatives across the firm.

This role requires strong collaboration skills, a governance-first mindset, and the ability to clearly communicate complex data issues to both technical and non-technical audiences.

Primary Responsibilities

Data Engineering & Platform Development

  • Design, build, and maintain data warehouses and data lakehouses in Microsoft Fabric
  • Develop and support ETL/ELT pipelines, dataflows, and data ingestion processes
  • Use notebooks (Python, SQL) to transform, validate, and move data across platforms
  • Build and maintain semantic models to support analytics and reporting
  • Ensure data integrity, accuracy, and consistency throughout all transformations

Monitoring, Reliability & Optimization

  • Monitor daily data loads to ensure completeness, freshness, and integrity
  • Maintain and follow a regular operational checklist to monitor data infrastructure health
  • Build Power BI dashboards, reports and alerts to monitor data movement, quality, and system performance
  • Monitor and optimize data platform compute usage to ensure efficient performance and cost control
  • Troubleshoot and resolve data-related issues and business tickets in a timely manner

Governance, Security & Compliance

  • Act as a champion and ambassador for data governance, compliance, and ethical data usage
  • Adhere to strict requirements such as ethical walls, access segregation, and confidentiality controls
  • Participate in and lead data governance initiatives, including: Defining and standardizing data fields Data clean-up and quality improvement efforts
  • Set up and maintain secure access to data resources, leveraging Microsoft Entra ID groups and role-based access control
  • Perform regular production system closing procedures on month end and year end.

Collaboration & Communication

  • Collaborate closely with: Data analysts and senior analysts Data governance leadership Technology teams and business stakeholders
  • Translate data issues and limitations into clear, business-friendly language
  • Support ad hoc reporting and data requests from the business
  • Partner with stakeholders to identify pragmatic, compliant, and scalable data solutions
  • Document and or update processes and Standard Operating Procedures (SOP)

Engineering Practices

  • Experience using GitHub and DevOps practices for version control, collaboration, and deployments
  • Leverage Copilot and modern tooling to optimize Python and SQL code
  • Contribute to improving standards, documentation, and repeatable patterns across the data platform

What Success Looks Like

Within this role, success is measured by:

  • High integrity and trustworthiness of data
  • Reliable and stable data pipelines and platforms
  • Consistent and optimal time-to-delivery for data and analytics solutions
  • Strong adherence to governance, security, and ethical data standards
  • Positive feedback from business and technology partners

Required Knowledge and Experience

  • Bachelor’s degree in math, economics, statistics, engineering, computer science, or other quantitative field, or equivalent level of experience
  • 4+ years of experience in data engineering or a closely related role
  • Strong experience with Microsoft Azure–based data platforms, including:
  • Azure services, Microsoft Fabric, SQL Server Other equivalent platforms are also considered: AWS, Snowflake
  • Proficiency in SQL and Python for data transformation and pipeline development
  • Experience building and maintaining:
  • Data warehouses and/or lakehouses Data pipelines and dataflows
  • Familiarity with Power BI and semantic modeling (sufficient to build and support functional reports)
  • Experience working with data governance, access control, and compliance requirements
  • Strong troubleshooting, communication, and collaboration skills
  • Microsoft Certification required (or candidate to obtain Certification within the first year)
  • Knowledge of the Elite 3E ERP is an asset
  • Strong analytical and problem-solving skills;
  • Ability to work in a Remote-first environment, where internal clients may be located in various geographical locations and timezones.
  • Excellent planning and organizational skills, ability to manage multiple files simultaneously and meet established deadlines;
  • Professionalism, discretion and commitment to outstanding customer service;
  • Autonomy and ability to deal with multiple stakeholders;
  • Organizational skills, thoroughness and ability to manage priorities;

Pay Range

$90,000 to $110,000 per annum. Pay range to be commensurate with experience.

Vacancy

This role is being posted to fill a current vacancy.

Create a job alert for this search

Data Engineer • Ottawa, ON, CA

Similar jobs

Senior Data Engineer

TechBrainsOttawa, ON, CA
Full-time

As a Senior Data Engineer on Mozilla's Analytics Engineering team, you'll design data models and improve our data platform.You will collaborate with data scientists to guide product decisions, main...Show more

 • Promoted

Senior Data Engineer - Marketing Tech Data Platform Lead

ThumbtackOttawa, ON, CA
Full-time

A leading home services platform is seeking an experienced Data Engineer to join their Marketing Tech team.You will design, build, and maintain data systems that enhance marketing efforts.Ideal can...Show more

 • Promoted

Senior Data Engineer

NodaOttawa, ON, CA
Full-time

Noda is a data and analytics company for the commercial built environment.We reimagine how modern buildings operate — because a better world needs better buildings.Better buildings are more efficie...Show more

 • Promoted

Data Engineer Focused on AI-Driven Analytics for Healthcare

Practice BetterOttawa, ON, CA
Full-time

Elevate your career as a Data Engineer committed to transforming global health.Work in a remote-first capacity to optimize our advanced data systems and support AI-enhanced decision-making.This rol...Show more

 • Promoted • New!

Lead Data Engineer, Microsoft Fabric Lakehouse (Remote)

Info-Tech ResearchOttawa, ON, CA
Remote
Full-time

A technology research organization based in Canada is seeking an experienced Senior Data Engineer to spearhead the implementation of Microsoft Fabric.The role involves developing ETL/ELT pipelines,...Show more

 • Promoted

Data Engineer

BorrowellOttawa, ON, CA
Full-time

At Borrowell, we're on a mission to help Canadians feel confident about their money.We empower individuals to take control of their financial futures by providing the tools and insights needed to u...Show more

 • Promoted

Lead Data Engineer

Launch PotatoOttawa, ON, CA
Full-time

Launch Potato is a profitable digital media company that reaches over 30M+ monthly visitors through brands such as FinanceBuzz, All About Cookies, and OnlyInYourState.As The Discovery and Conversio...Show more

 • Promoted

Remote Senior Data Engineer - Databricks

LumenaltaOttawa, ON, CA
Remote
Full-time

Drive impactful data solutions as a Senior Data Engineer in a fully remote role.Own the design and scaling of ETL/ELT pipelines with Databricks on AWS, ensuring top performance and reliability.In t...Show more

 • Promoted

Azure Data Engineer: Fabric Pipelines & Data Models

Symbiotic GroupOttawa, ON, CA
Full-time

A leading IT consulting firm is looking for an experienced Azure Data Engineer to build and manage a scalable data integration platform.The successful candidate will work on Microsoft Fabric to des...Show more

 • Promoted

Senior Data Engineer

DatatonicOttawa, ON, CA
Full-time

Shape the Future of AI & Data with Us.At Datatonic, we are Google Cloud's.We push the boundaries of technology with expertise in.By partnering with us, clients future‑proof their operations, unlock...Show more

 • Promoted

Senior Data Platform Engineer

SamsaraOttawa, ON, CA
Full-time

Get AI-powered advice on this job and more exclusive features.This range is provided by Samsara.Your actual pay will be based on your skills and experience — talk with your recruiter to learn more....Show more

 • Promoted

Azure Databricks Engineer

Tredence Inc.ottawa, on, ca
Full-time

We are seeking a skilled Azure Databricks Engineer with strong experience in Azure Data Factory (ADF) to design, develop, and maintain scalable data pipelines and analytics solutions on the Azure c...Show more

 • Promoted

Senior Data Engineer

CloudDevsOttawa, ON, CA
Full-time

At Neon One, we believe that technology is the key to building vibrant communities of generosity.As a leader in nonprofit software since 2004, we create intuitive solutions that help small and mid-...Show more

 • Promoted

Senior Data Engineer

TapMangoOttawa, ON, CA
Full-time

We need someone who can turn millions of messy transactions into clean, fast, "aha moment" analytics for thousands of merchants.You’ll build the data pipelines that power dashboards, design the war...Show more

 • Promoted

Data Engineer for Analytics Solutions

BDO CanadaOttawa, ON, CA
Full-time

Drive analytics success as a Data Engineer and implement solutions for enterprise clients.Leverage industry expertise in Natural Resources, Finance, and Retail on high-impact client engagements.In ...Show more

 • Promoted

Senior / Lead Data Engineer (remote)

North American Search GroupOttawa, ON, CA
Remote
Full-time

Design and build scalable data solutions to consolidate and analyze large, diverse data sources.Generate actionable insights to support product, client, and business decision-making.Partner with pr...Show more

 • Promoted

Data Engineer

WysdomOttawa, ON, CA
Full-time

They say you only get one chance to make a great first impression.At Wysdom we’re here to change that.We exist to help our clients make a great first impression with their customers – over and over...Show more

 • Promoted

Data Engineer - GCP Data Platform (Remote)

Clever Digital MarketingOttawa, ON, CA
Remote
Full-time

A leading digital marketing firm in Canada seeks a Data Engineer to build data pipelines and manage infrastructure.The role involves implementing scalable ETL processes and translating architectura...Show more