Data Architect with Snowflake & Cortex
2 days ago
New York
Job Title: Data Architect with Snowflake & Cortex Job Location : New York, NY Job Description We are seeking a Data Architect with deep expertise in Snowflake-based data platforms and AI-driven analytics. This role will lead end-to-end data architecture, drive scalable and secure data solutions, and enable advanced analytics and AI/ML use cases leveraging Snowflake Cortex and modern data stack technologies. The ideal candidate will combine strong technical leadership, hands-on architecture skills, and the ability to collaborate with cross-functional business and technical teams. Required Qualifications • 8+ years of experience in data architecture, data engineering, or data platform roles with at least 4 years specifically designing and optimizing solutions on Snowflake, • Deep expertise in Snowflake features including warehouses, resource monitors, zero-copy cloning, Time Travel, data sharing, Snowpark, Tasks/Streams, and security/governance controls, • Strong proficiency in SQL, data modeling (conceptual, logical, physical), ETL/ELT patterns, and cloud data platforms (AWS, Azure, or GCP), • Proven experience designing secure, scalable architectures for analytics, reporting, and machine learning workloads, • Solid understanding of data governance, quality, lineage, and compliance (e.g., GDPR, SOC2, HIPAA if applicable), • Bachelor's or Master's degree in computer science, Information Systems, Engineering, or a related field, or equivalent experience, • Lead end-to-end data architecture and solution design for Snowflake-based data platforms including logical/physical data models, ingestion patterns (batch, streaming, Snowpipe), storage layers (raw, curated, consumption/semantic), and consumption patterns for analytics, BI, and AI/ML, • Design and optimize scalable, high-performance data warehouses, data lakes, and lakehouse architectures on Snowflake focusing on performance tuning, query optimization, cost management, workload/warehouse strategies, and autoscaling, • Architect and implement AI-powered solutions using Snowflake Cortex including Cortex LLM functions, Cortex Search for semantic/vector/RAG capabilities, Cortex Analyst for conversational analytics, Document AI, and integration with external LLMs (e.g., for fine-tuning, agents, and multimodal data processing), • Define and enforce data governance, security, and compliance frameworks including RBAC, row/column access policies, dynamic data masking, encryption, secure data sharing, and private listings, • Design data pipelines integrating with various sources (on-prem, cloud, SaaS) and orchestration tools; implement real-time capabilities using Streams, Tasks, and Snowpark (Python/Scala/Java), • Collaborate with data engineers, analysts, scientists, and business stakeholders to deliver governed, reusable data products that accelerate analytics and AI initiatives, • Provide technical leadership in migrations to Snowflake from legacy systems (e.g., on-prem warehouses, other clouds) and establish reference architectures, patterns, and standards, • Monitor platform health, optimize for cost/performance, and implement disaster recovery, replication, and high-availability strategies, • Hands-on experience with Snowflake Cortex AI capabilities including Cortex Search, Cortex Analyst, LLM functions, vector embeddings, RAG patterns, and building AI agents or applications within Snowflake, • SnowPro Core, Advanced, or Architect certifications, • Experience with modern data stack tools such as dbt, Airflow, Kafka, Spark, Fivetran, Matillion, or similar, • Knowledge of AI/ML workflowsvector databases, semantic search, and integrating structured and unstructured data for generative AI, • Background in Data Vault 2.0, dimensional modeling, or domain-driven design Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law. The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction. These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity. It is not typical for candidates to be hired at or near the top of the posted compensation range. In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws. Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include: • Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave, • Medical, dental, and vision coverage (or provincial healthcare coordination in Canada), • Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada), • Life and disability insurance, • Employee assistance programs Disclaimers Capgemini is an Equal Opportunity Employer encouraging inclusion in the workplace. Capgemini also participates in the Partnership Accreditation in Indigenous Relations (PAIR) program which supports meaningful engagement with Indigenous communities across Canada by promoting fairness, accessibility, inclusion and respect. We value the rich cultural heritage and contributions of Indigenous Peoples and actively work to create a welcoming and respectful environment. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law. This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodation does not pose an undue hardship. Capgemini is committed to providing reasonable accommodation during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact. Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process. Click the following link for more information on your rights as an Applicant in the United States. Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.
Page 20