Remote Senior Data & AI Solutions Architect

Cambay Solutions LLC; Northern (KY); Hybrid; USD 150,000 - 200,000; Full time

Job summary

Cambay Solutions is seeking a Data & AI Solution Architect to lead enterprise-scale data, analytics, and AI initiatives. You will translate complex business challenges into scalable, secure solutions using Microsoft Azure, Fabric, Power BI, and Azure OpenAI.

The role requires deep technical leadership across data lakes, warehouses, and real-time analytics, with a focus on governance, security, and compliant architectures in diverse industries.

Qualifications

• Minimum 12 years of experience in Data, Analytics, Cloud, or Enterprise Technology solutions.
• At least 7 years of experience in Solution Architecture roles.
• Strong experience with Microsoft Fabric, Azure Synapse Analytics, Azure Data Factory, Azure Databricks, Azure SQL, and Power BI.
• Proven experience designing enterprise data warehouses, data lakes, lakehouse architectures, and modern analytics platforms.
• Hands-on experience with Azure OpenAI, Azure AI Services, Machine Learning, and Generative AI solutions.
• Strong understanding of data modeling, ETL/ELT frameworks, data integration, and data architecture best practices.
• Experience with data governance, metadata management, security, compliance, and Microsoft Purview.
• Knowledge of cloud architecture principles, networking, identity management, and enterprise security.
• Strong communication, leadership, stakeholder management, and consulting skills.
• Experience leading enterprise-scale digital transformation and data modernization initiatives.

Responsibilities

• Lead the architecture and design of enterprise Data & AI solutions from strategy through implementation.
• Architect scalable data lake, lakehouse, data warehouse, and real-time analytics solutions.
• Design and implement enterprise reporting and business intelligence solutions using Power BI.
• Lead AI and Generative AI solution architecture utilizing Azure OpenAI, Azure AI Services, Copilot technologies, and Machine Learning platforms.
• Define data governance, security, compliance, privacy, and data quality frameworks.
• Architect data integration, ETL/ELT pipelines, master data management, and enterprise data strategies.
• Lead technical discovery workshops and translate business requirements into architecture roadmaps and implementation plans.
• Develop architecture blueprints, solution designs, technical documentation, and deployment strategies.
• Collaborate with business stakeholders, data engineers, data scientists, developers, and project teams to ensure successful solution delivery.
• Establish best practices for scalability, performance, security, reliability, and operational excellence.
• Support solution reviews, architecture governance, and technical quality assurance activities.
• Mentor technical teams and contribute to reusable accelerators, frameworks, and delivery methodologies.
• Stay current with Microsoft’s Data & AI ecosystem, emerging technologies, and industry best practices.

Skills

Azure

Power BI

Data modeling

ETL/ELT

Data governance

Leadership

Stakeholder mgmt

Machine Learning

Azure OpenAI

Azure Synapse

Azure Databricks

Microsoft Fabric

Purview

Education

Azure Solutions Architect Expert (AZ-305)

Tools

Azure Data Factory

Azure Synapse Analytics

Azure Databricks

Power BI

Microsoft Fabric

Purview

Copilot technologies

Job description

Cambay Solutions is seeking a Data & AI Solution Architect to lead enterprise-scale data, analytics, and AI initiatives. You will translate complex business challenges into scalable, secure solutions using Microsoft Azure, Fabric, Power BI, and Azure OpenAI.

The role requires deep technical leadership across data lakes, warehouses, and real-time analytics, with a focus on governance, security, and compliant architectures in diverse industries.