Jobs
>
Mississauga

    Data Engineer - Mississauga, Canada - RBC - Royal Bank

    RBC - Royal Bank
    RBC - Royal Bank Mississauga, Canada

    1 week ago

    RBC - Royal Bank background
    Full time
    Description

    Job Summary

    Job Description

    What is the opportunity?

    Supports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies complete knowledge, skills, and practices to perform assignments. Data Engineer on the Insurance data Lake Team in Technology & Operations at the Royal Bank of Canada?

    RBC`s Insurance data lake is responsible for Maintaining Insurance Data Lake the feeds into and out of Insurance data lake support for critical business and risk analytics, business reporting and Regulatory Reporting needs. Insurance data lake is a Large diverse environment utilizing Various platforms like Big Data, Cloudera, Snowflake, Unix, Windows, SQL Server, Mainframe, IBM Datastage etc. RBCI IDL team a young energetic, dynamic, collaborative, progressive and highly performing team of individuals who are highly talented and willing to share and work together.

    What will you do?

    Our team is looking for a data engineer who is constantly thinking outside the box, ready to dive deep into the smallest details, is passionate about contributing to the successful delivery of his responsibilities. The Insurance Data Lake team utilizes a diverse spectrum of technical environments Unix/Windows/Data lake/Mainframe... scripting in JCL, PowerShell, bat. Java, Spark, Scala, SQL, Unix Shel. To IBM Web sphere DataStage coding options to RBC's inhouse IDP data ingestion tool.

    • Creating software for retrieving, parsing and processing structured and unstructured data.
    • Defining and building scalable ETL/ELT workflows for reporting and analytics.
    • Supporting project team to scale, monitor and operate data platforms for very high availability and performance.
    • Developing scripts and programs for converting various types of data into usable formats.

    What do you need to succeed?

    Must-have

    • Excellent interpersonal and highly developed communication skills.
    • Creative and analytical thinker who is self-driven and capable of working in a fast-paced environment.
    • IT Standards, Methodologies, SDLC, Information Security & audit requirements.
    • Strong MS Office skills - Word, Outlook, Excel and PowerPoint
    • Understanding of Structured query language like SQL is a must.
    • Experience in handling Data ingestion pipelines in Hadoop.
    • Hands-on experience in Spark/Scala/Python (Any Language) to write data transformation logic.
    • Should have good knowledge of writing complex SQL logic with Joins and windowing operations. Having experience in Cloud computing it's an Add-on.
    • Should have good knowledge of scripting languages - Ex: Shell script, Python, PowerShell.
    • Should have hands-on experience in scheduling data pipelines for automation.
    • Should have basic knowledge of data security / encryption in data lake.
    • Must be willing to learn.

    Nice to Have:

    • Knowledge of Mainframe JCL is a plus.
    • Knowledge of Git Hub or other source code management tool is a plus.
    • Knowledge of IBM WebSphere Datastage is a plus.
    • Knowledge of Reporting Tools like Websphere and Trino/Tableau is a plus.
    • Knowledge of KAFKA.

    What's in it for you?

    We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

    • A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation, commissions, and stock where applicable.
    • Leaders who support your development through coaching and managing opportunities
    • Ability to make a difference and lasting impact.
    • Work in a dynamic, collaborative, progressive, and high-performing team
    • A world-class training program in financial services
    • Opportunities to do challenging work, to take on progressively greater accountabilities and to building close relationships with clients.
    • Access to a variety of job opportunities across business and geographies.

    #LI-Hybrid

    #LI-Post

    #LI-PK

    #TECHPJ

    Job Skills

    Analytical Thinking, Analytical Thinking, Cloud Computing, Communication, Creativity, Database Development, Data Ingestion, Data Lake, Data Transformation, ETL Processing, GitHub, Group Problem Solving, Hands on Work, IBM InfoSphere DataStage, Interpersonal Relationships, Java, Languages, Python (Programming Language), Python for Data Analysis, Quality Management, Query Language, Reporting Tools, Requirements Analysis, Scala (Programming Language), Scripting {+ 3 more}

    Additional Job Details

    Address:

    MEADOWVALE BUSINESS PARK, 6880 FINANCIAL DR:MISSISSAUGA

    City:

    MISSISSAUGA

    Country:

    Canada

    Work hours/week:

    37.5

    Employment Type:

    Full time

    Platform:

    Technology and Operations

    Job Type:

    Regular

    Pay Type:

    Salaried

    Posted Date:

    Application Deadline:

    Inclusion and Equal Opportunity Employment

    At RBC, we embrace diversity and inclusion for innovation and growth. We are committed to building inclusive teams and an equitable workplace for our employees to bring their true selves to work. We are taking actions to tackle issues of inequity and systemic bias to support our diverse talent, clients and communities.
    ​​​​​​​
    We also strive to provide an accessible candidate experience for our prospective employees with different abilities. Please let us know if you need any accommodations during the recruitment process.

    Join our Talent Community

    Stay in-the-know about great career opportunities at RBC. Sign up and get customized info on our latest jobs, career tips and Recruitment events that matter to you.

    Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at

  • Synechron

    Data Engineer

    1 week ago

    Synechron Mississauga, ON, Canada Part time

    Role: Python Data Engineer(Databricks/Python/Pyspark, Azure) Mississauga, ON (hybrid/3 days in a week) - In Person Interview · Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are re ...

  • Synechron

    Data Engineer

    2 days ago

    Synechron Mississauga, ON, Canada Part time

    Role: Python Data Engineer(Databricks/Python/Pyspark, Azure) Mississauga, ON (hybrid/3 days in a week) - In Person Interview · Looking for an Integration engineer responsible for daily support and project based development of credit risk management systems. ETL developers are re ...

  • CB Canada

    Data Engineer

    6 days ago

    CB Canada Mississauga, Canada

    Data Engineer · On behalf of our client in the Retail Sector, PROCOM is looking for a Data Engineer. · Data Engineer – Mandatory Skills · Proficient in building data pipelines in Hadoop/GCP · Expert in data analysis using SQL · Ability to build scalable resilient systems wit ...

  • KUBRA

    Data Engineer Data Analytics

    1 week ago

    KUBRA Mississauga, ON, Canada

    KUBRA is in growth mode and currently seeking a Data Engineer to join our Data Analytics Team · As a Data Engineer, you will be working on designing and maintaining our data Infrastructure and ETL processes under the direction of the Team Lead, or Senior Data Engineer. You will a ...

  • Compass Canada

    Data Engineer

    1 week ago

    Compass Canada Mississauga, Canada Full time

    You might not know our name, but you know where we are. That's because Compass Group Canada is part of a global foodservice and support services company that's the 6th largest employer in the world, with 625,000 employees. · You'll find us in schools, colleges, hospitals, office ...

  • 0000050007 Royal Bank of Canada

    Data Engineer

    1 week ago

    0000050007 Royal Bank of Canada Mississauga, Canada Full time

    Job Description · What is the opportunity? Supports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies complete knowledge, skills, and practices to perform assignments. Data Engineer on the Insurance data L ...

  • COMPASS GROUP CANADA

    Data Engineer Data Analytics

    2 weeks ago

    COMPASS GROUP CANADA Mississauga, ON, Canada

    That's because Compass Group Canada is part of a global foodservice and support services company that's the 6th largest employer in the world, with 625,000 employees. · You'll find us in schools, colleges, hospitals, office buildings, senior living communities, tourist attractio ...

  • Clientserver Tech Systems Inc.

    data engineer

    6 days ago

    Clientserver Tech Systems Inc. Mississauga, Canada

    Education: Bachelor's degree · Experience: 1 year to less than 2 years · Tasks · Data Science · Design, develop and implement information systems business solutions · Operate database management systems to analyze data · Develop and implement data administration policy, standards ...

  • Clientserver Tech Systems Inc.

    data engineer

    1 week ago

    Clientserver Tech Systems Inc. Mississauga, Canada

    Education: · Expérience: · Education · Bachelor's degree · Tasks · Data Science · Design, develop and implement information systems business solutions · Operate database management systems to analyze data · Develop and implement data administration policy, standards and models ...

  • Clientserver Tech Systems Inc.

    data engineer

    1 week ago

    Clientserver Tech Systems Inc. Mississauga, Canada

    Education: Bachelor's degree · Experience: 1 year to less than 2 years · Tasks · Data Science · Research, evaluate and synthesize technical information to design, develop and test computer-based systems · Design, construct, modify, implement and test data models and database mana ...

  • Clientserver Tech Systems Inc.

    data engineer

    1 week ago

    Clientserver Tech Systems Inc. Mississauga, Canada

    Education: · Expérience: · Education · Bachelor's degree · Tasks · Data Science · Research, evaluate and synthesize technical information to design, develop and test computer-based systems · Design, construct, modify, implement and test data models and database management syste ...

  • Société Financière Manuvie

    Data engineer

    1 week ago

    Société Financière Manuvie Toronto, ON, Canada

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...

  • Société Financière Manuvie

    Data engineer

    17 hours ago

    Société Financière Manuvie Old Toronto, Canada

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...

  • goeasy Ltd

    Senior Data Engineer, Data Quality

    1 week ago

    goeasy Ltd Mississauga, ON, Canada

    We have been honored with recognitions such as Waterstone Canada's Most Admired Corporate Cultures , the 2022 Report on Business Women Lead Here , Report on Business for Canada's Top Growing Companies and TSX30 as one of the best performing companies on the TSX . As our new Senio ...

  • Aviyatech

    Data Analytics Engineer

    1 week ago

    Aviyatech Mississauga, ON, Canada

    Aviya Aerospace Systems is a leader in engineering services and solutions for mission critical Aerospace and Defense applications. Aviya provides expertise in program management, systems, software, mechanical, and hardware engineering to many of the top-tier Aerospace and Defense ...

  • CIBC

    Data Engineer

    1 week ago

    CIBC Toronto, Canada Temps plein

    Nous bâtissons une banque axée sur les relations pour un monde moderne. Nous recrutons des professionnels talentueux et passionnés qui ont à cœur de faire ce qu'il faut pour nos clients. · À la Banque CIBC, nous misons sur vos forces et vos ambitions pour vous donner le pouvoir ...

  • Myant Inc

    Biomedical Data Engineer

    1 week ago

    Myant Inc Mississauga, ON, Canada

    At Myant, we are creating the world's first expressive and continuous digital presence platform, enabled by integrating technology directly into clothing and augmented by other devices, wearables, and IOT. Humans have a fundamental desire and need to be connected to our environme ...

  • PepsiCo

    Data System Engineer

    6 days ago

    PepsiCo Mississauga, Canada Full time

    Overview The Data System Engineer will lead the way for Pepsico Foods Canada in this innovative space, helping to transform the organization to be more efficient in accessing data and generating right-time insights. · What you can expect from us: · Competitive compensation an ...

  • Cooper Equipment Rentals

    Data Engineering Manager

    1 week ago

    Cooper Equipment Rentals Mississauga, Canada

    Build your Career at Cooper Equipment Rentals · We are looking for a talented problem-solver with an "automate everything" attitude to lead our professional Data Engineering and Integration Team as Data Engineering Manager. · Please note to be considered for this position a ...

  • VLink Inc

    Senior Data Engineer

    19 hours ago

    VLink Inc Mississauga, Canada

    Primary Responsibilities: · Strong understanding or Snowflake on Azure Architecture, design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse. · Hands-on development experience with Snowflake features such as Snow ...