Snowflake Architect

2 weeks 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

    8 hours ago

    noida, India Coforge Full time

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

  • Snowflake Architect

    5 days ago

    noida, India Coforge Ltd. Full time

    POSITION: Snowflake Architect LOCATION: Gr. Noida & Bangalore DURATION: Full Time   MUST HAVE SKILLS: 1: Snowflake 2: Datawarehouse Concepts 3: Azure Cloud 4: Data Pipelines and ETL/ELT pipelines JOB DESCRIPTION: Strong experience in building data warehouse, data lake, and data mart end-to-end implementation experience focusing on large enterprise...

  • Snowflake Architect

    3 days ago

    Greater Noida, Uttar Pradesh, India Coforge Full time

    Job Description POSITION: Snowflake Architect LOCATION: Gr. Noida & Bangalore DURATION: Full Time MUST HAVE SKILLS: 1: Snowflake 2: Datawarehouse Concepts 3: Azure Cloud 4: Data Pipelines and ETL/ELT pipelines JOB DESCRIPTION: Strong experience in building data warehouse, data lake, and data mart end-to-end implementation experience...

  • Snowflake Architect

    2 weeks 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 Data Architect

    4 days ago

    Noida, Uttar Pradesh, India Coforge Full time

    Job Description POSITION: Snowflake Data 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 Data Architect

    4 weeks ago

    noida, India Coforge Full time

    Job Description POSITION: Snowflake Data 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,...

  • Snowflake Architect

    4 days ago

    Noida, Uttar Pradesh, India Media 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...

  • Snowflake Architect

    2 months 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...

  • Snowflake Architect

    3 weeks 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...

  • Snowflake Architect

    2 months 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...

  • Snowflake Data Architect

    1 month ago

    Greater Noida, India Coforge Full time

    Job Description POSITION: Snowflake Data 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...

  • Snowflake Architect

    1 day ago

    Noida, India Iris Software Inc. Full time

    Position DescriptionThe Data & Analytics Practitioner role is an opportunity to be part of the technology practices at Iris. The candidate will also have the opportunity to collaborate with Client Partners at Iris to engage with Iris clients with practice presentations and technology solutions on Data & Analytics. The successful candidate will have the...

  • Snowflake Architect

    2 days ago

    noida, India Iris Software Inc. Full time

    Position Description The Data & Analytics Practitioner role is an opportunity to be part of the technology practices at Iris. The candidate will also have the opportunity to collaborate with Client Partners at Iris to engage with Iris clients with practice presentations and technology solutions on Data & Analytics. The successful candidate will have the...

  • Snowflake Architect

    2 days ago

    Noida, India Iris Software Inc. Full time

    Position DescriptionThe Data & Analytics Practitioner role is an opportunity to be part of the technology practices at Iris. The candidate will also have the opportunity to collaborate with Client Partners at Iris to engage with Iris clients with practice presentations and technology solutions on Data & Analytics. The successful candidate will have the...

  • Snowflake Lead

    3 days ago

    Noida, Uttar Pradesh, 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 & Responsibilities :...

  • Data Engineer

    2 months 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

    2 months 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

    2 months 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

    2 weeks 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

    3 weeks 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...