Fabric Data Engineer

Arrivia, Inc.; Scottsdale (AZ); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Unlimited PTO

Exclusive employee travel rates

Travel discounts through arrivia

Medical, dental, and vision insurance

401(k) with company participation

Job summary

Arrivia, Inc. seeks an experienced Fabric Data Engineer to own complex data pipelines and drive enterprise-scale data solutions within the Microsoft Fabric ecosystem.

You will migrate on-prem relational data to the cloud, retire legacy warehouses, and set technical standards while mentoring junior engineers. You will partner with analysts, data scientists, and business stakeholders to deliver reliable, well-governed data platforms, leveraging AI tools and ML-assisted methods to accelerate

Qualifications

• 3 to 5 years in data engineering, ETL/ELT development or analytics engineering.

Responsibilities

• Architect and optimize end-to-end pipelines with Fabric Data Factory, Dataflows Gen2, PySpark and Spark SQL notebooks.
• Lead Lakehouse and Warehouse design on Bronze/Silver/Gold pattern and establish best practices.
• Move on-prem relational data to OneLake and retire legacy data-warehouse systems.
• Build real-time streaming pipelines with Fabric Eventstream from Azure Event Hubs, IoT Hub, and custom apps.
• Write optimized SQL and Python, manage incremental loads and SLA monitoring.
• Design pipelines supporting Retrieval-Augmented Generation with embeddings and vector search.
• Champion governance with sensitivity labels, RBAC and cataloging in Microsoft Purview.
• Drive CI/CD with Fabric deployment pipelines and automated testing for data assets.
• Maintain Power BI semantic models for consistent enterprise reporting.
• Mentor Fabric Data Engineer I team members and help lead architectural reviews.

Skills

SQL

PySpark

Python

T-SQL

Spark SQL

Lakehouse

Data Modeling

CI/CD

Mentoring

Leadership

Retrieval-Augmented Generation

Education

Bachelor's degree in a related field

Tools

Microsoft Fabric

Azure Synapse

Databricks

Power BI

Job description

Build the modern data backbone a global travel-rewards business runs on, work hands-on with the newest Microsoft Fabric and AI tooling, and coach the engineers coming up behind you.

About the Role

arrivia is looking for an experienced Fabric Data Engineer to take ownership of complex data pipeline architectures inside the Microsoft Fabric ecosystem. You will design and optimize enterprise-scale data solutions, set the technical standards the team works to, and mentor junior engineers along the way.

This work matters right now. You will help migrate an existing on-premise relational database into our modern cloud environment and play an instrumental role in decommissioning legacy data-warehouse systems. The pace is accelerating, and your pipelines are what let the business rely on accurate, up-to-date reports and dashboards.

Your impact reaches across the company. You will partner with analysts, data scientists, and business stakeholders to turn complex requirements into reliable, performant, well-governed data platforms, and the standards you set will shape how the whole team builds.

It is also a genuinely modern role. At arrivia, we are committed to AI-driven innovation, and you will work alongside the latest AI technologies, using LLMs, Model Context Protocol servers, and AI-assisted tools to accelerate delivery and raise engineering quality. You will also get flexible and hybrid work, certification support, and a clear path to grow into Senior, Lead, and Principal roles.

What You'll Own

• Pipeline architecture: Architect and optimize end-to-end pipelines with Microsoft Fabric Data Factory, Dataflows Gen2, and PySpark and Spark SQL notebooks, built for scale and performance.
• Lakehouse and warehouse design: Lead Lakehouse and Warehouse design on the medallion (Bronze, Silver, Gold) pattern, and set the best practices the team follows.
• Cloud modernization: Help move on-premise relational data into OneLake and retire legacy data-warehouse systems, accelerating the shift to a modern cloud platform.
• Real-time ingestion: Build low-latency streaming pipelines with Fabric Eventstream from sources such as Azure Event Hubs, IoT Hub, and custom applications.
• Performance and reliability: Write highly optimized T-SQL, Spark SQL, and PySpark, and own incremental loads, refresh scheduling, and SLA monitoring so pipelines stay dependable.
• AI-augmented engineering: Design pipelines that support Retrieval-Augmented Generation, including chunking, embeddings, and vector search, and use LLMs and MCP servers to speed up and improve how the team works.
• Data governance: Champion governance through sensitivity labels, role-based access controls, and cataloging in Microsoft Purview.
• CI/CD and engineering standards: Drive CI/CD with Fabric deployment pipelines, Git branching strategies, and automated testing for data assets.
• Trusted reporting layers: Maintain Power BI semantic models where needed, so enterprise reporting stays consistent and accurate.
• Mentorship: Coach Fabric Data Engineer I team members through code reviews, pair programming, and knowledge sharing, and help lead architectural reviews and continuous improvement.

What You'll Bring

• 3 to 5 years in data engineering, ETL and ELT development, or a related analytics engineering role.
• Strong SQL across T-SQL and Spark SQL, and strong Python with PySpark. Working knowledge of Scala is a plus.
• Several years working with Apache Spark and lakehouse data at scale, writing PySpark and Spark SQL notebooks against large datasets, with real performance-tuning experience.
• Solid grounding in lakehouse architecture, data warehousing, dimensional modeling, and data vault methodology.
• Hands-on experience with Microsoft Fabric or a comparable cloud data platform such as Azure Synapse or Databricks.
• Experience with real-time and streaming data at scale, including event-driven architectures and tools like Azure Event Hubs or Kafka.
• Familiarity with vector search, embeddings, and Retrieval-Augmented Generation patterns, plus hands-on use of LLMs and AI-assisted development tools.
• Strong CI/CD habits across Fabric deployment pipelines, Git, and automated testing.
• Demonstrated experience mentoring junior engineers and leading technical initiatives.
• Microsoft Certified: Fabric Data Engineer Associate (DP-700) is highly preferred.
• A bachelor's degree in a related field, or equivalent practical experience.

This role is multi-pronged, so you do not need every item above. Real strength across several of these areas, plus the drive to grow into the rest, goes a long way.

• Unlimited PTO
• Exclusive employee travel rates
• Travel discounts through arrivia programs
• Medical, dental, and vision insurance
• 401(k) with company participation

Who We Are

At arrivia, we power travel loyalty and rewards programs for some of the world's leading brands. Our teams help millions of travelers book memorable experiences while delivering innovative technology and travel solutions to our partners. With a global workforce and a culture built on curiosity, ownership, authenticity, and collaboration, we're creating the future of travel.

Qualifications

Skills

Behaviors

Motivations

Education

Experience

Licenses & Certifications

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.