Job Summary
Job Description
What is the opportunity?
Reporting to the Head of Data Analytics you will work closely with business and technology teams across Wealth Management Europe to support the ongoing maintenance and evolution of the data analytics infrastructure with approximately 80% of the role allocated to database design and maintenance and 20% focus on dashboard creation and the delivery of insights to the business.
What will you do?
Responsible for the design, development and ongoing maintenance of the scalable Data Analytics data infrastructure using the Microsoft SQL technology stack to serve as the foundational layer for analytics and insights, support and guide team on technical design and implementations.
Thorough understanding of T-SQL to create new and modify existing ETLs / ELT’s, stored procedures and SSIS packages to support efficient reporting and analytics to the business.
Create, maintain, and develop Dev, UAT and Production database environments ensuring consistency.
Proactive in identifying new opportunities / enhancements of the Data Analytics environment, together with any migrations as required.
Competent in using GitHub (or other version control tooling) and in using data and schema comparisons via Visual Studio.
Champion for the DevOps process to ensure the latest techniques are being used and that implementation methodologies involving new or changes to existing source code or DB structure follow the agreed development and release processes and that all productionised code is adequately documented and reviewed.
Identify, source, stage, and model internal process improvements to automate manual processes and optimise data delivery for greater scalability, as part of the end-to-end data lifecycle.
Research, explore and understand business problems and reporting requirements to facilitate the design, development and deployment of solutions and dashboards, enabling end user self-service, incorporating drill-down functionality.
Work in conjunction with Finance and Technology functions to understand the reconciliations process and flow of data across applications.
What do you need to succeed?
Must-have
Proven experience with MS SQL Server.
Sound understanding of relational database principals, guidelines and design.
Extensive SQL query development experience.
Familiarity and experience with data visualisation tools.
Nice-to-have
Knowledge of Tableau.
Experience with JIRA.
Experience with GitHub.
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.
Flexible working and hybrid options fully supported.
Scheduled Weekly Hours: Jersey 36.25 Hours / London 35 Hours
#LI-SS2
Job Skills
Critical Thinking, Data Administration, Data Mining, Data Modeling, Data Movement, Detail-Oriented, Group Problem Solving, Quantitative Research, Research Documents
Additional Job Details
Address:
100 BISHOPSGATE:LONDON
City:
London
Country:
United Kingdom
Work hours/week:
35
Employment Type:
Full time
Platform:
WEALTH MANAGEMENT
Job Type:
Regular
Pay Type:
Salaried
Posted Date:
2024-09-23
Application Deadline:
2025-01-24
Note:Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
Inclusionand 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 atjobs.rbc.com.
The latest news, articles, and resources, sent to your inbox weekly.
This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.Job DescriptionUncover Actionable Insights to Drive Investment Banking Innovation.Are you ready to revolutionize investment banking with data-driven insights? Join the Global Investment Bank Digital (GIBD) team at JPMorgan Chase, where you'll work in a fast-paced,...
JPMorgan Chase & Co. London
We are Dufrain, a pure-play data consultancy specialising in helping businesses unlock the true value of their data by providing market-leading data solutions and services which includes developing strategies for AI readiness, improving data literacy and culture, enhancing real-time reporting, and managing data from mergers and acquisitions.At Dufrain we prides...
Dufrain Edinburgh
The rolein a nutshellKin + Carta is looking to hire a Senior/Lead Google Cloud Engineer to join our growing team. If you are passionate about building valuable, innovative and inspiring cloud solutions with a desire to continually learn as part of a collaborative and supportive team, read on! We seek...
Kin + Carta Manchester
We are looking for a Senior Azure Developer to join the Frontier team, on a permanent, full-time basis. This is a fully homebased role but there will be a requirement to attend sites when needed.You will be an integral part of a high-performing team, working with Microsoft technologies to implement...
Frontier Agriculture Witham Saint Hughs
Job summaryUCLH is a leading healthcare provider committed to delivering world-class patient care, research, and education. We are seeking a highly skilled, experienced and motivated scientist to lead, manage and develop our Clinical Scientific Computing Team within the Department of Medical Physics and Biomedical Engineering at UCLH.This role presents a...
University College London Hospitals NHS Foundation Trust London
You will primarily be building a customer lifetime view model and the associated data engineering pipelines and infrastructure. You may also work on other data engineering tasks as required. You will engage with stakeholders to understand the requirements of the model and iterating on the design as required.Here's a taste...
E.ON Next Nottingham
