Senior Fabric Engineer

Senior Fabric Engineer

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.

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.

• 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

• 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

• 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

• Performs Other Related Duties as Assigned

• 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

• 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.

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.

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.