Data Engineer

3 weeks ago

MISSISSAUGA, Canada Royal Bank of Canada Full time

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:

2024-05-07

Application Deadline:

2024-05-14

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 jobs.rbc.com.

  • Data Engineer

    1 month ago

    Mississauga, Canada CB Canada Full time

    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 with minimum guidance 5+ years’ experience in data engineering Team player, mindset to work...

  • Data Engineer

    5 days ago

    Mississauga, Ontario, Canada Compass 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 buildings, senior living communities, tourist attractions, sports venues, remote...

  • Data Engineer

    4 days ago

    Mississauga, Canada COMPASS GROUP 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 buildings, senior living communities, tourist attractions, sports venues,...

  • Data Engineer

    4 days ago

    Mississauga, Canada COMPASS GROUP 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 buildings, senior living communities, tourist attractions, sports venues,...

  • Data Engineer

    4 days ago

    Mississauga, Canada COMPASS GROUP 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 buildings, senior living communities, tourist attractions, sports venues,...

  • Data Engineer

    2 weeks ago

    Mississauga, Canada Corporate Office Careers Full time

    Postal Code: L4W 0C7 Our family of 131,000 employees and franchise affiliates share a collective passion for delivering exceptional shopping experiences and amazing food to all our customers. Our mission is to nurture the things that make life better – great experiences, families, communities, and our employees. We are a family nurturing families. ...

  • Data Engineer

    4 days ago

    Mississauga, Canada Axelon Canada Full time

    Global Financial Firm located in Mississauga, ON has an immediate contract opportunity for an experienced Data Engineer"This role is currently on a Hybrid Schedule.You will need to have reliable internet, computer and android or iphone for remote access into the client systems during remote work.We will be expected in the office weekly 2-3 days depending on...

  • Data Engineer

    2 weeks ago

    Mississauga, Canada Synechron Full time

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

  • Data Engineer

    4 days ago

    Mississauga, Canada KUBRA Full time

    OverviewKUBRA 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. The best part? You will also get the opportunity to collaborate with an amazing Data...

  • Data Engineer

    4 days ago

    Mississauga, Canada KUBRA Full time

    OverviewKUBRA 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. The best part? You will also get the opportunity to collaborate with an amazing Data...

  • Data Engineer

    4 days ago

    Mississauga, Canada KUBRA Full time

    OverviewKUBRA 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. The best part? You will also get the opportunity to collaborate with an amazing Data...

  • Data Analytics Engineer

    4 days ago

    Mississauga, Canada Aviyatech Full time

    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 Contractors. We have an opening for aData Analytics Engineer to join our...

  • Data Analytics Engineer

    4 days ago

    Mississauga, Canada Aviyatech Full time

    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 Contractors. We have an opening for aData Analytics Engineer to join our...

  • Data Analytics Engineer

    4 days ago

    Mississauga, Canada Aviyatech Full time

    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 Contractors. We have an opening for aData Analytics Engineer to join our...

  • Data Engineer

    1 week ago

    Mississauga, Canada VLink Inc Full time

    Role : Snowflake Developer 10+ years candidate only Location : Mississauga, ON Banking and financial exp and Data Engineer, Snowflake Developer , SQL python programming

  • Data Engineer

    7 days ago

    Mississauga, Canada VLink Inc Full time

    Role : Snowflake Developer 10+ years candidate only Location : Mississauga, ON Banking and financial exp and Data Engineer, Snowflake Developer , SQL python programming

  • Data Engineer

    7 days ago

    Mississauga, Canada VLink Inc Full time

    Role : Snowflake Developer 10+ years candidate onlyLocation : Mississauga, ONBanking and financial exp and Data Engineer,Snowflake Developer, SQL python programming

  • Data Engineer

    5 days ago

    Mississauga, Canada VLink Inc Full time

    Role : Snowflake Developer 10+ years candidate onlyLocation : Mississauga, ONBanking and financial exp and Data Engineer, Snowflake Developer, SQLpython programming

  • Data Engineer

    1 week ago

    Mississauga, Canada VLink Inc Full time

    Role : Snowflake Developer 10+ years candidate onlyLocation : Mississauga, ONBanking and financial exp and Data Engineer, Snowflake Developer, SQLpython programming

  • Data Engineer

    1 week ago

    Mississauga, Canada VLink Inc Full time

    Role : Snowflake Developer 10+ years candidate onlyLocation : Mississauga, ONBanking and financial exp and Data Engineer, Snowflake Developer, SQLpython programming