Senior Agentic AI & Data Architect

Airolabs.ai; Warrenville (IL); On-site; USD 140,000 - 190,000; Full time

Job summary

Airolabs.ai is seeking a Senior Solution Architect to lead strategy, design, and delivery of Agentic AI use-cases for enterprise clients. You will bridge legacy data warehouses with cloud data platforms, guiding workshops and transforming complex problems into robust architectures.

Ideal candidates have 4–5 years in data engineering/architecture, strong Microsoft Copilot and GenAI experience, and deep skills in SQL, Python, and data integration with SAP/Salesforce/Oracle.

Qualifications

• 4–5 years of foundation in enterprise data engineering, data modeling, or data architecture across hybrid environments.
• Experience with SQL Server, Azure SQL, and Azure Synapse.
• Experience with Microsoft Fabric, OneLake, Databricks, and Delta Lake is a plus.
• 4–5 years of experience with Conversational AI, LLMs, and Microsoft Copilot ecosystem.
• Proficiency in Python, PySpark, and SQL for agentic logic and data transformations.
• Experience orchestrating data reading/writing to 3rd party apps (SAP, Salesforce, Oracle) via connectors and API integrations.
• Strong knowledge of API security, model orchestration, and data pipelines.
• Ability to communicate with C-suite and technical teams.

Responsibilities

• Lead technical workshops and translate client problems into production-ready AI solutions.
• Architect end-to-end agentic AI workloads and secure RAG frameworks.
• Engage with client architects, data engineers, and security teams to review architectures.
• Design semantic data layers, schemas, and pipelines across legacy and modern data estate.
• Enable secure integration with external ecosystems via custom connectors and OAuth/API.
• Provide recommendations for AI guardrails, data masking, and responsible AI practices.

Skills

Microsoft Copilot

Generative AI

Data modeling

Technical leadership

Client advisory

Tools

Azure Synapse

Databricks

Power Platform

SQL Server

Python

Job description

Airolabs.ai is seeking a Senior Solution Architect to lead strategy, design, and delivery of Agentic AI use-cases for enterprise clients. You will bridge legacy data warehouses with cloud data platforms, guiding workshops and transforming complex problems into robust architectures.

Ideal candidates have 4–5 years in data engineering/architecture, strong Microsoft Copilot and GenAI experience, and deep skills in SQL, Python, and data integration with SAP/Salesforce/Oracle.