Snowflake Architect

1 month ago

noida, India Media.Monks Full time

We are seeking an experienced Snowflake Architect with a minimum of 8 years of experience in the field to join our team. The successful candidate will deeply understand Snowflake's cloud data platform and will be responsible for designing, developing, and maintaining our Snowflake data solutions, emphasizing data modeling techniques and data security and governance. 

Key Responsibilities: 

Design, develop, and maintain Snowflake data solutions to meet business needs. Translate business requirements into technical specifications.  Experience in implementing and managing Snowflake's features, such as Data Sharing, Data Exchange, and Snowpipe.  Demonstrate and communicate the value of Snowflake's new features throughout the engagement, from demo to proof of concept to running workshops, design sessions, and implementation with stakeholders  Apply advanced data modeling techniques such as Star Schema, Snowflake Schema, and Data Vault 2.0 to establish, modify, and optimize the structure of Snowflake Data Warehouses.  Conduct data model reviews with project team members.  Experience in Data Migration from RDBMS and OnPrem to Snowflake cloud data warehouse.  Ensure data security by implementing Snowflake's security features and best practices.  Manage data privacy and ensure compliance with relevant regulations. Develop and implement data governance strategies.  Write complex Snowflake SQL queries and assist others in doing the same. Mentor junior team members, fostering a learning and growth environment. Work closely with data analysts and business analysts to ensure data solutions are reliable, scalable, and efficient.  Utilize DBT (Data Build Tool) in conjunction with Snowflake to maintain and transform data.  Closely collaborate with the Snowflake product team, business analysts, BI developers, and other stakeholders  Sound hands-on to design low-cost, highly scalable, and performance effective end to end solutions in Snowflake  Proficiency in complex SQL, Unix Shell/Python Scripting, performance tuning, and database optimization techniques. Implement cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake and NoSQL environment to build data movement strategy.  Lead in developing project requirements for end-to-end data integration process using ETL for structured, semi-structured, and unstructured data.  Make necessary ongoing updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with the business needs of the environment.  Act as Data domain expert for Snowflake in a collaborative environment to provide a demonstrated understanding of data management best practices and patterns. 

Required Skills & Experience: 

At least 8 years of experience in data architecture, modeling, and ETL development. At least 3 years of hands-on experience with Snowflake.  Strong understanding of Snowflake's architecture, data modeling, internals, and security features.  Proficient in SQL and ability to write complex Snowflake SQL queries. Deep understanding of advanced data modeling techniques like Star Schema, Snowflake Schema, and Data Vault 2.0.  Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, zero-copy clone, time travel, and automating them.  Experience in handling semi-structured data (JSON, XML), and columnar PARQUET using the VARIANT attribute in Snowflake.  Experience in re-clustering the data in Snowflake with a good understanding of Micro-Partitions.  Experience in Migration processes to Snowflake from an on-premises database environment.  Experience in designing and building manual or auto-ingestion data pipelines using Snowpipe.  Experience in Cloud technologies such as AWS – S3, SQS, EC2, Lambda, Redshift, RDS  Design and develop automated monitoring processes on Snowflake using a combination of Python, PySpark, and Bash with SnowSQL.  SnowSQL experience in developing stored procedures and writing queries to analyze and transform data.  Experience with DBT in a Snowflake environment.  Extensive experience with RDBMS like Oracle, SQL Server, MySQL, Strong knowledge and experience in data security, privacy, and governance. Knowledge of reporting/analytic tools like Tableau and Power BI.  Excellent problem-solving skills and attention to detail.  Certified Snowflake cloud data warehouse Architect (Desirable). 

Preferred Skills & Experience: 

Snowflake certification is a plus.  Experience with DBT with Snowflake.  Experience with data visualization tools like Tableau or Power BI.  Knowledge of Agile development methodology. Agile delivery experience. 

Education: 

Bachelor's and Master’s degree in Computer Science, Information Systems, or a related field. An advanced degree is preferred.

#LI-PP1

About Media.Monks:

Media.Monks is the purely digital operating brand of S4Capital plc that connects 8,600+ digital natives across one global team. We are united by a mission to shift industries forward and pave the path towards ambitious outcomes so our clients and our people can realize their full potential for growth. Our unified model combines solutions in media, data, social, platforms, studio, experience, brand and technology services to help our clients continuously reinvent themselves throughout increasingly rapid cycles of disruption. Our efforts to shape culture, build innovative technologies and unlock the future of growth have earned recognition from numerous esteemed panels: we maintain a constant presence on Adweek’s Fastest Growing lists (2019-22), regular recognition at Cannes Lions, inclusion in AdExchanger’s Programmatic Power Players (2020-23), the title of Webby Production Company of the Year (2021-23), a record number of FWAs, and have earned a spot on Newsweek’s Top 100 Global Most Loved Workplaces 2023. Together, these achievements solidify our experience in digital innovation, excellence in craft, and commitment to personal growth.

While we continue to grow our teams, please be mindful of fraudulent job postings and recruiting activities that may use our company name and information. Please be mindful to protect your personal information, especially your national identification number, and bank account information during a recruiting process. While Media.Monks may reach out to potential candidates via LinkedIn, we will always ask applicants to apply through our website () and will never ask for payment or bank account information during the recruitment process.

Disclaimer: 

Responsible for resourcing and implementing security controls for your teams processes and systems

Responsible that all your personnel apply information security in accordance with the established information security policy

  • Snowflake Architect

    2 days ago

    noida, India Coforge Full time

    Job Description POSITION: Snowflake Architect LOCATION: Gr. Noida DURATION: Full Time MUST HAVE SKILLS: 1: Snowflake 2: Datawarehouse Concepts 3: Azure Cloud 4: Data Pipelines and ETL/ELT pipelines 5: Databrick platform or Azure synapse JOB DESCRIPTION: Strong experience in building data warehouse, data...

  • Snowflake Architect

    5 days ago

    Greater Noida, India Coforge Ltd. Full time

    **POSITION: Snowflake Architect** **LOCATION: Gr. Noida** **DURATION: Full Time** **MUST HAVE SKILLS**: 1: Snowflake 2: Datawarehouse Concepts 3: Azure Cloud 4: Data Pipelines and ETL/ELT pipelines 5: Databrick platform or Azure synapse **JOB DESCRIPTION**: - Strong experience in building data warehouse, data lake, and data mart end-to-end...

  • Snowflake Architect

    2 days ago

    Greater Noida, India Coforge Full time

    Job Description POSITION: Snowflake Architect LOCATION: Gr. Noida DURATION: Full Time MUST HAVE SKILLS: 1: Snowflake 2: Datawarehouse Concepts 3: Azure Cloud 4: Data Pipelines and ETL/ELT pipelines 5: Databrick platform or Azure synapse JOB DESCRIPTION: Strong experience in building data warehouse, data lake, and data...

  • Snowflake Architect

    1 month ago

    Noida, India Media.Monks Full time

    We are seeking an experienced Snowflake Architect with a minimum of 8 years of experience in the field to join our team. The successful candidate will deeply understand Snowflake's cloud data platform and will be responsible for designing, developing, and maintaining our Snowflake data solutions, emphasizing data modeling techniques and data security and...

  • Samta - Data Architect - Snowflake DB

    2 weeks ago

    Noida/Nagpur, India SAMTA INFOTECH PRIVATE LIMITED Full time

    Position : Data Architect (Snowflake)Experience : 3 - 7 years Location : Noida/Nagpur Job Responsibilities : Designing and implementing data architecture : - Work with business stakeholders to understand the data requirements and design a data architecture accordingly. - Determine the data storage and processing requirements, design data models, and...

  • Snowflake Lead

    2 weeks ago

    Noida, India Awign Full time

    About the Role : Duration : 6 months (possible extension upto 2 year). Location : Noida / Bengaluru / Hyderabad. Timings : Full Time (As per company timings). Notice Period : Immediate Joiner Required. Job Description :At least 8-10 years of experience in Cloud Data warehousing with minimum of 4 years of experience in snowflake platform. Roles &...

  • Data Engineer

    1 month ago

    Noida, India Cyber Group India Private Limited Full time

    Required Experience : - 5+ years as a hands on Solutions Architect and/or Data Engineer designing and implementing data solutions. - Team lead, and/or mentorship of other engineers - Ability to develop end-to-end technical solutions into production and to help ensure performance, security, scalability, and robust data integration. - Programming expertise in...

  • Senior Snowflake Developer

    1 month ago

    noida, India Media.Monks Full time

    A Senior Snowflake Developer with a minimum of 5 years of experience will play a crucial role in designing, developing, and supporting our Snowflake data warehouse solutions. They will be responsible for translating complex business requirements into scalable technical solutions, ensuring data integrity and reliability. This role demands high technical...

  • Senior Snowflake Developer

    1 month ago

    Noida, India Media.Monks Full time

    A Senior Snowflake Developer with a minimum of 5 years of experience will play a crucial role in designing, developing, and supporting our Snowflake data warehouse solutions. They will be responsible for translating complex business requirements into scalable technical solutions, ensuring data integrity and reliability. This role demands high technical...

  • Principal Consultant- Senior Snowflake Data Engineer

    3 weeks ago

    Noida, India Genpact Full time

    Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people –...

  • Snowflake Developer/Lead

    2 weeks ago

    Noida/bengaluru,hydera, India GenZS Recruitment Solutions Full time

    Working mode : Onsite.On 3rd party contractual role.At least 8-10 years of experience in Cloud Data warehousing with minimum of 4 years of experience in snowflake platform.Roles & Responsibilities : Snowflake certifications, such as SnowPro Core Certification (Must have) and SnowPro Advanced Architect Certification, (Good to have) Proficiency in designing...

  • Snowflake+big Data+aws Opening with Mnc IT Giant

    6 days ago

    Noida, India Quadrangle Full time

    We have opening with our MNC client for Snowflake+Big Data skill. Please find the below job description for your reference and reply with your updated CV if keen for the role.Total Exp: 11+ Yrs- Mandatory Skills : Snowflake Exp + Big Data technologies- Location: First Preference - Hyderabad then Bangalore and Noida- Job Description: - 7 years of experience...

  • Snowflake Lead

    2 weeks ago

    Bangalore/Hyderabad/Noida, India Awign Full time

    About the Role : Duration: 6 months (possible extension upto 2 year) Location: Noida / Bengaluru / Hyderabad Timings: Full Time (As per company timings) Notice Period: (Immediate Joiner - Required) Job Description : Snowfake Lead At least 8-10 years of experience in Cloud Data warehousing with minimum of 4 years of experience in snowflake platform Roles...

  • Snowflake Lead

    4 weeks ago

    Bangalore/Anywhere in India/Multiple Locations/Noida/Hyderabad, IN Awign Full time

    About the Role : Duration : 6 months (possible extension upto 2 year). Location : Noida / Bengaluru / Hyderabad. Timings : Full Time (As per company timings). Notice Period : Immediate Joiner Required. Job Description :At least 8-10 years of experience in Cloud Data warehousing with minimum of 4 years of experience in snowflake platform. Roles &...

  • Snowflake Lead

    2 weeks ago

    Bangalore/Anywhere in India/Multiple Locations/Noida/Hyderabad Awign Full time

    About the Role : Duration : 6 months (possible extension upto 2 year). Location : Noida / Bengaluru / Hyderabad. Timings : Full Time (As per company timings). Notice Period : Immediate Joiner Required. Job Description : At least 8-10 years of experience in Cloud Data warehousing with minimum of 4 years of experience in snowflake platform. Roles &...

  • Data Architect

    1 month ago

    noida, India Zenon Analytics Private limited Full time

    Sr. Data Architect / Data Architect Experience: 10+ Years Summary: The Data Architect will design and implement data solutions that support the organization’s strategic business goals. Responsibilities: • Focuses on enterprise-wide data modelling and database design. • Tests, monitors, manage and validate data warehouse activity including data...

  • Cloud Architect

    1 month ago

    Noida, India Techneplus Full time

    **Role: Cloud Architect** **Exp: 10+yrs** **Location: Noida/Bangalore** - Minimum of 5 years of Consulting or client service delivery experience on Amazon AWS (AWS) - Minimum of 10 years of experience in big data, database and data warehouse architecture and delivery - Minimum of 5 years of professional experience in 2 of the following areas: -...

  • Lead Consultant, Database Architect

    2 weeks ago

    Noida, India Genpact Full time

    Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people –...

  • Lead Consultant, Database Architect

    2 weeks ago

    noida, India Genpact Full time

    Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people –...

  • Technical Architect/Senior Technical Architect

    4 weeks ago

    Noida,Bangalore,MP, India Impetus Technologies India Pvt. Ltd Full time

    Job Description : - Relevant degree in computer science, engineering or related field of study and 12+ years of related work experience. - Proficient Technical Architect with experience in design & implementation of applications and solutions on Enterprise, Big Data and Cloud technologies. - Extensive experience in designing technology components for...