Data Engineer

TULLOCH; Ottawa; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A consulting engineering firm in Ottawa is seeking an experienced Data Engineer to design and implement modern data architectures using Microsoft Fabric. This role requires strong expertise in data engineering and Microsoft Azure services. The ideal candidate has over 6 years of experience in the field, is proficient in SQL and Python, and possesses excellent communication skills. We offer a competitive salary, benefits, and a flexible work environment.

Benefits

Competitive salary

Flexible working hours

Company pension plan

Social activities and events

Qualifications

• 6+ years of experience in data engineering with Microsoft Fabric and Azure Data Services.
• Strong expertise in Microsoft Fabric and data warehousing.
• Proven experience with CI/CD tools.

Responsibilities

• Design and implement modern data architectures.
• Develop scalable data models with Power BI integrations.
• Mentor junior engineers and contribute to best practices.

Skills

Data engineering

Microsoft Fabric

Power BI

Python

SQL

ETL/ELT pipelines

Cloud platforms

Agile methodology

Communication skills

Tools

Data Factory

Azure DevOps

Jenkins

Kafka

Azure Synapse

Job description

Come Join Us! TULLOCH is a leading multi‑disciplinary consulting engineering firm recognized across Canada for its strengths in diverse service offerings and commitment to excellence. With emerging technologies to improve efficiency and quality, TULLOCH is the service provider of choice for many clients.

What You’ll Do

• Design and implement modern data architectures within Microsoft Fabric, leveraging Lakehouse, Data Warehousing, and OneLake features.
• Develop scalable data models optimized for analytics and reporting with Power BI integrations.
• Build, automate, and optimize data pipelines using Data Factory, Synapse, and Fabric Dataflows.
• Ensure efficient ingestion, transformation, and curation of structured and unstructured data from diverse sources.
• Implement and enforce data governance, cataloging, lineage, and security policies in Fabric.
• Optimize data processing and query performance for larger‑scale datasets.
• Work closely with business stakeholders to translate requirements into solutions.
• Mentor junior engineers and contribute to best practices and coding standards.

Who You Are

• 6+ years of experience in data engineering, with at least 2+ years working hands‑on with Microsoft Fabric and Azure Data Services.
• Strong expertise in Microsoft Fabric, including Lakehouse, OneLake, Data Engineering, and Synapse Data Warehousing.
• Strong background in Linux/Unix system administration and scripting (Bash, Python, PowerShell).
• Proven experience with CI/CD tools (Jenkins, GitLab CI, GitHub Actions, Azure DevOps, etc.).
• Experience with AI/ML model integration within Microsoft Fabric.
• Hands‑on experience with real‑time streaming solutions (Event Hubs, Kafka, etc.).
• Understanding of networking, firewalls, load balancers, and security best practices.
• Experience with cloud platforms (AWS, Azure, GCP) in production environments.
• Independent judgment, willingness to travel periodically, and strong communication skills.

What You Should Bring

• Proficiency in SQL, PySpark, Python, and DAX.
• Experience with ETL/ELT pipelines (Data Factory, Synapse Pipelines, or similar).
• Knowledge of Power BI integration for reporting and analytics.
• Familiarity with Azure ecosystem: Azure Data Lake, Azure Databricks, Azure Synapse, Azure Purview.
• Experience with data governance, lineage, and security frameworks.
• Strong leadership ability in cross‑functional and geographically distributed teams.
• Strong analytical and problem‑solving abilities.
• Excellent communication skills to bridge technical and business teams.
• Ability to work in agile, collaborative environments.
• Valid Class G driver’s licence.

What We Offer You

• Competitive salary, benefits plan, and company pension plan.
• Fantastic culture, team, and energetic work environment.
• Social activities, company sponsored events, and opportunities to give back to our local community.
• Flexible working hours and hybrid working options.
• Coaching and mentoring programs and scholarship programs for family members.
• Opportunities to travel and work across Canada.

TULLOCH is an equal opportunity employer that is committed to acquiring a skilled and diverse workforce. We encourage applications from candidates of all backgrounds, origins, ages, orientations, genders, creeds, and religions. TULLOCH accommodates people with disabilities throughout the recruitment and selection process. TULLOCH is an excellent place to work and we look forward to meeting with you! If contacted regarding this competition, please advise the interview coordinator of any accommodation measures you may require.