Arrivia/Fabric Data Engineer II
Arrivia logo

Fabric Data Engineer II

Arrivia
Type
full-time
Work Style
remote
Location
Remote (US)
Posted
November 18, 2026
Application Deadline
December 16, 2026
Compensation
$92,000-$116,000
Description

Overview

  • Department: Data Engineering
  • Reports To: Data Warehouse Manager
  • Work Location: Remote for out-of-state candidates (US); candidates local to Phoenix, AZ work in the office 4 days a week

About the Role

We are seeking an experienced Fabric Data Engineer II to join our Data Engineering team. In this mid-level engineering role, you will build and optimize data pipelines, mentor Engineer I team members, and help shape the team's technical standards within the Microsoft Fabric ecosystem. You'll partner with the Data Warehouse Manager and senior engineers on the design of enterprise data solutions while working with cross-functional stakeholders to deliver reliable, performant, and well-governed data platforms.

What You'll Do

  • Build and optimize end-to-end data pipelines using Microsoft Fabric Data Factory, Dataflows Gen2, and Notebooks (PySpark/Spark SQL), ensuring scalability and performance
  • Implement Lakehouse and Warehouse solutions following medallion (Bronze/Silver/Gold) patterns, and help establish best practices for the team
  • Build and support real-time data ingestion using Fabric Eventstream and Azure Event Hubs as the team's streaming use cases grow
  • Ingest and orchestrate data from a wide variety of sources including REST APIs, databases, flat files, streaming platforms, and cloud storage into OneLake
  • Write highly optimized T-SQL, Spark SQL, and PySpark code for complex data transformations, applying performance tuning techniques such as partitioning, caching, and predicate pushdown
  • Design and maintain semantic models in Power BI, ensuring consistency and accuracy across enterprise reporting layers
  • Develop and enforce incremental load strategies, data refresh scheduling, and SLA monitoring to ensure pipeline reliability
  • Partner with analysts, data scientists, and business stakeholders to translate requirements into robust, scalable engineering solutions
  • Monitor pipeline health, implement automated alerting, and conduct root cause analysis for data quality issues
  • Contribute to pipelines that support Retrieval-Augmented Generation (RAG) and vector search as the team's AI initiatives grow
  • Leverage Large Language Models (LLMs) and Model Context Protocol (MCP) servers to accelerate development workflows, optimize code, generate documentation, and drive AI-augmented engineering practices across the team
  • Maintain and improve technical documentation including data dictionaries, lineage diagrams, architecture decision records, and pipeline runbooks
  • Support data governance by implementing sensitivity labels, role-based access controls, and data cataloging strategies within Microsoft Purview
  • Mentor Fabric Data Engineer I team members through code reviews, pair programming, and knowledge-sharing sessions
  • Follow and help improve CI/CD practices including Fabric deployment pipelines, Git branching strategies, and automated testing for data assets
  • Contribute to sprint planning, architectural reviews, and continuous improvement initiatives within the engineering team
Required Qualifications
  • Bachelor's degree in Computer Science, Data Engineering, Information Systems, or related field (or equivalent experience)
  • 3–5 years in data engineering, ETL/ELT, or analytics engineering
  • Strong SQL (T-SQL and Spark SQL) and Python/PySpark skills; Scala a plus
  • Hands-on experience with Apache Spark on large datasets, including performance tuning
  • Solid understanding of lakehouse architecture, data warehousing, and dimensional modeling
  • Hands-on experience with Microsoft Fabric or comparable platforms (Azure Synapse, Databricks)
  • Experience with AI-assisted development tools (e.g., Claude, GitHub Copilot)
  • CI/CD practices, Git branching strategies, and automated testing for data pipelines
  • Ability to mentor junior engineers, with strong problem-solving and communication skills for both technical and non-technical stakeholders

Strong Plus

  • Microsoft Certified: Fabric Data Engineer Associate (DP-700) or willingness to obtain
  • Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) or willingness to obtain
  • Experience with real-time and streaming data (Azure Event Hubs, Kafka, or similar)
  • Experience with vector search, embeddings, and RAG patterns (Azure AI Search, FAISS, or similar)
  • Familiarity with Data Vault methodology
  • Experience with MCP servers
  • Experience with Fabric deployment pipelines
  • Deep Power BI experience (semantic models, DAX optimization, enterprise-scale reporting)
  • Extensive hands-on Microsoft Fabric experience (workspaces, lakehouses, warehouses, notebooks)
  • Advanced Delta Lake knowledge (time travel, schema evolution, Z-ordering, optimization)
  • Complex orchestration experience with Azure Data Factory or Fabric Data Pipelines
  • Data governance/cataloging experience (Microsoft Purview or similar)
  • REST API integration, webhooks, and large-scale JSON/XML processing
  • Infrastructure-as-code or Fabric API automation experience
  • Agile/Scrum leadership experience (sprint ceremonies, technical planning)
Benefits & Perks
  • Competitive salary
  • Comprehensive health, dental, and vision insurance
  • 401(k) with company match
  • Professional development budget and certification reimbursement
  • Remote for out-of-state candidates (US); candidates local to Phoenix, AZ work in the office 4 days a week
  • Collaborative, learning-oriented team culture
  • Clear career path toward Senior Data Engineer and Lead/Principal roles

We are an equal opportunity employer and value diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other protected status.

Your Application

December 16, 2026

Your application starts with a short challenge.

Challenges
Arrivia logoAbout Arrivia

Founded in 1997 and rebranded in 2020 to reflect several acquisitions and phenomenal growth as a travel technology provider for companies wishing to reimagine their loyalty and rewards programs. Arrivia is now the world's largest stand-alone travel loyalty provider.