Sr. Manager, Data Solution Design & Integration

Job Summary

Job Description

What is the opportunity?

RBC, one of Canada's largest and most respected employers, is looking for a Data Professional to join our growing team of Talent Data and Analytics experts.

You are a technical expert who will help expand and optimize our data architecture and pipelines, but also an experienced data wrangler who enjoys optimizing data systems to support not only software developers, database architects, data analysts, and data scientists but also business partners, data governance professionals and subject matter experts within HR and RBC's businesses and functional groups.

The right candidate will be excited by the prospect of optimizing our company's HR data architectures to support our next generation of applications including both cloud-based HRIS systems (Workday) as well as on-premise streaming data and reporting warehouses and platforms to help drive better talent insights from our data.

You are a multi-talented data professional who can embrace architecture, analytics, modeling, and development, are comfortable collaborating with HR and business subject matter experts have a keen ability to translate business needs into requirements documents, technical solutions and storytelling insights.

What will you do?

Research, develop, deploy and maintain end-to-end talent data and analytics solutions maximizing data pipelines and architectures to provide actionable talent metrics and insights (datasets, visualizations, dashboards) to serve business, HR and team needs

Identify, design, and implement internal process improvements : automating manual processes, orchestrating and optimizing data delivery across various cloud-based and on-premise data platforms, re-designing data models for greater scalability, etc.

Build on and optimize the existing foundation of data pipeline architectures required for optimal extraction, transformation, and loading of data from a wide variety of data sources using various methods, programming languages, and software technologies, adjusting as needed to optimize effectiveness.

Support the construction of a common repository of HR data knowledge including data dictionaries, dimension and measure definitions, platform cross walks and basic governance and lineage.

Manage project risks, issues, and decisions related to data requirements, ensuring proper steps are taken to mitigate, escalate, and communicate detailed updates to leadership

Contribute to and review project documents, ensuring alignment between Business, Strategic, and HR data requirements, and contribute to successful data solution delivery by managing priorities, timelines, dependencies, critical paths, and solution design

What do you need to succeed?

Must have :

7+ years of advanced working experience with relational databases (including Teradata, SQL Server, MySQL or similar)

7+ years of advanced experience with Microsoft Excel

Expertise with object-oriented language for use with data access, data manipulation, ETL, APIs, text mining, and light analytics (including Python, VBA)

Expertise with cloud computing-based data platforms like Snowflake

Strong management, organizational, critical thinking, analytical, communication and negotiation skills

Nice-to-have

Experience with data visualization tools such as Tableau or Power BI

Graduate degree in Computer Science, Statistics, Information Systems, Physics or related quantitative field.

5+ years of experience in a Data Engineering or equivalent role

What's 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 and flexible benefits, competitive compensation, commissions, and stock where applicable

Leaders who support your development through coaching and managing opportunities

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 work / life balance options

Opportunities to do challenging work

Job Skills

Analytical Thinking, Big Data Management, Cloud Computing, Data Analysis, Database Development, Data Mining, Data Warehousing (DW), ETL Processing, Group Problem Solving, Python (Programming Language), Quality Management, Requirements Analysis, SQL Databases, Structured Query Language (SQL), Visualization Tools