Associate - Data Analytics - London, United Kingdom - Royal Bank of Canada
Description
Come Work with Us
At RBC, our culture is deeply supportive and rich in opportunity and reward. You will help our clients thrive and our communities prosper, empowered by a spirit of shared purpose.
Whether you're helping clients find new opportunities, developing new technology, or providing expert advice to internal partners, you will be doing work that matters in the world, in an environment built on teamwork, service, responsibility, diversity, and integrity.
Job Title
Associate - Data Analytics
What is the opportunity?
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.
UKJERSEYWM
What will you do?
- Support 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
- Identify, source, stage and model data using industry standard technologies and established development and operational practices as part of the endtoend data lifecycle
- Work with the business and senior team members to identify and source data points across core platforms and processes 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, supporting the creation of model development 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
- Research, explore and understand business problems and reporting requirements and support in the design, development and deployment of solutions and dashboards, enabling enduser selfservice, incorporating drilldown functionality
- Provide data driven and thought provoking insights to drive informed decisionmaking, supporting the transfer of knowledge to stakeholders to use its data more effectively
- Adhere to the established DevOps's 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
What do you need to succeed?
Must-have
- Experience with MS SQL Server, Data Warehousing techniques, solutions and methodologies
- Good understanding of relational database principals
- Good knowledge of SQL, working with ETL's and SSIS packages
- Data management analyst with ability to mine and visualize data
- Good understanding of datasets, data warehouses /modelling, database design and programming
Nice-to-have
- Knowledge of Tableau
- Experience with JIRA
- Experience with GitHub
- Knowledge of Agile project management principles
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 highperforming team
- A worldclass training program in financial services
- Flexible and hybrid working options fully supported
Job Summary
Address:
Saint Helier, Jersey
City:
GBR-GREATER_LONDON-LONDON, JEY-ST_HELIER-SAINT HELIER
Country:
Jersey
Work hours/week:
36.25
Employment Type:
Full time
Platform:
Wealth Management
Job Type:
Regular
Pay Type:
Salaried
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.
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.
More jobs from Royal Bank of Canada
-
Senior Administrator-corporate Actions
Saint Helier, United Kingdom - 1 week ago
-
Senior Business Analyst, Wealth Management Europe
London, United Kingdom - 2 days ago
-
Product Controller, London Structured Rates
London, United Kingdom - 1 week ago
-
Compliance Advisory
London, United Kingdom - 1 week ago
-
Associate - Global Credit CTM
London, United Kingdom - 1 month ago
-
Associate, Sales
London, United Kingdom - 5 days ago