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
