Sr. Data Engineer - Toronto, Canada - EY

Description

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:

We are seeking a highly skilled and experienced Senior Data Engineer with demonstrated success delivering complex data integration requirements, to join our dynamic team. In this role, you will play a pivotal part in architecting, developing, and optimizing data integration solutions that drive our client's data-driven decisions. You will collaborate with cross-functional teams to design, implement, and maintain data pipelines that support our client's growing business needs. Strong client-facing and communication skills are essential, as you will engage with clients to understand their requirements and provide technical guidance.

Key Responsibilities:

Data Integration and ETL Development

Design, develop, and maintain complex data integration solutions using third-party technologies including Informatica Intelligent Cloud Services (IICS) and Azure Data Factory (ADF)

Create ETL processes for data extraction, transformation, and loading (ETL) into target storage systems based on batch, micro-batch, or real-time ingestion needs

Architecture and Design

Collaborate with architects and data engineers to design scalable, efficient, and robust data pipelines based on technical best practices

Translate business requirements into technical solutions, ensuring data quality and integrity

Design and deployment of analytical data models

Client Engagement

Interact with clients to understand their data needs and provide technical guidance and solutions

Communicate effectively with non-technical stakeholders to ensure clear project requirements and objectives

Performance Optimization

Identify and resolve performance bottlenecks in data integration processes and recommend best practices for optimization

Data Quality and Governance

Implement data quality checks and data governance principles to maintain high data integrity

Monitor and resolve data issues promptly

Documentation

Create and maintain technical documentation for data integration processes, configurations, and best practices

Continuous Learning and Innovation

Stay updated on industry best practices and emerging technologies related to IICS, ADF, Snowflake and other relevant technologies

Recommend and implement innovative solutions to enhance data processes

Qualifications:

Bachelor's degree in Computer Science, Information Systems, or a related field

Minimum of 10 years of experience in data integration and ETL development

Minimum 5 years of practical, hands-on project experience with Informatica Intelligent Cloud Services (IICS) and Azure Data Factory (ADF); Certifications with Informatica IICS, ADF considered an asset

Demonstrated experience with other ETL platforms considered an asset (e.g., Talend, DBT, DataStage)

Demonstrated experience/knowledge with ingesting data from a broad range of methods including files, APIs, event streaming (e.g., Kafka, Kinesis)

Demonstrated experience with design and implementation of various workloads on the Snowflake Data Cloud platform; SnowPro Core and SnowPro Advanced Architect certifications considered an asset

Proficiency in SQL, Python, or other scripting languages

Knowledge of data modeling, data warehousing, and ETL principles

Demonstrated experience designing and deploying various analytical data modeling methodologies (e.g., Star, Snowflake, Data Vault 2.0)

Strong problem-solving skills and attention to detail

Excellent communication, interpersonal and collaboration skills

Familiarity with cloud services such as Azure, AWS, or GCP

Experience with Agile and traditional SDLC delivery methodologies

Experience working independently, efficiently, and effectively under tight timelines and delivering results by critical deadlines

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, advocating for the 2SLGBT+ community, promoting our Neurodiversity Centre of Excellence and Accessibility initiatives, and are dedicated to amplifying the voices of Indigenous people (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.