Lead Data Engineer
Lead Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Summary
Job Description
Job Description
What is the opportunity
RBC one of Canadas 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 RBCs businesses and functional groups. The right candidate will be excited by the prospect of optimizing our companys 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:
- Exceptional collaboration skills are essential the ideal candidate thrives in team environments communicates effectively across functions and actively contributes to shared goals
- 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
- Proficient in Snowflake SQLand Snowflake UI
- Experience with Snowflake architectureand components (e.g. virtual warehouses stages databases schemas)
- Experience with enterprise job scheduling and orchestration tools such as Rundeck Stonebranch or equivalent to automate and manage data workflows and operational tasks.
- 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
Whats 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
- Opportunities to do challenging work.
#LI-Post
#LI-PK
#TECHPJ
Job Skills
Analytical Thinking Application Requirements Analysis Big Data Management Cloud Computing Cloud Computing Management Data Analysis Database Application Development Database Development Data Mining Data Warehouse ETL Data Warehousing (DW) Data Warehousing Systems ETL Processing Group Problem Solving Python (Programming Language) Quality Management Quality Management Standards Requirements Analysis SQL Databases SQL Data Mining Structured Query Language (SQL) System Requirements Analysis Team Problem Solving Visualization ToolsAdditional Job Details
Address:
City:
Country:
Work hours/week:
Employment Type:
Platform:
Job Type:
Pay Type:
Posted Date:
Application Deadline:
Note: Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
Inclusion and Equal Opportunity Employment
At RBC we believe an inclusive workplace that has diverse perspectives is core to our continued growth as one of the largest and most successful banks in the world. Maintaining a workplace where our employees feel supported to perform at their best effectively collaborate drive innovation and grow professionally helps to bring our Purpose to life and create value for our clients and communities. RBC strives to deliver this through policies and programs intended to foster a workplace based on respect belonging and opportunity for all.
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.
Expand your limits and create a new future together at RBC. Find out how we use our passion and drive to enhance the well-being of our clients and communities at .
Employment Type
Full-Time
