Senior Consultant - AI and Data - Snowflake Data Engineer

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.  

The opportunity

As a Snowflake Data Engineer at EY, you will be responsible for designing, developing, and maintaining scalable data pipelines and architectures within the Snowflake Data Cloud. You will work closely with data analysts, data scientists, and other stakeholders to ensure that data solutions are aligned with business requirements and objectives.

 

Your key responsibilities

 

As a Snowflake Data Engineer, you will:

• Design and implement complex data pipelines and ETL processes within Snowflake's cloud data platform.
• Optimize data storage and data processing performance in Snowflake to support real-time analytics and business intelligence.
• Collaborate with cross-functional teams to gather requirements and translate business needs into technical specifications.
• Develop and maintain data models, data marts, and data warehouses to support data analysis and reporting.
• Implement data governance and security best practices within Snowflake environments.
• Troubleshoot and resolve data processing issues, ensuring data quality and integrity.
• Provide technical expertise and guidance on Snowflake features and best practices.
• Keep abreast of the latest Snowflake features and updates, as well as industry trends in cloud data platforms.
• Mentor junior data engineers and contribute to the development of internal data engineering tools and processes.

Skills and attributes for success

• Snowflake SnowPro Certification.
• Experience with BI tools such as Tableau, Looker, or Power BI.
• Familiarity with machine learning and data science concepts.
• Experience with version control systems like Git.

To qualify for the role you must have 

• Bachelor's or Master's degree in Computer Science, Engineering, Information Technology, or a related field.
• Proven experience as a Data Engineer with a strong focus on Snowflake.
• Proficiency in SQL and experience with scripting languages such as Python or Scala.
• Experience with data pipeline and workflow management tools like Apache Airflow.
• Familiarity with data integration tools and techniques.
• Strong understanding of data warehousing concepts and data modeling techniques.
• Knowledge of cloud services, particularly AWS, Azure, or GCP, and their integration with Snowflake.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills to work effectively in a team environment.

What we offer

At EY, our Total Rewards package supports our commitment to creating a leading people culture - built on high-performance teaming - where everyone can achieve their potential and contribute to building a better working world for our people, our clients and our communities. It's one of the many reasons we repeatedly win awards for being a great place to work.

We offer a competitive compensation package where you’ll be rewarded based on your performance and recognized for the value you bring to our business. In addition, our Total Rewards package allows you decide which benefits are right for you and which ones help you create a solid foundation for your future.  Our Total Rewards package includes a comprehensive medical, prescription drug and dental coverage, a defined contribution pension plan, a great vacation policy plus firm paid days that allow you to enjoy longer long weekends throughout the year, statutory holidays and paid personal days (based on province of residence), and a range of exciting programs and benefits designed to support your physical, financial and social well-being. Plus, we offer:

• Support and coaching from some of the most engaging colleagues in the industry
• Learning opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

 

Diversity and Inclusion at EY 

  

Diversity and inclusiveness are at the heart of who we are and how we work. We’re committed to fostering an environment where differences are valued, policies and practices are equitable, and our people feel a sense of belonging. We embrace diversity and are committed to combating systemic racism, advancing gender equity and women in leadership, advocating for the 2SLGBTQIA+ community, promoting our neuroinclusion and accessibility initiatives, and are dedicated to amplifying the voices of Indigenous peoples (First Nations, Inuit, and Métis) nationally as we strive towards reconciliation. Our diverse experiences, abilities, backgrounds, and perspectives make our people unique and help guide us. Because when people feel free to be their authentic selves at work, they bring their best and are empowered to build a better working world. 

  EY | Building a better working world   EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.   Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.   Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.