Data Specialist jobs in Canada

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

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

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.

In the Assurance Digital and Innovation team, you will be joined by a team of multidisciplinary professionals in versatile roles, which includes data analytics, programming, automation, and data visualization. You will experience ongoing professional development through diverse experiences, world-class learning and individually tailored coaching. That’s how we develop outstanding leaders who team to deliver on our promises to all of our stakeholders, and in so doing, play a critical role in building a better working world for our people, for our clients and for our communities.

Your Key Responsibilities

• Work within our Assurance Digital and Innovation team to design and develop complex Power BI reports, following industry standards
• Export, transform, validate, and output large and complex data sets for use in reports
• Collaborating with EY teams and clients to understand the relevant business problems and data needs to develop reports
• Ensure all solutions comply with the highest levels of security, privacy and data governance requirements
• Work on and manage mid-size projects, and ensure smooth service delivery on assigned products and engagements
• Maintain and develop positive, productive, and professional relationships with clients and stakeholders

Skills and attributes for success

• 3+ years of professional experience with dashboards and data visualization using Microsoft Power BI, including data model design. Deep understanding of writing SQL, and DAX functions
• Strong understanding of BI best practices, analysis, visualization, and latest BI trends
• Solid working knowledge of report and dashboard design and development tools and techniques
• Curiosity to learn the business methodology, data model and user personas.
• Experience following DevOps best practices, such as unit testing, branching, builds, deployment, regression testing, etc.
• The ability to provide excellent client service and manage and build strong relationships both internally and externally, coupled with a strong interest in further developing and integrating operations with technology skills

To qualify for the role you must have:

• An undergraduate degree in computer science, computer engineering, business or accounting, or another related field
• A minimum of three years’ work experience, with preference for experience at a Big 4, or top tier consulting firm with data analytics services, or a similar transformation change role
• A basic understanding of financial or accounting terminology
• Strong interest in BI design, data analytics, data transformation
• Strong project management and organizational skills with an ability to multitask
• Excellent communication skills with an ability to explain technical terms to a non-technical audience
• A critical and logical thinker who is able to work both independently and in a team environment
• Process driven individual with a strong attention to detail

We are seeking a Senior Consultant or Manager - Data Architect for our AI & Data practice team. We are looking for a candidate with strong technical leadership background, hands experience with Azure, Microsoft Fabric, Data Bricks, Pursuits, proposal and delivery.

Skills and attributes for success

• The ability to provide excellent client service and manage and build strong relationships both internally and externally, coupled with a strong interest in further developing and integrating operations with technology skills
• Provide architecture leadership & subject matter expertise to client engagements focusing on complex & innovative products and reusable assets
• Develop solution plans, prior to kicking off a project as part of a product life cycle, intended to support business investment decisions which means they must hold the appropriate balance between costs, risks and quality of the product
• Create innovative and practical designs that account for the end-to-end technical solution of a system, in line with the business strategy and objectives and within the context of EY's technology environment
• Work closely and continuously with the business/client to focus on meeting business/client requirements and incorporating broader aspects such as overall product costs/revenue, data privacy & sovereignty, business continuity, information security, integration with other systems etc.
• Identify, define and implementing reusable assets and standards. The data architect is also responsible for adherence to these standards and consumption of reusable assets across products and portfolios
• Ensure relevant technical strategies, policies, standards, and practices are applied correctly across Technology programs/projects and products
• Contribute to the development of architecture governance structures, methodologies, and compliance activities
• Work with the vendors to assess vendor products, understand vendor's delivery models and assist in implementing them at EY
• Ability to work across multiple projects with varied stakeholders. A Data Architect sets architectural direction, builds consensus, mediates conflicts providing technical leadership and advisory services to the business. He/she anticipates needs and potential objections and helps to create an environment which solicits positive contributions from all participants: Data and Technical Architects, engineering teams, product manager, project managers, product analysts, test and project teams, Information Security and Operations
• Demonstrate excellent interpersonal communication and organizational skills that are required to operate as a leading member of global, distributed teams that deliver quality services and solutions.
• Cultivate lasting relationships across business, IT and vendors / industry analysts to maintain insight into the broader enterprise as well as industry trends
• Recognizes industry technology trends and emerging technologies, understands how they apply to EY and can drive their adoption into our organization
• Evangelizes and encourages the importance of technical quality, emerging technologies, sharing & experimentation across the org through mentoring, hackathons, communities etc.
• Drives an ongoing communication plan to educate stakeholders on the purpose and benefits of data architecture
• Guide others in resolving complex issues in data architecture and solves complex, escalated aspects of a project
• Monitor the progress and the quality of the project and reviews and develops due diligence to confirm the developed solution complies with architectural design

To qualify for the role, you must have

• Bachelor’s degree in computer science, mathematics, data science, informatics, operations research, engineering, or a related field
• Awareness of emerging issues, including regulations, industry practices and new technologies
• Data Platform experience
• Microsoft Azure
• Data Modelling skills
• Databricks
• Data Engineering

Ideally, you’ll also have

• Interest in Data Analytics along with experience in programming is a highly desired. You will need to demonstrate strong technical problem-solving abilities
• Cloud infrastructure
• Microsoft Fabric
• Unity Catalog
• Data Bricks assets Bundles (DAB)
• CI/CD
• Data Migration
• 5+ years of experience in the field

What we offer

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

In the lab, you will be joined by a team of multidisciplinary professionals in versatile roles, which includes data analytics, programming, automation, and data visualization. You will experience ongoing professional development through diverse experiences, world-class learning and individually tailored coaching. That’s how we develop outstanding leaders who team to deliver on our promises to all of our stakeholders, and in so doing, play a critical role in building a better working world for our people, for our clients and for our communities.

Your key responsibilities

• Work within our Assurance Digital team to export, transform, validate, and output large and complex data sets for use in EY’s data analytics tools
• Work and build strong relationships with EY audit teams while co-developing a robust and repeatable data analytics delivery process
• Proactively monitor, manage, and execute projects with engagement teams
• Collaborate with the data analytics and engagement teams to design and implement improvements to the data delivery process

Skills and attributes for success

• An undergraduate degree in business or accounting with a minor in computer science, computer science, computer engineering, data analysis, financial mathematics or another related field
• A minimum of two years’ work experience
• A basic understanding of a company’s financial reporting process and financial terms
• Strong interest in data analytics, data transformation, robotics process automation, and finance or accounting
• Strong project management and organizational skills with an ability to multitask
• Excellent communication skills with an ability to explain technical terms to a non-technical audience
• A critical and logical thinker who is able to work both independently and in a team environment
• Process driven individual with a strong attention to detail
• This role involves interaction with clients operating nationally and globally where fluency in French and English is required. Bilingualism in both French and English is therefore a requirement of this role.

This position is fully on-site and requires the individual to work from the Toronto office

Your key responsibilities

• Prepare, and build production files for print and digital output, conduct quality checks on printed materials ensuring accuracy and compliance with EY branding and formatting standards
• Manage the end-to-end process of print jobs, from initial intake to final delivery, while upholding high standards of quality and ensuring timely completion at every stage.
• Provide scanning services to clients as needed
• Seek opportunities for efficiency improvements
• Operate and maintain production equipment such as printers, cutters, and laminators
• Manage inventory levels of print supplies and materials ensuring that stock is maintained and reordered are places as necessary
• Interact with internal clients in person, and via email to capture specifications and expedite work orders
• Respond to walk-in requests and coordinate timely pick-up of completed jobs
• Troubleshoot basic printing and scanning issues and maintain a clean, and organised print shop environment
• Adhere to all safety protocols and guidelines to ensure a safe working environment
• Perform physical tasks such as lifting print materials and standing for extended periods
• Support with other occasional duties as assigned

Ideally, you’ll also

• Exhibit strong attention to detail and a commitment to quality control
• Be comfortable working in a production environment with moderate noise and physical activity
• Familiarity with print environments, production workflows, and volume-based operations is considered a strong asset

What we look for

• 1-3 years of experience in printing and document production, administrative support, or customer service
• Strong organisational skills with the ability to manage a high volume of requests and multitask efficiently in a fast-paced environment
• Superior customer service skills, both verbal and written
• Self-starter with the ability to work independently

Your key responsibilities

• Develop & Deploy AI Solutions: Design, build, and optimize advanced machine learning pipelines for a variety of enterprise and research applications, leveraging best-in-class programming, frameworks, and cloud platforms.
• LLM Application Engineering: Implement, fine-tune, and evaluate large language model (LLM) solutions for diverse use cases, including generative AI, natural language processing, and retrieval-augmented generation.
• Research Integration: Translate cutting-edge academic research into practical, scalable AI solutions aligned with EY’s business objectives and innovation agenda.
• Model Evaluation & ML Ops: Support the end-to-end model lifecycle from ideation, training, and validation through deployment and monitoring, applying ML Ops best practices for operational excellence.
• Collaboration & Stakeholder Engagement: Work closely with data scientists, engineers, business stakeholders, and product teams to deliver robust, scalable, and ethical solutions.
• Documentation & Communication: Clearly communicate technical results, methodologies, and insights to both technical and non-technical audiences; contribute to research publications and internal knowledge sharing.
• Continuous Learning: Stay current with the latest advancements in AI/ML, tools, and frameworks; actively contribute to a culture of innovation and excellence within the AI COE.
• Champion Responsible AI: Uphold EY’s standards for ethical, equitable, and transparent AI, ensuring compliance with legal and security guidelines.

Skills and attributes for success

• Education: PhD or Master’s degree in Data Science, Computer Science, Artificial Intelligence, Machine Learning or a closely related field.
• Experience: 4–6 years of hands-on experience delivering impactful AI/ML solutions, ideally in enterprise or research settings.
• Technical Proficiency: Proficient with Python and deep learning frameworks (PyTorch and/or TensorFlow); expertise in data wrangling, feature engineering, and ML pipeline automation.
• GenAI & LLM: Experience with large language model architectures, generative AI use cases, and model fine-tuning and deployment.
• ML Ops & Cloud: Familiarity with ML lifecycle management, ML Ops concepts, and deployment on Azure ML or equivalent cloud platforms.
• Collaboration: Strong team orientation with the ability to work effectively in diverse, cross-functional environments.
• Communication: Excellent written and verbal communication skills; able to articulate complex technical concepts to diverse audiences and contribute to research outputs.
• Problem-Solving: Analytical thinker with a track record of innovative solutions to complex technical challenges.

Your key responsibilities

• Lead data migration and conversion projects for SAP implementations, ensuring adherence to best practices and methodologies.
• Collaborate with business stakeholders to understand data requirements and develop comprehensive data migration strategies.
• Analyze, cleanse, and validate data from legacy systems to ensure accuracy and completeness before migration.
• Design and execute data mapping and transformation processes to align with SAP data structures.
• Monitor and report on the progress of data migration activities, identifying and mitigating risks as necessary.
• Work closely with technical teams to troubleshoot and resolve data-related issues during the migration process.
• Develop and maintain documentation related to data migration processes, including mapping documents, data quality reports, and project plans.
• Provide training and support to team members and stakeholders on data migration best practices and tools.

To qualify for the role you must have

• Bachelor’s degree in information technology, Computer Science, Finance, or a related field; MBA preferred.
• Minimum of 7+ years of experience in SAP data migration and conversion and must be a Lead or a Manager or equivalent in their current role.
• Strong understanding of financial data processes, regulations, and compliance requirements.
• Proficiency in SAP data migration tools/ data load methods/ ETL Tools and methodologies (e.g., LSMW, BODS, LTMC, SAP Data Services).
• Experience in data management including leading the data migration execution (cleansing, extracting, staging, transforming, loading, and verification of SAP data), running mock loads and data verification/validation cycles, resolving data defects, providing expertise and implementing processes for data governance, etc.
• Experience in data management including leading the data migration execution (cleansing, extracting, staging, transforming, loading, and verification of SAP data), running mock loads and data verification/validation cycles, resolving data defects, providing expertise and implementing processes for data governance, etc.
• Understanding of leading practices for data governance approach, centre of excellence/shared services structures, data governance processes/procedures (experience implementing shared services)
• Experience facilitating cross-functional team members with complex schedules against a published plan
• Team lead expertise – stream planning, status reporting, escalating risks/issues/decisions/changes, budget management, etc.
• Experience leading clients through new data concepts (Data Stewards, Data Governance, Mock Loads, Data Object Master, Data Owners, etc.)
• Excellent analytical, problem-solving, and communication skills.
• Ability to work collaboratively in a team environment and manage multiple projects simultaneously.
• SAP certification(s) related to data management is a plus.
• Travel is estimated to be 0-50%

Skills and attributes for success

• Effectively manage diverse skills and backgrounds and foster an innovative and inclusive team-oriented work environment.
• Strong written and verbal communication, presentation, client service and technical writing skills, coupled with a strong interest in further developing and integrating enterprise domain knowledge with technology skills.
• Demonstrate characteristics of a forward thinker and self-starter that thrives on new challenges and adapts quickly to learning new knowledge.
• Ability to lead a team of consulting and client professionals on multiple projects.
• Being a leader in our EY SAP practice mentoring our team members through career coaching
• A strong work ethics.

What we offer

When you thrive, we thrive. The EY benefits package goes above and beyond, focusing on your physical, emotional, financial and social well-being:

• $5,000 per year for mental health support benefits
• Wellbeing benefit of $1,200/year

Discover how, when and where you can work at

BC & Ontario Region Pay Information (only if role is being published in BC)

British Columbia Salary Clause: The salary range for this job in British Columbia is $90,000 to $165,000. Individual salaries within this range are determined through a wide variety of factors including but not limited to education, experience, knowledge, skills and work location city.