Lead AI & Data Architect

Requirements:

• Senior- or principal-level experience in enterprise data architecture and engineering
• Strong hands-on expertise with Microsoft Fabric and Azure architecture
• Advanced SQL, dimensional modeling, data warehousing, and semantic modeling skills
• Experience with Azure AI Foundry or related Azure AI services
• Practical knowledge of RAG, vector search, grounding strategies, and AI agents
• Strong Python development, API integration, and enterprise systems integration experience
• Familiarity with agent tools, function calling, and MCP architecture
• Experience designing secure systems using Microsoft Entra, row-level security, data governance, and access controls
• Ability to make sound architectural decisions and personally build working solutions
• Strong collaboration and technical leadership skills

Responsibilities:

• Architect and modernize enterprise data platforms using Microsoft Fabric, Azure, SQL, lakehouse, and data warehouse technologies
• Design dimensional data models, star and snowflake schemas, semantic layers, and governed enterprise datasets
• Define scalable data ingestion, transformation, integration, and orchestration patterns
• Architect Azure AI Foundry solutions and enterprise AI applications
• Design and implement RAG architectures, vector and search solutions, grounding strategies, and enterprise knowledge retrieval
• Develop AI agent and tool-integration architectures, including MCP where appropriate
• Build Python services, APIs, agents, and integration components
• Establish secure data and AI access patterns using Microsoft Entra, row-level security, governance, and enterprise controls
• Collaborate with SQL developers on data engineering and platform implementation
• Partner with the Power Platform developer on Power Apps, Power Automate, and Copilot Studio integrations
• Translate business requirements into scalable, production-ready architecture and AI solutions
• Set architectural standards and mentor developers while remaining hands-on

Technologies:

• AI
• AI Agents
• API
• Architect
• Azure
• Copilot
• Data Warehouse
• Fabric
• MCP
• Python
• RAG
• SQL
• Security
• Snowflake
• Cloud

More

We are an established, industry-leading renewables company with a large operational footprint and ongoing investment in modernizing our enterprise data platforms, Microsoft ecosystem, and AI capabilities. We are seeking a hands-on Lead AI & Data Architect for a hybrid-scope role combining approximately 65% data and platform architecture with 35% AI engineering. This is a high-impact opportunity to shape our Microsoft Fabric and Azure foundations, build production AI agents and RAG solutions, and influence security, governance, scalability, and our long-term technical direction alongside SQL/data engineering and Power Platform developers. The role may evolve toward greater AI engineering ownership over time. The proposed base salary is $175,000–$210,000 per year. We provide an inclusive work environment and consider qualified candidates without discrimination on protected grounds.

last updated 43 week of 2026