Senior Associate

3 weeks ago


Saint Helier, United Kingdom Royal Bank of Canada Full time

**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 end-to-end 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 self-service, incorporating drill-down functionality
- Provide data driven and thought provoking insights to drive informed decision-making, 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 end-users 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 end-to-end 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 high-performing 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**:
2023-02-16-08:00

**Application Deadline**:
2023-03-03-08:00

**I**nclusion** 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


  • Associate Director

    1 month ago


    Saint-Helier, United Kingdom Apex Group Full time

    Residency5 years residency NOT requiredEmployerApex GroupClosing date02 April 2024Reference55728ContractPermanentHoursFull TimeSalaryNegotiableApex Group has an exciting opportunity for an experienced Associate Director. As an Associate Director, you will support Line Managers in delivering the operational service to clients. In your first few weeks in this...

  • Senior Associate

    2 days ago


    Saint-Helier, United Kingdom Ocorian Full time

    Job DescriptionWorking closely with your Manager, deal with the day-to-day administration of a varied portfolio of client funds and investment structures. Maintain and develop a wide knowledge and understanding of fund administration, including that of regulated entities, ensuring adherence with Ocorian’s policies and procedures, anti-money laundering,...


  • Saint Helier, United Kingdom Royal Bank of Canada Full time

    Come Work with UsAt 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...

  • Senior Associate

    1 month ago


    Saint-Helier, United Kingdom Project Accountants Ltd Full time

    Residency5 years residency NOT requiredEmployerProject Accountants LtdClosing date03 April 2024Reference55735ContractNegotiableHoursNegotiableSalaryNegotiableAre you an accountant ready to challenge the status quo and make your mark on the financial world? We are looking for part-qualified accountants who are bold, visionary, and eager to redefine what it...

  • Senior Accountant

    1 month ago


    Saint-Helier, United Kingdom Alter Domus Full time

    Senior Accountant Location: Saint-Helier, JE ABOUT US  We are Alter Domus. Meaning “The Other House” in Latin, Alter Domus is proud to be home to 85% of the top 30 asset managers in the alternatives industry, and more than 5,000 professionals across 23 countries.  With a deep understanding of what it takes to succeed in alternatives,...


  • Saint Clement, United Kingdom RGB Recruitment Full time

    Senior / Associate Architect, Truro – Up to £55k + DOEPlease contact Sophie Randle at RGB Recruitment if you would like to know more about this opportunity ASAP!Are you an experienced Senior/Associate Architect seeking the next step in your career? Whether you're an experienced Senior / Associate Architect with aspirations to transition into a Design...


  • Saint Clement, United Kingdom RGB Recruitment Full time

    Senior / Associate Architect, Truro – Up to £55k + DOE Please contact Sophie Randle at RGB Recruitment if you would like to know more about this opportunity ASAP! Are you an experienced Senior/Associate Architect seeking the next step in your career? Whether you're an experienced Senior / Associate Architect with aspirations to transition into a...


  • Saint Clement, United Kingdom RGB Recruitment Full time

    Senior / Associate Architect, Truro – Up to £55k + DOEPlease contact Sophie Randle at RGB Recruitment if you would like to know more about this opportunity ASAP!Are you an experienced Senior/Associate Architect seeking the next step in your career? Whether you're an experienced Senior / Associate Architect with aspirations to transition into a Design...


  • Saint Helier, United Kingdom Royal Bank of Canada Full time

    **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...


  • Saint Albans, United Kingdom Bennett and Game Recruitment LTD Full time

    Our client is a growing, independent Chartered Building Surveying Practice who provide specialist advice on Neighbourly and Third-Party matters.If your skills, experience, and qualifications match those in this job overview, do not delay your application.They now require a Senior or Associate level Party Wall Surveyor to join their growing team in St Albans...

  • Associate Director

    1 month ago


    St Helier, United Kingdom Apex Group Full time

    Associate Director - Pensions Location: St. Helier, Jersey Date Posted: Jun 6, 2023 **Description** Do you have Employer & Executive Services experience, and are you seeking a new job in the Channel Islands? The Apex Group is looking for an Associate Director (Employer & Executive Services) in Jersey, and the hybrid role comes with an attractive salary...


  • Saint Helier, United Kingdom CSC Full time

    The position To act as Client Director on Private Client cases, providing fiduciary services in accordance with the relevant Client Services Agreements and the various laws and regulations pertaining to the Group's Guernsey regulatory licences. The key responsibilities for the role are noted below and as Director, Private Clients you will also be expected...

  • Accountant

    1 month ago


    Saint-Helier, United Kingdom Alter Domus Full time

    Accountant Location: Saint-Helier, JE ABOUT US  We are Alter Domus. Meaning “The Other House” in Latin, Alter Domus is proud to be home to 85% of the top 30 asset managers in the alternatives industry, and more than 5,000 professionals across 23 countries.  With a deep understanding of what it takes to succeed in alternatives, we...

  • Associate Director

    1 month ago


    St Helier, United Kingdom IQ-EQ Full time

    **Company Description** IQ EQ is part of a leading Investor Services group which combines global expertise with an unwavering focus on client service delivery. We support fund managers, global companies, family offices and private clients operating worldwide. **Job Description** Office**: Jersey - Gaspé House - In order to fulfil the requirements of the...

  • Senior Supervisor

    1 month ago


    St Helier, United Kingdom JFSC RSR Full time

    Red Snapper Recruitment are recruiting for a **Senior Supervisor** on behalf of Jersey Financial Services Commission (JFSC). The Prudential Supervision team is a new addition to their Relationship Managed Supervision teams and provides an excellent opportunity to help shape how the JFSC implements its approach to forming views on the business model...


  • Saint Albans, United Kingdom Hunter Dunning Full time

    Senior Rural Surveyor job in St Albans, Hertfordshire Senior Rural Surveyor job based in St Albans, Hertfordshire for a leading UK rural consultancy joining their rural land management team. Offering a salary of up to £35,000 (Negotiable) + Bonus + Car Allowance £4500 - £6500 + Life Assurance + Hybrid Working + 27 days Holiday. They are a leading rural...

  • Senior Administrator

    18 hours ago


    St Helier, United Kingdom JTC Group Full time

    **Join Team JTC where your contribution will be valued.**: We currently have an exciting opportunity for an Senior Administrator - Cash Management Team to join our team in Jersey. **Purpose of job**: The Banking & Treasury Team in Jersey have an exciting opportunity for a Senior Administrator to support all aspects of the daily work, and effective running...


  • Saint Andrews, United Kingdom Kohler Co. Full time

    About Us The Old Course Hotel, Golf Resort & Spa is an AA 5 star, award-winning resort based in St Andrews which prides itself on the highest levels of guest care. We are an independently owned resort, forming part of Kohler Company, a leading global hospitality provider. To find out more about Kohler Co. please visit Why Join Our Team? With a...


  • Bury Saint, United Kingdom TEC Partners - Technical Recruitment Specialists Full time

    Our client are looking for a Senior Electrical Design Engineer to join their expanding team in Bury St Edmunds.Are you ready to apply Make sure you understand all the responsibilities and tasks associated with this role before proceeding.As a Senior Electrical Design Engineer, your responsibilities will include:Designing control panels and switchgear to meet...


  • Saint Leonards, United Kingdom East Sussex Healthcare NHS Trust Full time

    Job summary We would welcome applicants considering a trainee band 4 post (annex 21 would apply-discussed at interview) To undertake this training you will need to meet the following criteria: The minimum criteria to apply to the course (as per University of Brightonguidance. Please note that this course is also supported at East Sussex College...