Azure Data Engineer – Fabric

Data Elephant

. Build and maintain ingestion and orchestration pipelines using Fabric Data Factory and Azure Data Factory .

Posted 9/29/2026full-timeRemote • CanadaMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and maintaining data ingestion and orchestration pipelines using Azure Data Factory and Microsoft Fabric. Proficient in SQL, Python, and PySpark for ETL/ELT transformations, with a strong focus on data quality, performance tuning, and collaboration with stakeholders.

Highest-signal resume keywords

Azure Data FactorySQLPythonPySparkMicrosoft Fabric

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

ETL/ELT TransformationsData ModelingIncremental ProcessingData Quality ChecksPerformance TuningChange Data CaptureDimensional ModelingSchema ManagementAutomated TestingData Integration

Soft Skills

Client CollaborationIndependent WorkCross-Team CollaborationProblem SolvingMentoring

Tools & Technologies

Fabric Data FactoryDataflow Gen2Azure SQLAzure DatabricksPower BIGitCI/CDAzure SynapseMicrosoft PurviewADLS Gen2

Certifications & Qualifications

Microsoft Certified Fabric Data Engineer Associate

Industry Keywords

Data IngestionOrchestration PipelinesMedallion ArchitectureStreaming WorkloadsReal-Time IntelligenceKQLEventstreamsSaaS IntegrationERP IntegrationHistorical Tracking

Tech Stack

Tools & technologies

ApacheAzureERPETLPySparkPythonSparkSQL

About the role

Key responsibilities & impact

Build and maintain ingestion and orchestration pipelines using Fabric Data Factory and Azure Data Factory
Integrate databases, APIs, files, and enterprise applications
Develop ETL/ELT transformations using SQL, Python, PySpark, Fabric notebooks, and Dataflow Gen2
Implement OneLake, Lakehouse, Warehouse, and Delta Lake solutions using medallion architecture where appropriate
Develop full and incremental load patterns, change data capture, parameterized pipelines, and reusable ingestion frameworks
Build dimensional models and curated datasets with analysts and business stakeholders
Implement business rules, historical tracking, and source-to-target mappings
Implement data quality checks, automated tests, reconciliation, and validation
Handle schema changes, duplicate records, missing values, and late-arriving data
Improve pipeline reliability through logging, monitoring, alerts, retries, dependency management, and safe reruns
Troubleshoot failures and document operational runbooks
Use Git and CI/CD to promote changes across environments
Optimize SQL, Spark, and pipeline performance
Implement agreed access controls
Participate in code reviews and mentoring
Work closely with architects, analysts, and clients from source analysis and development through testing, deployment, and production support

Requirements

What you’ll need

Strong experience building and operating production data pipelines, owning complex engineering work through deployment and support
Hands-on experience with Microsoft Fabric, including OneLake, Lakehouse or Warehouse, Fabric Data Factory pipelines, and notebooks
Strong SQL, Python, and PySpark skills
Practical experience processing data in Apache Spark and Delta Lake
Azure experience with Azure Data Factory, ADLS Gen2, and Azure SQL
Experience integrating Azure services with Fabric
Understanding of ETL/ELT, orchestration, incremental processing, data modeling, and structured and semi-structured data
Experience with Git, deployment automation, testing, data quality, monitoring, and performance tuning in production environments
Ability to work directly with clients to clarify requirements, explain issues, and manage dependencies
Ability to work independently and collaborate across delivery teams
Dataflow Gen2 and Power Query experience valued
OneLake shortcuts or mirroring experience valued
Power BI semantic model integration experience valued
Azure Databricks, Azure Synapse, Microsoft Purview, or ERP and SaaS integration experience valued
Streaming workloads, Fabric Real-Time Intelligence, KQL, or Eventstreams experience valued
Microsoft Certified Fabric Data Engineer Associate or other relevant Azure or Microsoft data certifications valued

Benefits

Comp & perks

Opportunities to take ownership and deepen expertise
Learning alongside experienced colleagues
Opportunities to contribute to how the company delivers
Opportunities to help shape a growing consulting practice
Direct client work on meaningful challenges