Data Engineer (Snowflake)

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 (Do