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
Sr. Manager, Data Solution Design & Integration
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...
Sr. Manager, Data Solution Design & Integration
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...
Sr. Gen AI GTM Specialist Solutions Architect, Data & AI GTM
Are you a customer-obsessed builder with a passion for helping customers achieve their full potential? Do you have the business savvy, Data & AI background, and sales skills necessary to help position AWS as the cloud provider of choice for customers? Do you love building new strategic and data-driv...
Sr. Manager, Data Engineer SRE
SRE, DevOps, or related roles, with a focus on cloud-based infrastructure (Azure, AWS, or GCP only) and automation. Established SRE as a practice within an organization. ...
Sr. Manager, MarTech & Data Intelligence
Build an MMM model establishing best in class practices for data collection, data centralization, data processing, data analysis & activation. Manager of MarTech & Data Intelligence, you will be the architect of our digital marketing tech stack and data strategy. Profound knowledge of the la...
Sr. Manager, Marketing Data Science
At Thumbtack, we have built a rigorous, data-driven Marketing program that uses a combination of quantitative data, sophisticated technology, and human ingenuity to bring users to Thumbtack and keep them coming back. As our Senior Manager of Marketing Analytics, you will be the senior-most marketing...
Project Data Manager/sr Project Data Manager
Acts as Functional Lead for Data Management including primary contact for internal liaison between Data Management/Operations and Project Management, Clinical Monitoring, and other functional groups. Coordinate the work of the assigned Data Management/Data Operations team. Experience of Clinical Dat...
Sr. Manager, Wealth Data Management & Governance
Manager role will work closely with the Data Management Lead providing strategic input and recommendation to evolve the overarching Wealth Management Data Governance Program – in alignment with enterprise-wide data principles to enable robust data quality and reduce overall data risk. Additionally, ...
Sr. Manager Physical Design CAD Methodology
Strong technical manager experience managing Physical Design team at IP/SoC level with multiple successful tapeouts in advance technodes (10nm and below). Strong technical manager experience managing Physical Design team at IP/SoC level with multiple successful tapeouts in advance technodes (10nm an...
Sr. Manager, Data Science
Manager, Data Science will join the Data Insights & Monetization leadership team to enable the organization with industry-leading data science capabilities to optimize the customer experience. Act as the Data Science and Machine Learning subject matter expert with a deep understanding of models/algo...