Data Engineering Expert for Scalable Data Warehousing

1 week ago


Toronto, Ontario, Canada Rubicon Path Full time
Job Description

We are seeking an experienced Data Engineering Expert to join our team at Rubicon Path. As a key member of our data warehousing team, you will be responsible for designing, developing, and maintaining scalable data pipelines using Databricks.

In this role, you will work closely with cross-functional teams to ensure the efficient transformation and movement of data to meet business needs. You will leverage your expertise in ETL tools such as Microsoft SSIS, stored procedures, and T-SQL to design and develop high-quality ETL mappings/scripts/notebooks. Additionally, you will have hands-on experience with CDC tools (e.g., GoldenGate) for managing real-time data and Delta Lake for building data lakes and managing ACID transactions.

The ideal candidate will have 7+ years of experience working with SQL Server, T-SQL, Oracle, PL/SQL development or similar relational databases, and 2+ years of experience working with Azure Data Factory, Databricks, and Python development. Strong knowledge of the Medallion Architecture (Bronze, Silver, Gold) and experience implementing it in production environments is also required.

This role offers a competitive salary range of $140,000 - $180,000 per year, depending on experience, and is based in the United States. We offer a dynamic and collaborative work environment, opportunities for professional growth and development, and a comprehensive benefits package.


  • Data Modeling Expert

    4 weeks ago


    Toronto, Ontario, Canada Tata Consultancy Services Full time

    About the RoleWe are seeking a highly skilled Data Modeling Expert to join our team at Tata Consultancy Services. As a key member of our data modeling team, you will play a crucial role in designing and implementing effective data models that drive business growth and innovation.Key Responsibilities:Collaborate with business stakeholders, data owners, and...

  • Data Engineer

    6 hours ago


    Toronto, Ontario, Canada Capgemini Engineering Full time

    About Capgemini EngineeringCapgemini Engineering is a global leader in engineering and technology consulting. We help organizations accelerate their digital transformation by providing innovative solutions that drive business value.About the JobWe are currently seeking a highly skilled Data Engineer - Large Scale Big Data Infrastructure to join our team. As...

  • Data Engineer Lead

    4 weeks ago


    Toronto, Ontario, Canada Agilus Work Solutions Full time

    We are seeking an experienced Data Engineer to lead the design, optimization and maintenance of scalable data infrastructure at Agilus Work Solutions. As a key member of our innovative team, you will play a crucial role in supporting various data initiatives, including AI and machine learning capabilities.The successful candidate will be responsible for...


  • Toronto, Ontario, Canada Mytechtal Full time

    Discover a rewarding opportunity as a Chief Data Engineering Lead at Mytechtal, where you'll lead the design and implementation of cutting-edge data architectures using Microsoft Fabric.As a key member of our team, you will work closely with clients to understand their business needs and translate them into technical requirements. Your expertise in Microsoft...


  • Toronto, Ontario, Canada University Health Network Full time

    Job Title: Data Engineering Expert for Healthcare Data IntegrationAbout Us: The University Health Network (UHN) is a leading research and teaching hospital in Canada, renowned for its excellence in patient care, research, and education. Our diverse team of healthcare professionals, scientists, and students work together to advance the boundaries of medical...

  • Data Engineer

    1 month ago


    Toronto, Ontario, Ontario, Canada Agilus Work Solutions Full time

    Data Engineer – Term Contract – 16 monthsAgilus’ client is seeking an experienced Data Engineer to join our innovative team on a contract basis for 16 months. In this role you will design, optimize, and maintain scalable data infrastructure that supports various data initiatives, including AI and machine learning (ML) capabilities. You will be...

  • Cloud Data Engineer

    4 weeks ago


    Toronto, Ontario, Canada Tata Consultancy Services Full time

    Job SummaryWe are seeking an experienced Cloud Data Engineer to join our team at Tata Consultancy Services. In this role, you will be responsible for designing and delivering scalable data solutions using cloud-based technologies.About the RoleThe ideal candidate will have a strong background in AWS data engineering and experience working with large volumes...

  • Data Architect Lead

    3 weeks ago


    Toronto, Ontario, Canada Mytechtal Full time

    Senior Data Architect Role OverviewWe are seeking a highly skilled Senior Data Architect to lead the design and implementation of comprehensive data solutions using Microsoft Fabric. The ideal candidate will have extensive experience in architecting scalable and efficient data architectures, with a strong understanding of data modelling, ETL processes, and...

  • Senior Data Engineer

    4 weeks ago


    Greater Toronto Area, Canada, Ontario Altis Labs Full time

    About the jobAbout Altis LabsAltis Labs is the computational imaging company accelerating clinical trials with AI. We are on a mission to help get the most effective novel treatments to patients sooner. Simplistic imaging interpretation methods like RECIST 1.1 are known to often over- and underestimate efficacy in clinical trials, resulting in failure-prone...


  • Toronto, Ontario, Canada Q1 Technologies, Inc. Full time

    Job Summary: We are seeking a skilled Data Engineer to join our team at Q1 Technologies, Inc. This is an exciting opportunity to work on cutting-edge data engineering projects using AWS technologies. As a Senior Cloud Data Engineering Expert, you will be responsible for designing and implementing scalable data architectures, developing efficient data...


  • Toronto, Ontario, C6A, Ontario, Canada YS Accounting & Develop Services Full time

    About the Role:We are seeking a talented and experienced Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, developing, and maintaining data pipelines, data warehouses, and data lakes. You will play a key role in transforming raw data into valuable insights.Responsibilities:Data Ingestion: Develop robust data ingestion...

  • AWS Data Engineer

    4 weeks ago


    Toronto, Ontario, Canada Kaizen Technologies Full time

    About Kaizen TechnologiesWe are a cutting-edge technology company based in Toronto, ON. We specialize in delivering innovative data solutions using the latest AWS technologies.Job SummaryWe are seeking an experienced AWS Data Engineer to join our team. The successful candidate will have a strong background in designing and implementing data pipelines on...


  • Toronto, Ontario, Canada Royal Bank of Canada Full time

    About the RoleAs a highly skilled Data Engineering Lead at Royal Bank of Canada, you will be responsible for ensuring the smooth and efficient operation of our Cloud Data Lakehouse environment. This critical role involves providing platform-related technical support, performance optimization, and troubleshooting while driving best practices in...


  • Toronto, Ontario, Canada Myticas Consulting Full time

    Job Description:We are seeking a highly skilled Senior Data Engineering Specialist to join our team at Myticas Consulting. In this role, you will play a key part in developing and implementing data integration strategies, building data pipelines, performing data modeling, ensuring data governance, and planning scalable solutions.About the Role:You will...


  • Toronto, Ontario, Canada Mytechtal Full time

    **Mytechtal Seeks a Data Architect to Lead Microsoft Fabric ProjectsAbout the Role:We are seeking an experienced Data Architect to join our team at Mytechtal. As a key member of our data engineering group, you will be responsible for designing and delivering comprehensive data solutions using Microsoft Fabric.Key Responsibilities:Data Architecture Design:...

  • Data Engineer

    1 month ago


    Toronto, Ontario, Ontario, Canada Mewar Info Tech Limited Full time

    Data EngineerAbout the Role:As a Data Engineer, you will play a crucial role in designing, building, and maintaining our data infrastructure. You will work closely with data scientists, analysts, and engineers to extract, transform, and load data from various sources into our data warehouse and data lake. Your expertise in data engineering will help us...


  • Toronto, Ontario, Canada Royal Bank of Canada Full time

    About Royal Bank of CanadaRoyal Bank of Canada (RBC) is a leading financial institution dedicated to providing innovative solutions and expert advice to its clients. Our commitment to excellence and customer satisfaction drives us to continuously improve our services and operations.Job OverviewWe are seeking an experienced Cloud Data Engineer to join our...


  • Toronto, Ontario, Canada Mytechtal Full time

    Senior Data Architect Position at MytechtalWe are seeking an experienced Senior Data Architect to join our team at Mytechtal. The ideal candidate will have a strong background in data architecture, with expertise in designing and implementing comprehensive data solutions using Microsoft Fabric.About the Role:Architect Data Solutions: Design end-to-end data...

  • Data Engineer

    4 weeks ago


    Toronto, Ontario, Ontario, Canada WizeWerks Full time

    Data Engineer - Client-Facing Role WizeWerks | Full-time | On-site at Client Location About WizeWerks WizeWerks is a boutique consultancy in Toronto, ON, specializing in AI-driven technology solutions. We focus on integrating generative AI and LLM across internal operations and client services, using in-house AI tools to streamline delivery and maintain...


  • Toronto, Ontario, Canada Thermo Fisher Scientific Inc. Full time

    Job SummaryWe are seeking an experienced Cloud Engineer to join our remote global team, where you will design and implement cloud-based data solutions using AWS services. The ideal candidate has a strong background in cloud engineering, preferably with AWS experience, and is proficient in SQL and Python programming.About UsThermo Fisher Scientific Inc. is a...