Senior AI & Data Architect

Meritore Technologies is seeking a Senior AI & Data Architect to lead the design and implementation of AI-enabled data solutions within its Modern Data Solutions platform. The role focuses on Agentic AI, Snowflake AI/Cortex capabilities, secure and governed AI architecture, AI-integrated data pipelines, and technical guidance for data engineering teams.

Responsibilities:

• Define and maintain AI architecture patterns and reference designs for AI-enabled data solutions within the Modern Data Solutions ecosystem
• Lead the design and implementation of Agentic AI solutions, including multi-agent orchestration, tool-calling frameworks, and autonomous pipeline workflows using Snowflake Cortex Agents
• Architect and deploy Snowflake AI features including Cortex Analyst, Cortex Search, Cortex LLM functions, Snowflake Copilot, and Document AI to enable intelligent data interactions
• Establish AI security patterns and guardrails including prompt injection prevention, data privacy controls, PII redaction, output validation, role-based access to AI features, and responsible AI usage policies
• Design and implement AI-integrated data pipelines using dbt, Fivetran, Snowpark, and Airflow with AI-assisted automation and anomaly detection
• Build and maintain reusable AI prompt templates, code scaffolding, and accelerator patterns that enable data engineering teams to deliver AI-powered pipelines faster
• Enable Copilot and AI-assisted development workflows (e.g., GitHub Copilot, Claude, Cowork) integrated with data platform tooling to drive productivity across data teams
• Collaborate with enterprise architecture, security, and platform teams to ensure AI solutions meet governance, compliance, and architectural standards
• Translate business strategy and use cases into AI architectural recommendations — including feasibility assessments, build vs. buy decisions, and roadmap input
• Evaluate and recommend emerging AI tools, LLM providers, vector stores, and AI orchestration frameworks for enterprise applicability
• Act as technical expert and escalation point for AI integration challenges across data platforms, applications, and pipelines
• Provide technical guidance and mentoring on AI solution design, prompt engineering, and responsible AI practices for data engineering team members
• Develop technical documentation, architecture diagrams, and data entity models for AI-enabled solutions
• Participate in Agile sprint planning and contribute to cross-functional delivery of AI data products
• Other duties as assigned by the manager