Lead Data Architect
First seen by Alion on Aug 21, 2026.
Position Overview :
Job Title : Lead Data Architect / Principal Fabric & AI Engineer
Experience Level : 810 Years
Location : Hybrid / Remote options available
Department : Data Engineering, Analytics, and AI Solutions
Key Responsibilities :
1. Fabric & Warehousing :
- Architect enterprise-grade analytics solutions utilizing Microsoft Fabric, OneLake, and Delta Lakehouses.
2. Lakehouse & Dataflows :
- Build scalable Lakehouse architectures and design efficient, low-code ETL pipelines using Dataflows Gen2.
3. AI-Enabled App & Report Development (Good to have) :
- Utilize Python and the Rayfin CLI to build agent-friendly, code-first data backends, analytical web apps, and embedded AI data agents directly within the Fabric ecosystem.
4. Data Modeling :
- Model complex enterprise semantic layers, relational systems, and high-performance star schemas.
5. Workspace Administration :
- Manage Power BI workspace governance, multi-environment deployments, capacity planning, and rigorous tenant/row-level security.
6. Modern CI/CD & AI-Assisted Engineering :
- Establish version control and deployment pipelines via GitHub. Integrate GitHub Copilot into daily development workflows to accelerate backend coding, script writing, and DAX optimization.
Required Skills & Qualifications :
- Experience : 810 years in data warehousing, BI development, and building analytics architectures at scale.
- Programming & AI Tools : Advanced proficiency in Python, SQL, and the Rayfin CLI ecosystem for deploying secure AI-driven application backends.
- Development Workflows : Deep experience with GitHub for version control and a strong command of GitHub Copilot for AI-assisted coding and automated code quality workflows.
- Microsoft Fabric & Lakehouse : Comprehensive mastery of Fabric core components, including Lakehouse environments, Delta format, and Dataflows.
- Workspace Governance : Extensive experience managing enterprise Power BI workspace security, sharing permissions, and lifecycle deployments.
- BI Excellence : Expert-level capability in Power BI Desktop/Service and deep performance optimization of DAX and Power Query scripts.
Skills
Data Engineering, Data Architect, Microsoft Fabric, Artificial Intelligence, Data Warehousing, Data Modeling, Python, SQL, Github, Copilot, Business Intelligence