Snowflake Solution Architect – AI / Agentic Engineering

Job Summary

We are seeking an experienced Snowflake Solution Architect with 14+ years of experience in Snowflake, AWS Cloud Data Architecture, Oracle data platforms, data warehouse modernization, and AI-driven engineering frameworks.

The candidate will lead the design and governance of the Snowflake-on-AWS target architecture and establish AI-driven agentic engineering frameworks to automate the conversion, migration, validation, testing, and ongoing operations of the existing Oracle ADW, ODI, and OAC ecosystem.

Key Responsibilities

1. Enterprise Data Architecture

• Design and govern scalable Snowflake-on-AWS target architecture.

• Define architecture standards, integration patterns, security, and performance guidelines.

• Establish scalable, secure, and high-performing enterprise data platforms.

2. Data Warehouse Modernization

• Lead migration strategy and modernization of Oracle ADW, ODI, and OAC platforms to Snowflake.

• Define data integration and migration strategies.

• Drive architecture transformation from legacy data warehouse platforms to modern cloud-based data solutions.

3. Agentic Engineering & AI-Driven Automation

• Design and implement AI-driven agentic engineering frameworks.

• Leverage AI agents to automate code conversion, data migration, validation, and testing.

• Establish AI-driven automation for ongoing data platform operations.

• Define frameworks for intelligent automation across enterprise data ecosystems.

4. Architecture Governance

• Lead enterprise architecture reviews.

• Define and enforce technical architecture standards.

• Drive critical architecture decisions and modernization strategies.

• Establish architecture roadmaps aligned with enterprise objectives.

5. Technical Leadership

• Collaborate with Data Engineering, Cloud, BI, and DevOps teams.

• Ensure alignment with enterprise architecture and modernization objectives.

• Provide technical leadership and guidance across cross-functional teams.

• Manage stakeholder expectations and drive architecture initiatives.

Required Skills & Experience

1. Snowflake & AWS Cloud Data Architecture

• 14+ years of experience in Enterprise Data Architecture and Cloud Data Architecture.

• Strong expertise in designing, implementing, and governing Snowflake-on-AWS architectures.

• Experience building scalable, secure, and high-performing enterprise data platforms.

2. Oracle Data Platforms & Modernization

• Strong architectural and hands-on experience with:

  • Oracle Autonomous Data Warehouse (ADW)

  • Oracle Data Integrator (ODI)

  • Oracle Analytics Cloud (OAC)

• Proven experience in legacy data warehouse modernization and migration to Snowflake.

• Expertise in data integration, migration strategy, and architecture transformation.

3. Agentic Engineering & AI-Driven Automation

• Expertise in designing and establishing AI-driven agentic engineering frameworks.

• Experience leveraging AI agents to automate code conversion, migration, data validation, and testing.

• Understanding of AI-driven automation for ongoing data platform operations.

• Ability to define frameworks for intelligent automation across enterprise data ecosystems.

4. Architecture Governance & Technical Leadership

• Experience leading enterprise architecture design and technical governance.

• Strong stakeholder management and cross-functional collaboration skills.

• Ability to define architecture roadmaps, technical standards, and modernization strategies.

Key Mandatory Skills

• Snowflake Architecture

• AWS Cloud Data Architecture

• Oracle ADW

• Oracle Data Integrator (ODI)

• Oracle Analytics Cloud (OAC)

• Data Warehouse Modernization

• Agentic AI Engineering

• AI-Driven Automation

• Architecture Governance

Snowflake Solution Architect – AI / Agentic Engineering1Snowflake,AWS,AI,Oracle Data Integrator,Data Architecture,Snowflake Architecture,AI-DrivenN/AC2CUnited States