Data Engineer

3 weeks ago

Mississauga, Ontario, Canada RBC - Royal Bank 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:

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

  • 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...

  • Lead Data Engineer

    3 weeks ago

    Mississauga, Ontario, Canada Royal Bank of Canada Full time

    Job SummaryJob DescriptionWhat is the opportunity? This is an opportunity to work at RBC Insurance Active Data Platform team with a group of technology specialists dedicated to deliver solution to Insurance business and clients. We are all in with Agile development, DevOps, Open Source, Software as a Service (SaaS) and modern tools and processes. You will...

  • Senior Data Engineer, Insurance Data Services

    3 weeks ago

    Mississauga, Ontario, Canada RBC - Royal Bank Full time

    Job SummaryJob DescriptionSenior Data EngineerWhat is the opportunity?As Senior Data Engineer in Insurance Data Engineering Services team within Insurance Technology, you will design, implement, and support Data Engineering solutions and processes in multiple Agile Labs. We are looking for a passionate data management enthusiast with strong data architecture...

  • Vice President, Core Data

    5 days ago

    Mississauga, Ontario, Canada Compass Canada Full time

    Working Title: VICE PRESIDENT, CORE DATA Employment Status: [[filter10]] Starting Hourly Rate: [[cusHourlyRate]] Address: [[req_streetAddress]] Mississauga ON L5W 0B3 New Hire Schedule: [[req_newHireSchedule]] 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...

  • Data Analyst

    2 days ago

    Mississauga, Ontario, Canada Snaplii Full time

    Salary: About SnapliiSnaplii is a leading Digital Wallet platform that has redefined the way Users and Merchants engage for more efficient communication. Our platform offers value-added features, including secure credit card payments, a curated list of favorite merchants, cash-back card options, data-driven marketing solutions, and a thriving gift card...

  • Senior Web Engineer

    2 weeks ago

    Mississauga, Ontario, Canada procom Full time

    Senior Web Engineer On behalf of our client in the Financial Services Sector, PROCOM is looking for a Senior Web Engineer. Senior Web Engineer - Job DescriptionG10 Rates Technology is responsible for delivering state of the art technology solutions to the Global G10 Rates business Initiatives includes deliveries across sales, risk, pricing, algorithmic...

  • Chemical Engineer

    3 weeks ago

    Mississauga, Ontario, Canada Myant Corp. Full time

    About UsAt 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. We see the evolution of society where every member gets to participate from anywhere and anytime through a whole-body experience, mostly in a...

  • Machine Learning Software Designer/Engineer

    1 month ago

    Mississauga, Ontario, Canada AtkinsRéalis Full time

    Job DescriptionDuties:A software design/engineering professional is required to work on the design, development, verification, documentation, and testing of computer system software for internal products and projects. Periodic work at client locations and on external projects is to be expected. The immediate focus is expected to be as a software developer...

  • Manufacturing Engineer

    4 weeks ago

    Mississauga, Ontario, Canada Vital Bio Full time

    About:In this Technical role, you will be responsible for the transfer of new products from engineering and assay development into manufacturing, designing, and developing assembly processes that assure the consistent and cost-effective production of high-quality, repeatable assemblies in prototypes through manufacturing scale-up and steady-state production...

  • Senior Software Engineer

    1 month ago

    Mississauga, Ontario, Canada Advancedtechsearch Full time

    Contribute to the development and delivery of high-quality medical softwareLead the development of software-based tools to support hardware and firmware development of current and future wearable products.Provide mentorship and technical leadership to the mobile development teamConduct and participate in code reviewsThe ideal candidate will have:Bachelor's...

  • Technical Engineering Manager

    1 month ago

    Mississauga, Ontario, Canada AtkinsRéalis Full time

    Technical Engineering Manager - Fuel Channel and Calandria VesselAre you looking for a company that works on major engineering projects all over the world? Do you want to make a difference by improving the daily lives of communities worldwide? Are you seeking to join an inclusive and diverse team that you can truly count on? You've come to the right...

  • Chemical Engineering Technologist

    1 month ago

    Mississauga, Ontario, Canada Myant Corp. Full time

    About UsAt 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. We see the evolution of society where every member gets to participate from anywhere and anytime through a whole-body experience, mostly in a...

  • Senior Mechanical Engineer

    1 month ago

    Mississauga, Ontario, Canada Myant Corp. Full time

    About UsAt 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. We see the evolution of society where every member gets to participate from anywhere and anytime through a whole-body experience, mostly in a...

  • Engineering and Drafting Intern

    3 weeks ago

    Mississauga, Ontario, Canada Canam Full time

    We are seeking an Engineering and Drafting Intern (Summer 2024) to join our Engineering / Drafting team located in Mississauga. This position will involve supporting Senior Drafters and Engineers in generating drawings, plans and daily assignments. The role will commence on May 6, 2024 and conclude on August 30, 2024.Essential functions Supporting senior...

  • Engineer - Municipal Transportation - Hybrid

    1 month ago

    Mississauga, Ontario, Canada CIMA+ Full time

    Company DescriptionWelcome to a place where people are at the heart of everything we do. Welcome to people with an inspiring vision and who seek stimulating challenges. At CIMA+, you'll find a place where you'll have many opportunities to learn and develop while working on engaging projects. We are a firm 100% owned by its employees and we value a...

  • Hardware Verification Engineer

    3 weeks ago

    Mississauga, Ontario, Canada Myant Corp. Full time

    About UsAt 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. We see the evolution of society where every member gets to participate from anywhere and anytime through a whole-body experience, mostly in a...

  • Process Engineer

    5 days ago

    Mississauga, Ontario, Canada Saint-Gobain Full time

    Process EngineerPosition DescriptionJob SummaryWhat's the job?The Process Engineer will implement World Class Manufacturing projects, production and processing methods and controls to meet customer-based quality standard in a manner consistent with CertainTeed Gypsum Vision, Mission, Values and Objectives. Utilizing WCM principles, this position will focus...

  • Senior Firmware Engineer

    3 weeks ago

    Mississauga, Ontario, Canada Myant Corp. Full time

    About us: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. We see the evolution of society where every member gets to participate from anywhere and anytime through a whole-body experience, mostly in a...

  • Project/Engineering Coordinator Student

    5 days ago

    Mississauga, Ontario, Canada AtkinsRéalis Full time

    Job DescriptionThe joint venture between SNC-Lavalin and Aecon has been awarded a contract with Ontario Power Generation (OPG) to carry out the Darlington Retube and Feeder Replacement (RFR) project. The project involves refurbishment of all four reactors at the Darlington Generating Station and consists of two phases - a Definition Phase and an Execution...

  • Network LAN Engineer

    5 days ago

    Mississauga, Ontario, Canada Saint-Gobain Full time

    Network LAN Engineer (Remote)Position DescriptionJob SummarySaint-Gobain, a global leader in sustainability and manufacturing, is looking for a Network LAN Engineer to support the business units in Canada.The Network LAN Engineer is responsible for designing, implementing, monitoring and managing the local area networks and Data center network to ensure...