Snowflake Data Architect

Join the Ritz-Carlton Yacht Collection:  Where Every Voyage is a Symphony of Luxury Embark on an extraordinary journey with the Ritz-Carlton Yacht Collection, an exquisite extension of the renowned Ritz-Carlton brand, dedicated to redefining ultra-luxury hospitality at sea. As a "Lady or Gentleman" of our esteemed team, you'll be entrusted with the art of delivering the impeccable "Gold Standards" that have made the Ritz-Carlton an epitome of excellence across the globe.   The Essence of Excellence: The Gold Standards The Gold Standards are the bedrock of the Ritz-Carlton experience, setting us apart in the industry and establishing a legacy of unparalleled service. These standards embody the values and culture that define our brand, and serve as the compass guiding our every endeavor.   The Employee Promise At The Ritz-Carlton, our Ladies & Gentlemen are the most important resource in our service commitment to each other and our guests. By applying the principles of trust, honesty, respect, integrity, and commitment, we empower and nurture talent to the benefit of each individual and the company. The Ritz-Carlton fosters a culture where all are valued, quality of life is enhanced, individual aspirations are fulfilled, and The Ritz-Carlton Mystique is strengthened. Join us on a journey where every day is a testament to the highest standard of luxury and service. Apply now and be part of an unparalleled legacy in hospitality. Position: Snowflake Data Architect Location: CABA, Buenos Aires, Argentina Candidate must be within local travel distance to Buenos Aires, Argentina. The role will begin as remote until we find a co-working space in CABA, Buenos Aires. Responsibilities: Design, configure, and maintain Snowflake environments across development, staging, and production. Manage virtual warehouses, resource monitors, and auto-scaling policies to control cost and performance. Administer RBAC, network policies, SSO/SAML integrations, and data masking policies. Monitor platform health, set up alerting, and drive incident response for data availability issues. Plan and execute Snowflake version upgrades and patch cycles. Design and develop efficient SQL queries, stored procedures, tasks, streams, and dynamic tables. Architect and maintain data models (star/snowflake schemas, data vault) within Snowflake. Build and optimize ELT/ETL pipelines using Snowpark (Python/Java/Scala) or partner tools (dbt, Fivetran, Matillion, ADF). Implement Snowflake features including zero-copy cloning, time travel, data sharing, and Marketplace integrations. Develop and maintain Snowflake Native Apps or Streamlit in Snowflake dashboards where required. Conduct query profiling and tuning using the Query Profile UI, EXPLAIN plans, and search optimization. Design and manage clustering keys, materialized views, and result cache strategies. Perform regular cost attribution analysis; recommend and implement savings opportunities. Establish…