Solutions Architect ( Snowflake)

Please note that we will never request payment or bank account information at any stage of the recruitment process. As we continue to grow our teams, we urge you to be cautious of fraudulent job postings or recruitment activities that misuse our company name and information. Please protect your personal information during any recruitment process. While Monks may contact potential candidates via LinkedIn, all applications must be submitted through our official website (monks.com/careers).

Job Summary:

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-VK1

About Monks

Monks is the global, purely digital, unitary operating brand of S4Capital plc. With a legacy of innovation and specialized expertise, Monks combines an extraordinary range of global marketing and technology services to accelerate business possibilities and redefine how brands and businesses interact with the world. Its integration of systems and workflows delivers unfettered content production, scaled experiences, enterprise-grade technology and data science fueled by AI—managed by the industry’s best and most diverse digital talent—to help the world’s trailblazing companies outmaneuver and outpace their competition.

Monks was named a Contender in The Forrester Wave™: Global Marketing Services. It has remained a constant presence on Adweek’s Fastest Growing lists (2019-23), ranks among Cannes Lions' Top 10 Creative Companies (2022-23) and is the only partner to have been placed in AdExchanger’s Programmatic Power Players list every year (2020-24). In addition to being named Adweek’s first AI Agency of the Year (2023), Monks has been recognized by Business Intelligence in its 2024 Excellence in Artificial Intelligence Awards program in three categories: the Individual category, Organizational Winner in AI Strategic Planning and AI Product for its service Monks.Flow. Monks has also garnered the title of Webby Production Company of the Year (2021-24), won a record number of FWAs and has earned a spot on Newsweek’s Top 100 Global Most Loved Workplaces 2023.

We are an equal-opportunity employer committed to building a respectful and empowering work environment for all people to freely express themselves amongst colleagues who embrace diversity in all respects. Including fresh voices and unique points of view in all aspects of our business not only creates an environment where we can all grow and thrive but also increases our potential to produce work that better represents—and resonates with—the world around us.