Senior Microsoft Fabric Data Engineer - ADF, OneLake

AspenView Technology Partners, Inc.; United States; On-site; USD 140,000 - 190,000; Full time

Job summary

AspenView Technology Partners, Inc. is seeking a Senior Fabric Engineer to lead modernization of our data estate.

You will design and implement scalable data pipelines using ADF, Fabric Link, OneLake, and SQL Server, integrating Dynamics 365/AX, ERP, and marketing data for enterprise reporting in Power BI. You’ll collaborate with stakeholders to shape target architecture, promote data governance, and ensure resilient, observability-driven operations while migrating existing pipelines to the

Qualifications

• 5+ years in data engineering roles with production implementation experience in an Agile environment.
• Microsoft Fabric experience, including Fabric Link, OneLake lakehouse concepts, and medallion architecture patterns.
• Experience with ERP and B2B transaction datasets, specifically Microsoft Dynamics 365 and Dynamics AX.
• Strong understanding of data warehousing concepts: star schemas, slowly changing dimensions, partitioning, and data quality approaches.

Responsibilities

• Build, migrate, and optimize ETL/ELT pipelines using ADF, SSIS, and Azure Functions.
• Migrate pipelines toward Microsoft Fabric, Fabric Link, and OneLake.
• Design semantic models for Power BI and Fabric-based reporting.
• Tune performance of SQL Server databases and Fabric workloads.
• Troubleshoot pipeline failures and improve resiliency and observability.
• Collaborate with analysts, stakeholders, data scientists, and engineering teams to deliver analytics-ready datasets.
• Support cross-functional projects linking ERP, finance, sales, and marketing data into unified views.

Skills

Azure Data Factory

Fabric Link

OneLake

SQL Server

Power BI

REST API

JSON

Python

C# / .NET

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

Azure Functions

Azure DevOps

Job description

AspenView Technology Partners, Inc. is seeking a Senior Fabric Engineer to lead modernization of our data estate.

You will design and implement scalable data pipelines using ADF, Fabric Link, OneLake, and SQL Server, integrating Dynamics 365/AX, ERP, and marketing data for enterprise reporting in Power BI. You’ll collaborate with stakeholders to shape target architecture, promote data governance, and ensure resilient, observability-driven operations while migrating existing pipelines to the