Senior Fabric Engineer

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
Salary
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
Platform Architecture & Implementation
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
Benefits
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.
Notice To Third Party Agencies
AI2IO does not accept unsolicited resumes from recruiters, employment agencies, or other staffing services. Unsolicited resumes include any resume or hiring document sent to AI2IO in the absence of a signed Service Agreement where AI2IO has expressly requested recruitment/staffing services specific to the position at hand. Any unsolicited resumes, including those submitted to hiring managers or other business leaders, will become the property of AI2IO and AI2IO will have the right to hire that candidate without reservation – no fee or other compensation will be owed or paid to the recruiter, employment agency, or other staffing service.
The Pay Range For This Role Is
120,750 - 148,313 USD per year (Remote (United States))

Work arrangement
Yes