Senior Associate - Saint Helier, United Kingdom - Royal Bank of Canada

Royal Bank of Canada

Verified Company

Saint Helier, United Kingdom

3 weeks ago

Posted by:

Tom O´Connor

beBee Recruiter

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
Senior Associate - Reporting & Analytics (Jersey)

What is the opportunity?
Reporting to the Head of Data Analytics you will work closely with business and technology teams across Wealth Management International (WMI) to support the delivery of analytical
insights, develop and curate data assets, build dashboards and model data that will enable data driven decisions.

What will you do?

Develop, enhance and maintain the evolving Data Analytics data infrastructure in line with the business needs to support the overarching data strategy across the organisation
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 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, 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 Research, explore and understand business problems and reporting requirements to facilitate the design, development and deployment of solutions and dashboards, enabling end user selfservice, incorporating drilldown functionality
Provide data driven and thought provoking insights to drive informed decisionmaking, transferring knowledge to stakeholders and enabling the business to use its data more effectively
Through the delivery of informative reporting solutions; support, inspire and educate endusers to use data more effectively to improve overarching data literacy across the organisation
Analyse, document and recommend improvements to existing business practices to capitalise on opportunities for automation, efficiencies and risk reduction to enhance capabilities and streamline endtoend data related processes
Actively engage within the team and wider business areas to foster relationships and develop thought leadership 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
Adhere to and promote the the 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

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
Data management specialist 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

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 highperforming team
Flexible working options fully supported
Hybrid Working

Job Summary

Address:

Saint Helier, Jersey

City:

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:

:00

Application Deadline:

:00

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 w