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

Data Engineer

fasken • Ottawa, ON, CA
30+ days ago
Salary
CA$90,000.00 yearly
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 (Analytics Focus)

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 with Microsoft Fabric Expertise

BDO CanadaOttawa, ON, CA
Full-time

Join a team dedicated to building a robust data platform using Microsoft Fabric.As a Data Engineer, you'll support data ingestion, modeling, and reporting in a collaborative environment.This founda... Show more

 • Promoted

Data Engineer Role in Alberta’s Digital Division

PathlionOttawa, ON, CA
Full-time

Be part of Alberta's digital transformation as a Data Engineer.Contribute to innovative projects by creating data pipelines and deriving insights that meet the needs of citizens.As a core member of... Show more

 • Promoted

Lead Data Engineer Innovating Healthcare Data Architecture

Synthesis HealthOttawa, ON, CA
Full-time

Drive data engineering excellence as a Staff Data Engineer and help transform healthcare data practices.Spearhead architecture optimizations and educate teams in a fully remote role.As a leader in ... 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

Senior Data Engineer

knakOttawa
Full-time

Why? Because our time is limited, our competition is fierce, and our margin for error is small.For us to have the greatest impact on the world, we need to be laser focused on our core mission, whic... 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

Azure Data Engineer

Symbiotic GroupOttawa, ON, CA
Full-time

We are seeking an Azure Data Engineer with strong, hands-on Microsoft Fabric experience to build and operate a scalable middle-layer data and integration platform.The role focuses on ingesting data... Show more

 • Promoted

Azure Databricks Engineer

Tredence Inc.gatineau, qc, 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

Staff Engineer, Data & Analytics

KinaxisOttawa, ON, CA
Full-time

Are you looking to join an innovative, market‑leading company where you can truly elevate your career? At Kinaxis we are serious about culture, technology, customers, and not taking ourselves too s... Show more

 • Promoted

Senior Data Engineer

Work in OttawaOttawa, ON, CA
Full-time

Ottawa’s tech sector is growing, and so are the opportunities! If you’re exploring your next role in tech, Work in Ottawa can help you learn about leading employers and exciting careers in Canada’s... Show more

 • Promoted

Data Engineer

Thales GroupOttawa
Full-time

Location: Ottawa, CanadaIn fast changing markets, customers worldwide rely on Thales.Thales is a business where brilliant people from all over the world come together to share ideas and inspire eac... 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

Advanced Data Engineer for Large Datasets and ETL Pipelines

LumenaltaOttawa, ON, CA
Full-time

Transform data into insights as an Advanced Data Engineer specializing in complex ETL pipelines.Embrace this remote opportunity to use your Python or Java and SQL skills effectively.This role invit... Show more

 • Promoted

Lead Generative AI Engineer - Inizio Partners

Inizio Partnersgatineau, qc, ca
Full-time

Role - Lead Generative AI Engineer.Location - Can be based anywhere in Canada.Travel - Should be open to frequent travel to client sites.We are looking for a Staff Generative AI Engineer to design,... Show more

 • Promoted

Data Engineer

DS Technologies IncOttawa, ON, CA
Full-time

Get AI-powered advice on this job and more exclusive features.About US: We are a company that provides innovative, transformative IT services and solutions.We are passionate about helping our clien... Show more

 • Promoted

Data Engineer

ThalesOttawa, ON, CA
Full-time

In fast changing markets, customers worldwide rely on Thales.Thales is a business where brilliant people from all over the world come together to share ideas and inspire each other.In aerospace, tr... Show more

 • Promoted

Hybrid Data Engineer at JAM Industries

JAM IndustriesOttawa, ON, CA
Full-time

Join the data team at JAM Industries as a Hybrid Data Engineer, where your skills in building scalable data architectures will drive analytics and AI/ML projects.This role offers a chance to evolve... Show more

 • Promoted

Staff Engineer, Data & Analytics

Kinaxis Inc.Ottawa, ON, CA
Full-time

Are you looking to join an innovative, market-leading company where you can truly elevate your career? At Kinaxis we are serious about culture, we are serious about technology, we are serious about... Show more

 • Promoted

Senior Data Engineer

VantageOttawa, ON, CA
Full-time

Vantage is looking for its next Senior Data Engineer to join our Measurement team.Our Measurement team is focused on enhancing the Insights Explorer feature of our platform, enabling the organizati... Show more