Ai and Data - Senior - Data Engineer - Toronto and Ottawa

Ernst & Young Advisory Services Sdn Bhd; Toronto; On-site; CAD 80,000 - 120,000; Full time

Job summary

A leading company seeks a Data Engineer to optimize data workflows using Azure Databricks and Snowflake. The successful candidate will design scalable data pipelines and collaborate with teams to build data models. Ideal candidates should possess a strong background in cloud data engineering, programming, and data governance practices.

Benefits

Comprehensive medical and dental coverage

Defined contribution pension plan

Flexible vacation policy

Support and coaching from colleagues

Learning opportunities to develop new skills

Qualifications

• Hands-on expertise in Snowflake, Databricks, and/or Azure required.
• Proficient in SQL, data modeling, and warehousing concepts.
• Experience with machine learning frameworks and big data tools valued.

Responsibilities

• Design, construct, and maintain scalable data pipelines and ETL processes.
• Collaborate with teams to gather requirements and translate business needs.
• Ensure data quality and integrity while troubleshooting issues.

Skills

Data Modeling

Problem Solving

Collaboration

Analytical Skills

Education

Bachelor's or Master's degree in Computer Science, Engineering, Information Systems

Tools

Snowflake

Azure Databricks

Apache Spark

Python

Scala

Java

Job description

Press Tab to Move to Skip to Content Link

Location: Toronto

Other locations: Primary Location Only

Date: May 23, 2025

Requisition ID: 1610521

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

The Azure Databricks Data Engineer will be instrumental in building and maintaining an optimized data ecosystem using Azure Databricks. You will be responsible for developing and managing data pipelines, ensuring data quality, and enabling advanced analytics capabilities. Your role will involve close collaboration with data scientists, analysts, and other stakeholders to deliver data-driven solutions that support the strategic goals of EY.

Your Key Responsibilities

As a Data Engineer, you will:

• Design, construct, and maintain scalable data pipelines and ETL/ELT processes across Snowflake and/or Azure Databricks environments.
• Develop data processing workflows using Databricks Notebooks, Spark SQL, and/or Snowflake SQL.
• Optimize data storage and processing performance to support real-time analytics and business intelligence.
• Collaborate with cross-functional teams to gather requirements and translate business needs into technical specifications.
• Build and maintain data models, data marts, and data warehouses to support analytics and reporting.
• Implement data governance, security, and compliance best practices across cloud data platforms.
• Troubleshoot and resolve data processing issues, ensuring high data quality and integrity.
• Provide technical guidance on platform capabilities and mentor junior data engineers.
• Stay current with the latest features and trends in Snowflake, Databricks, and cloud data engineering.
• Develop and maintain documentation related to data pipeline architecture, development processes, and governance.

Skills and Attributes for Success

• Certifications such as Snowflake SnowPro, Azure Data Engineer Associate, or Azure Data Scientist Associate.
• Experience with BI tools like Power BI, Tableau, or Looker.
• Familiarity with machine learning frameworks, data science concepts, and big data tools.
• Experience with version control systems (e.g., Git) and workflow orchestration tools (e.g., Apache Airflow).
• Understanding of DevOps practices, CI/CD pipelines, and data integration techniques.

To Qualify for the Role, You Must Have

• A Bachelor's or Master’s degree in Computer Science, Engineering, Information Systems, or a related field.
• Proven experience as a Data Engineer with hands-on expertise in Snowflake, Databricks, and/or Azure.
• Strong programming skills in Python, Scala, or Java.
• Proficiency in SQL, data modeling, and data warehousing concepts.
• Knowledge of cloud platforms such as Azure, AWS, or GCP, and their integration with Snowflake.
• Experience with Apache Spark and its integration with Databricks.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work collaboratively in a fast-paced, team-oriented 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.

Select how often (in days) to receive an alert:

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.