Company Description
Wellesley Cove Group (WCG) assists clients in planning and implementing organizational transformations. We specialize in consulting and facilitating shifts in general business practices, strategic innovation efforts, technology implementations, and data analysis initiatives.
Role Description
As a Snowflake Architect, you will be responsible for designing, developing, and optimizing data solutions using the Snowflake platform to enable AI capabilities. You will work closely with cross-functional teams to understand business requirements and translate them into scalable, efficient data architectures that drive strategic business decisions.
Key Responsibilities:
• Architect and design Snowflake-based solutions to meet the specific needs of the business and project requirements.
• Develop and optimize data pipelines and ETL processes to ensure seamless integration and high performance.
• Design and implement scalable data models, including schema design and data partitioning strategies.
• Collaborate with stakeholders to gather and define business requirements, translating them into technical solutions.
• Provide thought leadership in data architecture best practices, including data governance, security, and data quality.
• Lead data migration projects to Snowflake, ensuring minimal disruption and seamless integration.
• Work with data engineering teams to develop and optimize SQL queries, stored procedures, and other database components.
• Establish and enforce best practices for data storage, transformation, and access.
Qualifications:
• 7+ years of experience in data architecture and data engineering, with at least 3 years of hands-on experience with Snowflake.
• Prior work experience at a Big-4 consulting firm (e.g., Deloitte, PwC, EY, KPMG) is required.
• Proven experience in cloud environments such as AWS, Azure, or Google Cloud.
• Extensive knowledge of ETL tools and best practices, including integration with Snowflake.
• Strong proficiency in SQL and database design, with the ability to write complex, optimized queries.
• Experience with data modeling, schema design, and data optimization techniques.
• Familiarity with data governance, data security, and compliance regulations.
• Strong problem-solving skills and the ability to work effectively in a collaborative, agile environment.
• Snowflake certification (e.g., SnowPro Core)