EY GDS Consulting AI and DATA AWS and Snowflake Data Platform Architect Manager

EY GDS Manager - AWS Cloud Services and Snowflake Data Platform

As part of our EY-GDS D&A (Data and Analytics) team we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking Insurance Manufacturing Healthcare Retail Manufacturing and Auto Supply Chain and Finance.

The opportunity

Were looking for Managers (Solution Architects) with strong technology and data understanding having proven delivery capability. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.

Your key responsibilities

• Lead and manage a team of data professionals providing guidance mentorship and support in their professional development.
• Design implement and optimize data solutions using AWS cloud services and the Snowflake Data Platform.
• Oversee the integration of various data sources into Snowflake ensuring seamless data ingestion and accessibility.
• Manage data transformation processes within Snowflake utilizing best practices for data cleansing enrichment and preparation.
• Develop and maintain robust data models in Snowflake to support analytical and reporting needs.
• Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions.
• Monitor and manage cloud infrastructure ensuring optimal performance security and cost-effectiveness.
• Stay up-to-date with industry trends and best practices in cloud computing and data management.
• Establish and enforce data governance policies and practices to ensure data quality and compliance.
• Prepare and present reports and dashboards to stakeholders providing insights and recommendations based on data analysis.

Skills and attributes for success

• Strong understanding of Cloud Ecosystem components and underlying cloud architectural concepts including distributed computing paradigms.
• Hands-on experience designing and implementing AWS cloud infrastructure at scale leveraging services such as Glue Lambda S3 SNS and EventBridge.
• Proficiency in scripting languages like Python or Bash for automating cloud operations ETL workflows and Snowflake tasks.
• Expertise in Snowflake Data Platform including:
  • Data modelling and Governance schema design and query optimization.
  • Implementing Snowflake best practices for performance tuning cost optimization and security.
  • Managing Snowflake features such as Virtual Warehouses Streams Tasks Masking and Time Travel.
• Strong understanding of ETL/ELT methodologies with experience integrating diverse data sources into Snowflake.
• Understanding of Iceberg tables Data Catalog Data loading options along with storage formats like Parquet ORC and AVRO for efficient querying and compression in Snowflake and AWS environments is a plus.
• Working knowledge of CI/CD pipelines and DevOps practices using tools like Terraform CloudFormation or AWS CDK for infrastructure as code.
• Experience in developing APIs and integrating distributed systems in cloud environments.
• Knowledge of data governance security frameworks IAM policies encryption and compliance best practices for both AWS and Snowflake.
• Analytical mindset with strong troubleshooting and performance tuning capabilities for cloud and Snowflake workloads.
• Ability to translate business problems into secure scalable and high-performance technical solutions.
• Strong stakeholder client team process and delivery management skills.

To qualify for the role you must have

• Bachelors degree in computer science Information Technology Data Science or a related field; masters degree preferred.
• Relevant experience (7 years) with a focus on AWS cloud services and the Snowflake Data Platform
• Minimum 10 years industry experience.
• Strong understanding of cloud architecture data warehousing and data integration techniques.
• Proficiency in SQL and experience with data modelling ETL processes and data transformation within Snowflake.
• Develop and present demonstrations prototypes and PoCs to showcase the value and capabilities of the proposed solutions.
• Lead the technical aspects of project delivery ensuring that implementations align with the initial solution design.
• Proven experience with Snowflake data platform migration is a plus.
• Excellent leadership communication and interpersonal skills.
• Ability to work collaboratively in a fast-paced environment and manage multiple projects simultaneously.
• Relevant certifications in AWS (e.g. AWS Certified Solutions Architect) and Snowflake are a plus.

Ideally youll also have

• Project management skills
• Client management skills
• Solutioning skills

What we look for

• People with technical experience and enthusiasm to learn new things in this fast-moving environment

What working at EY offers

At EY were dedicated to helping our clients from startups to Fortune 500 companies and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus we offer:

• Support coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way thats right for you