Data Engineer (Snowflake)
RBC Capital
Job Description
What is the opportunity?
An opportunity to work at the RBC Insurance Active Data Platform Team with a group of technology specialists dedicated to deliver data transformation solution to Insurance Business and Clients. A group under RBC Technology & Operations, we take technology seriously. We are all in with Agile development, DevOps, Open Source, mobile apps and modern tools and processes including creating APIs on on-premises cloud. You will have an opportunity to make a real difference by working on some impactful and meaningful projects.
We are looking for an enthusiastic and skilled Data Engineer to join our Data and Digital Transformation Squad, work on the development and deployment of cutting-edge cloud data lakehouse platform with Snowflake at the core, drive innovation, and collaborate with cross-functional teams to drive business growth and improvement. The candidate will have a strong background in data managements and algorithms, software development and leadership, with a proven track record of delivering high-quality solutions that meet business needs. The person will collaborate closely with team members under Agile Squad including product owners, Data Engineers, Designers, Quality Engineers and other stakeholders.
We are seeking a skilled Full Stack Developer to design, develop, and maintain a modern web application with a React.js frontend and integrate it with a Snowflake Data Lakehouse via API calls. The ideal candidate will bridge frontend and backend technologies to deliver scalable, high-performance solutions that meet business needs.
This role offers the opportunity to work on cutting-edge data-driven applications, leveraging Snowflake’s advanced analytics capabilities and React’s dynamic frontend framework. You’ll contribute to high-impact projects while collaborating with a talented team of engineers and data professionals.
What will you do?
- Work together with Agile squad teams to deliver the project goals
- Frontend Development:
- Design, development user interactions on Web architecture, designing and developing APIs for Insurance platform, understand business requirements, analyse a problem, find the best solution and implement it.
- Build responsive, user-friendly interfaces using React.js, ensuring cross-browser compatibility.
- Implement state management (e.g., Redux, Context API) and optimize UI performance.
- Collaborate with UX/UI designers to translate wireframes into functional components.
- Backend & API Integration
- Develop and maintain RESTful/GraphQL APIs to interact with the Snowflake Data Lakehouse.
- Write efficient SQL queries and stored procedures in Snowflake for data retrieval, transformation, and storage.
- Ensure secure data handling, authentication, and authorization (e.g., OAuth, JWT).
- Full Stack Collaboration:
- Work with data engineers to design data models and optimize query performance in Snowflake.
- Integrate third-party services (e.g., authentication providers, analytics tools).
- Implement CI/CD pipelines for automated testing and deployment.
- Problem-Solving & Optimization:
- Debug and resolve issues across the stack (frontend, API, database).
- Optimize application performance, focusing on latency reduction and resource efficiency.
- Stay updated on emerging technologies (e.g., Snowflake features, React advancements).
- Build end to end knowledge on our applications, support the application enhancement and provide production maintenance support.
- Staying abreast of developments in web applications and programming languages.
What do you need to succeed?
Must-have
- Proficiency in React.js (Hooks, Router, state management).
- Knowledge with Snowflake or similar cloud data platforms (e.g., Redshift, BigQuery).
- Strong knowledge of JavaScript/TypeScript, HTML5, CSS3, and API design (REST/GraphQL).
- Familiarity with SQL and query optimization.
- Experience with Node.js or Python for backend services (optional but preferred).
- Considerable experience and a portfolio of work on web architecture and applications for either the backend, frontend , or the full-stack
- Have 1 year of on the job experience, a degree in computer science or information systems, or a mix of experience and education.
- Being able to work independently, in addition to working within a team
- Analytical thinking, Results orientated, Time management, ability to adapt and react to changes and with Sense of urgency
- Good communication and presentation skills, self-motivated, teamwork and cooperation
- Languages/Technologies:
- Java, Spring, Spring boot, JavaScript, REST API, Angular, CICD
- Web Technologies: REST, Web Services, Cloud (PCF)
- Databases: MS SQL, DB2
- Tools & Application Management: Spring Tool Suite, Jenkins, Maven, SonarQube, Postman, REST Client, Jenkins, UCD, Github, Atlassian tools such as Confluence and JIRA, Agile Methodology
Nice-to-have
- Experience with cloud platforms (AWS, Azure, GCP).
- Knowledge of containerization (Docker) and orchestration (Kubernetes).
- Familiarity with data warehousing concepts and ETL processes.
- You learn fast – pick up new ideas, technologies, applications and tools.
- You love to challenge the status quo and like innovation. You ask questions and are always learning .
- You are able to understand and to clearly explain technical issues.
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 and competitive compensation
- Leaders who support your development through coaching and managing opportunities
- Work in a dynamic, collaborative, progressive, and high-performing team
- Opportunities to do challenging work
#LI-Post
#LI-PK
Job Skills
Big Data Management, Cloud Computing, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Quality Management, Requirements AnalysisAdditional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
Inclusion and Equal Opportunity Employment
At RBC, we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all.
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.
RBC is presently inviting candidates to apply for this existing vacancy. Applying to this posting allows you to express your interest in this current career opportunity at RBC. Qualified applicants may be contacted to review their resume in more detail.