Senior Data Engineer - Microsoft Fabric

AspenView Technology Partners specializes in creating high-performing nearshore IT teams to help North American clients innovate faster and more efficiently. The Senior Data Engineer will modernize data integration systems by designing scalable pipelines, migrating workloads to Microsoft Fabric, and integrating enterprise data sources for trusted reporting, analytics, and operational insight in Power BI. The role also involves data modeling, performance optimization, troubleshooting, governance, and collaboration with cross-functional teams.

Responsibilities:

• Build, optimize, and maintain ETL/ELT workflows using ADF, SQL Server Integration Services (SSIS), and Azure Functions
• Migrate pipelines and orchestration layers toward Microsoft Fabric, Fabric Link, and OneLake
• Integrate structured and unstructured sources, including SaaS APIs, Dynamics 365, Dynamics AX, marketing and sales platforms, and financial systems
• Design and validate semantic models for Power BI and Fabric-based reporting
• Implement data quality, lineage, metadata, and governance processes aligned with enterprise standards
• Performance-tune SQL Server databases and Fabric workloads
• Troubleshoot pipeline failures and proactively improve resiliency and observability
• Partner with reporting analysts, business stakeholders, data scientists, and application engineering teams to deliver well-structured, analytics-ready datasets
• Support cross-functional projects linking sales, marketing, and financial data into unified business views
• Holds a point of view and states it, including to senior stakeholders and including after a decision has been made when new evidence warrants reopening it
• Asks why a process, data model, or reporting standard exists before extending it, rather than replicating an incumbent pattern simply because it is the incumbent pattern
• Surfaces risk, ambiguity, and weak requirements at the moment they are noticed — not at the sprint review, and not at go-live
• Works past the assigned ticket proposes better approaches, improves what sits around the work, and leaves the team’s practice stronger than it was found
• Argues from evidence and changes position on evidence. Comfortable being wrong in public, uncomfortable staying quiet

Requirements:

• Bachelor's degree in computer science, Data Engineering, Information Systems, or a related field — or equivalent practical experience
• 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
• Azure Data Factory (ADF) — pipelines, triggers, and integration runtimes
• SQL Server and T-SQL — stored procedures, optimization, and replication
• SSIS — package development and modernization
• REST API and JSON integrations for ingestion and synchronization
• Power BI data modeling — datasets, DAX, and semantic layers
• Azure DevOps for CI/CD pipeline deployment
• Python or .NET for automation and integration tasks
• Familiarity with marketing automation data domains and campaign analytics
• Applicants must be permanently authorized to work in their country of residence and must not require visa sponsorship now or in the future