Snowflake Architect - Noida, India - Media

    Media
    Media Noida, India

    1 week ago

    Default job background
    Description

    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 , regular recognition at Cannes Lions, inclusion in AdExchanger's Programmatic Power Players , the title of Webby Production Company of the Year , 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