Experience: Sr. Data Architect with 10 – 15 years of work experience.
Location: New York, NY
Role Title – Data Architect
We are seeking an experienced Snowflake Architect with strong Snowflake Cortex AI and agentic-solution experience to lead the architecture and delivery of governed Finance data and AI capabilities. The role will connect Finance business meaning, semantic models and Snowflake data with Cortex Skills, agents, reusable tools and Talk-to-Data experiences. The architect will define scalable solution patterns, guide engineering teams and establish the quality, security, lifecycle and operational controls required for production adoption.
Job Functions/Duties and Responsibilities:
· Define the end-to-end architecture for Snowflake-based Finance data, semantic and AI solutions across reporting, analytics and conversational use cases.
· Design Cortex Skills, Cortex Agents, reusable agent tools, skill packages and governed Talk-to-Data capabilities.
· Architect how AI agents consume approved semantic models, verified queries, metadata, business definitions and Finance context.
· Define logical, dimensional, physical and semantic modelling patterns for Finance domains such as General Ledger, P&L, Revenue and Spend.
· Create reusable design patterns for MTD, QTD, YTD and other dynamic Finance calculations, including the appropriate use of Snowflake Dynamic Tables.
· Guide the implementation of Snowflake data-consumption layers, transformation patterns, data services and APIs supporting dashboards and AI experiences.
· Establish evaluation frameworks using golden question-and-answer sets, regression testing, confidence scoring, abstention and user-feedback loops.
· Define lifecycle controls for semantic assets, Cortex Skills, agents, prompts, tools, metadata and verified queries.
· Embed identity, entitlements, data protection, auditability, prompt-injection controls and responsible-AI requirements into the solution design.
· Define observability for quality, accuracy, latency, usage, drift, failures and operational performance, together with recovery workflows and runbooks.
· Partner with Finance SMEs, Product Owners, data owners, governance teams, security reviewers and engineers to translate business needs into an approved architecture and delivery backlog.
· Provide technical leadership through architecture reviews, design decisions, code reviews, mentoring and resolution of complex performance or integration issues.
· Support production-readiness, knowledge transfer and controlled scale-up of reusable Finance AI capabilities.
Skills Required:
· 10-15 years of overall experience in data architecture, data engineering, data warehousing, analytics or AI solution delivery.
· Strong hands-on architecture and implementation experience on Snowflake, including advanced SQL, data modelling, performance optimisation and secure data consumption.
· Demonstrable experience with Snowflake Cortex, Cortex Skills, agentic AI solutions, LLM applications or conversational analytics.
· Prior delivery experience in the Finance domain, with practical understanding of General Ledger, P&L, Revenue, Spend, financial measures, controls or management reporting.
· Experience integrating semantic models, metadata, verified queries and governed business context into AI or Talk-to-Data solutions.
· Experience designing evaluation, monitoring, confidence, feedback and lifecycle-control patterns for enterprise AI solutions.
Proven ability to lead architecture discussions and work with business, data, security, governance and engineering stakeholders in a regulated environment.
Success Measures :
· Finance AI use cases are grounded on governed Snowflake data, approved semantic definitions and appropriate access controls.
· Cortex Skills and agents meet agreed thresholds for accuracy, confidence, traceability, security and operational readiness.
· Reusable architecture and calculation patterns reduce one-off implementation and improve consistency across Finance use cases.
· Engineering teams receive clear, implementable designs and timely architectural decisions.
· Solutions meet agreed performance, reliability, data-quality, auditability and production-support expectations.
Educational Qualification:
· Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, Data Science or a related discipline.
· SnowPro Advanced: Architect, SnowPro Core or a comparable Snowflake certification is preferred.