Senior Fabric Engineer

Explore AI2IO; United States; On-site; 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 helps organizations navigate the complex landscape of technology solutions, from foundational IT services and system support to advanced software integration, automation, and cutting-edge AI implementations. Our expertise spans IT infrastructure management, custom software development, seamless system integrations, and optimization of low-code business automation, empowering clients to maximize their existing technology investments.

Join us and be part of a team where your voice matters, your work makes an impact, and your growth is a shared priority.

Position Title

Senior Fabric Engineer

Position Location

Remote – work virtually from anywhere in the United States

AI2IO recognizes salary ranges from job boards do not necessarily reflect our pay ranges. In many instances we out-compete those ranges for well-qualified candidates.

Job Summary

The Senior Fabric Engineer leads the architecture and hands-on build of AI2IO’s next-generation enterprise data platform on Microsoft Fabric. Reporting into the Business Intelligence function, this role is responsible for designing and implementing a governed Medallion (Bronze, Silver, Gold) lakehouse architecture that consolidates data from Deltek Vantagepoint, project performance systems, HRIS, and financial systems into a single, trustworthy foundation for reporting, forecasting, and future AI-enabled analytics.

This is a deeply technical, builder-focused role. The Senior Fabric Engineer partners closely with the Director of Business Intelligence and a Data Analyst to translate validated business definitions and source-system lineage into a well-modeled, performant, and maintainable data platform — including ingestion pipelines, Delta Lake table design, dimensional modeling, and the deployment standards that keep the platform reliable as it scales.

The ideal candidate has hands-on experience standing up or significantly modernizing an enterprise data warehouse on the Microsoft data stack, is comfortable working from imperfect or undocumented legacy source systems, and takes pride in building a platform other people can trust.

Essential Functions

• Design and Build the Fabric Lakehouse: Architect and implement the Medallion (Bronze, Silver, Gold) layer structure in Microsoft Fabric, including Delta Lake table design, partitioning strategy, and performance optimization
• Own Data Ingestion & Integration: Design and build ingestion pipelines from source systems — including Deltek Vantagepoint, Power BI semantic models, project performance data, and financial/HRIS systems — into the Bronze layer, with appropriate error handling and monitoring
• Establish the Dimensional Model: Design and build a proper dimensional (Dim/Fact) model in the Silver/Gold layers that replaces ad hoc, view-on-view logic with clean, conformed dimensions and auditable fact tables
• Set Deployment Standards: Define and implement CI/CD, version control, environment promotion, and release standards for the data platform in partnership with the BI operating model and Azure DevOps backlog

Platform Engineering & Reliability

• Ensure Data Quality at the Source: Build validation, reconciliation, and monitoring into ingestion and transformation pipelines so that data quality issues are caught before they reach reporting layers
• Optimize for Scale and Cost: Monitor and tune Fabric capacity usage, pipeline performance, and storage costs as the platform grows in scope and usage
• Document the Platform: Maintain clear technical documentation of pipeline logic, table schemas, and lineage from source system through to the Gold layer, in support of the broader KPI certification and governance effort

Partnership & Delivery

• Partner with the Data Analyst: Translate validated business requirements, KPI definitions, and source-data findings from the Data Analyst into concrete platform design decisions
• Support Governance: Work with the Director of Business Intelligence and the KPI Governance Council to ensure the platform enforces, rather than works around, agreed-upon metric definitions
• Enable Forecasting & AI Enablement: Build the platform foundation needed to support enterprise revenue and IT forecasting initiatives, and future AI-assisted reporting and data Q&A capabilities

Completion of Assigned Tasks and Deliverables on Time and on Budget

• Performs Other Related Duties as Assigned

Position Requirements

• Strong hands-on experience with Microsoft Fabric, Azure Data Lake, and Delta Lake, including Medallion (Bronze/Silver/Gold) architecture patterns
• Demonstrated experience designing and implementing dimensional (Dim/Fact) data models for enterprise reporting
• Strong SQL skills and experience working with SQL Server, including reading and reverse-engineering complex, layered legacy views
• Experience building and maintaining data ingestion pipelines from ERP, financial, or project-based systems (experience with Deltek Vantagepoint or similar professional services ERP systems is a plus)
• Working knowledge of Power BI semantic models and DAX sufficient to collaborate effectively with BI/analytics stakeholders
• Experience establishing deployment, version control, and release standards for data platforms, ideally using Azure DevOps
• Ability to work independently from ambiguous or incomplete requirements, and to raise data quality or governance concerns proactively
• Strong written and verbal communication skills, with the ability to document technical decisions clearly for a non-engineering audience
• Demonstrated aptitude for learning new technology and adapting to evolving requirements

Travel / Relocation Requirements

• Up to 5%, this may include travel to any or all 50 US states
• Travel is defined as physically leaving home on behalf of business activities including but not limited to client sites, meetings with other employees, meeting for business development purposes, running errands on behalf of the business, attending industry conferences, etc.

Education / Experience Requirements

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related discipline

PLUS

• 5+ years of experience in data engineering or data platform roles, including hands-on experience with Microsoft Fabric, Azure Data Lake, or comparable modern lakehouse platforms
• Experience working on an enterprise data warehouse or BI modernization initiative, ideally within a professional services, project-based, or similarly complex operating environment

AI2IO offers a very competitive benefits package; highlights include

• Choice of comprehensive medical plans (including two PPO-style plans and a HDHP w/ HSA option)
• Flex spending accounts (FSA)
• Dental and vision plans
• Comprehensive medical, dental and vision benefits extended to spouse / domestic partner and dependent children up to age 26
• 401k with company match and self-directed brokerage account option
• PTO including additional paid time off during the last week of the year
• Company paid life insurance coverage for employees and their eligible dependents
• Short and long-term disability, AD&D coverage
• Professional development opportunities, tuition reimbursement and professional licensing assistance
• Paid parental leave after one year of employment

CO, CA, IL, NY, WA, and Washington DC residents only: In accordance with CO, CA, IL, NY, WA, and Washington DC law, the range provided is AI2IO's reasonable estimate of the base compensation for this role. The actual amount may differ based on non-discriminatory factors such as experience, knowledge, skills, abilities, and location.

AI2IO is an EEO/Affirmative Action Employer and participates in the E-Verify program with the Department of Homeland Security. We encourage diversity in our workforce.

The pay range for this role is:

120,750 - 148,313 USD per year (Remote (United States))