Snowflake Solution Architect – AI / Agentic Engineering

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. 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.

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