At a Glance
- Tasks: Build and optimise data pipelines for our innovative Data Lakehouse platform.
- Company: Join RBC, a leading bank with a focus on collaboration and innovation.
- Benefits: Enjoy competitive salary, career growth, and a supportive work environment.
- Other info: Work in a dynamic team with opportunities to learn from industry experts.
- Why this job: Make a real impact in wealth management by pioneering data solutions.
- Qualifications: Experience in Data Engineering, SQL, Python, and big data pipelines required.
The predicted salary is between 60000 - 75000 £ per year.
We're looking for a passionate Data Engineer to join our innovative team in London or Newcastle and help shape the future of our Data Lakehouse platform! In this role, you'll collaborate closely with business and technology teams across Wealth Management Europe (WME), building and optimising the data pipelines that turn raw financial data into trusted, actionable insights using cutting-edge tools like Databricks, Azure Data Factory, and Delta Lake. This is a permanent, full-time role and requires working 4 days a week in our London or Newcastle office.
What Will You Do?
- Architect & Optimize Data Pipelines: Design, build, and maintain scalable pipelines across our Bronze, Silver, and Gold medallion architecture - from raw source ingestion through to the analytics layer that powers our business.
- Own the Platform: Perform daily monitoring of pipeline health, proactively resolve issues end-to-end, and keep our data flowing reliably for the teams that depend on it.
- Innovate with Modern Tech: Leverage Azure, Databricks, and Data Factory to automate repetitive tasks, enhance performance, and future-proof our platform.
- Champion DevOps & DataOps: Lead by example with Gitflow branching, structured pull request reviews, and rigorous testing practices.
- Collaborate Across Teams: Partner with data analysts, architects, and business stakeholders to translate requirements into well-engineered technical solutions that drive strategic decisions.
- Innovate Continuously: Spot opportunities to improve pipeline performance, platform architecture, and engineering processes - and do something about them.
What you will need to succeed?
Must-Have
- Proven experience in Data Engineering working within a Lakehouse environment (Databricks is preferable)
- Strong SQL/T-SQL skills and a knack for database design and modelling
- Experience and knowledge of Python and PySpark
- Proven experience building and optimising big data pipelines at scale with structured and semi-structured data
- Hands-on experience with Azure Data Factory, ADLS Gen2, and Azure SQL Database
- Solid Azure DevOps practices including Git, branching strategies, and agile delivery
- A thorough approach to testing - source system through to the presentation layer
Nice-to-Have
- Familiarity with Infrastructure-as-Code (e.g. Terraform)
- Experience with data governance, quality, and security processes.
- Familiarity with Azure DevOps Pipelines and CI/CD for data platform deployments
- A curious, problem-solving attitude and a passion for automating manual processes.
Why Join Us?
This isn't just a job-it's a chance to pioneer data solutions in a dynamic, relationship-driven industry. At RBC, we value lasting partnerships, both with our clients and our teams. You'll work with brilliant minds, tackle meaningful challenges, and grow your career in a sector that thrives on trust and innovation.
What is 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.
- Leaders who support your development through coaching and managing opportunities.
- Opportunities to work with the best in the field.
- Ability to make a difference and lasting impact.
- Work in a dynamic, collaborative, progressive, and high-performing team.
Data Engineer employer: Royal Bank of Canada
At RBC Wealth Management Europe, we pride ourselves on being an exceptional employer, offering a dynamic and collaborative work environment in London and the South East. Our commitment to employee growth is evident through our comprehensive Total Rewards Program, which includes competitive compensation, bonuses, and flexible benefits, alongside opportunities for professional development and coaching from experienced leaders. Join us to make a meaningful impact while working with a talented team dedicated to delivering tailored financial solutions to our clients.
StudySmarter Expert Advice🤫
We think this is how you could land Data Engineer
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Royal Bank of Canada!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Data Engineer at Royal Bank of Canada.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Royal Bank of Canada.
✨Apply Directly through Our Website
When you find a suitable opening like Data Engineer at Royal Bank of Canada, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Royal Bank of Canada, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Royal Bank of Canada. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Royal Bank of Canada
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Royal Bank of Canada!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
