Address
Form of workJob Summary
Job Description
What is the opportunity?
Located in Jersey or London, reporting to the Head of Data Analytics you will work closely with business and technology teams across Wealth Management Europe (WME) to support the ongoing maintenance of the Data Analytics infrastructure and with the delivery of analytical insights to business.
What will you do?
- Develop, enhance and maintain the scalable Data Analytics data infrastructure and application using the Microsoft SQL technology stack to serve as the foundational layer for analytics and insights
- Monitor database performance and where applicable implement optimisation strategies
- 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
- Work with the business and senior team members to identify and source data points across core platforms and process for inclusion within the Data Analytics data repository
- Ability to structure large disparate data sets to serve multiple functions and tailor the results for specific audiences, creating models to support investigation and analysis
- Ability to create new and modify existing T-SQL scripts, stored procedures and SSIS packages to support new and regular reporting requirements
- Thorough understanding of T-SQL to perform ETL’s and queries to support reporting and analytics
- Proactive in identifying new opportunities / enhancements of the Data Analytics environment
- Competent in using GitHub (or other version control tooling)
- Competent in using data and schema comparisons
- Actively engage with the team and wider business areas to foster relationships and develop thought leadership
- Adhere to the established DevOps process to ensure that 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
- Champion for the DevOps’s 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
- Champion for the Agile working methodology, including the role of scrum master, coordinating sprints, retrospective meetings and stand-ups
What do you need to succeed?
Must-have
- Experience with MS SQL Server
- Thorough understanding of relational database principals, guidelines and design
- Extensive SQL query development experience
- Familiarity and experience with data visualisation tools
- Data management analyst with ability to mine data and predictive modelling
- Advanced knowledge of, and experience in manipulating large disparate data sets from multiple sources in multiple formats
Nice-to-have
- Knowledge of Tableau
- Experience with JIRA
- Experience with GitHub
- Knowledge of Agile project management principles
- Knowledge of R and Python
- Experience with Visual Studio
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.
- A comprehensive Total Rewards Program including bonuses, flexible benefits and competitive compensation
- 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
- A world-class training program in financial services
- Flexible and hybrid working options fully supported
Job Skills
Critical Thinking, Data Administration, Data Mining, Data Modeling, Data Movement, Detail-Oriented, Problem Solving, Quantitative Research, Research DocumentsAdditional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
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 jobs.rbc.com.
