Senior Fabric Engineer - Remote Data Lakehouse Architect

Explore AI2IO; United States; Remote; USD 121,000 - 148,000; Full time

Benefits offered by this job

Choice of comprehensive medical plans

Flex spending accounts (FSA)

Dental and vision plans

401k with company match

PTO including additional paid time off

Job summary

AI2IO seeks a Senior Fabric Engineer to lead the architecture and hands-on build of a next-generation enterprise data platform on Microsoft Fabric. You will design a governed Medallion lakehouse consolidating Deltek Vantagepoint, project performance, HRIS, and financial data for reporting and AI-ready analytics.

The role partners with the BI Director and Data Analyst to model data, build ingestion pipelines, and deliver a scalable, auditable platform with Delta Lake and dimensional modeling.

Qualifications

• Bachelor’s degree in CS, IS, Data Engineering or related field.
• Hands-on experience with Microsoft Fabric and Azure Data Lake.
• Experience building lakehouse platforms and Delta Lake tables.
• Ability to work from ambiguous legacy data sources and deliver a trusted platform.

Responsibilities

• Architect and implement the Medallion lakehouse in Microsoft Fabric.
• Design ingestion pipelines from Deltek Vantagepoint and ERP/HRIS systems.
• Develop dimensional models and auditable fact tables.
• Define CI/CD and deployment standards with Azure DevOps.
• Document pipelines, table schemas, and data lineage.

Skills

Microsoft Fabric

Azure Data Lake

Delta Lake

Medallion architecture

SQL

Power BI

DAX

CI/CD

Azure DevOps

Data ingestion pipelines

Dimensional modeling

Enterprise data warehouse

Education

Bachelor’s degree in Computer Science or related

Tools

Deltek Vantagepoint

Power BI semantic models

Job description

AI2IO seeks a Senior Fabric Engineer to lead the architecture and hands-on build of a next-generation enterprise data platform on Microsoft Fabric. You will design a governed Medallion lakehouse consolidating Deltek Vantagepoint, project performance, HRIS, and financial data for reporting and AI-ready analytics.

The role partners with the BI Director and Data Analyst to model data, build ingestion pipelines, and deliver a scalable, auditable platform with Delta Lake and dimensional modeling.