Manager, Data Analyst, CFO Group
About The Position
This is an exciting opportunity in CFO Group where you will play an instrumental role in leveraging RBC’s strategic data assets to build automation solutions and data analytics models. We are currently seeking for an individual with strong data/business analysis background who is quick to adapt to new technologies and enthusiastic about developing innovative solutions to support the digital transformation in Finance. This role will work with various stakeholders in helping to identify business problems and prioritize them to unlock business value. The Data Enablement team is focused on developing strategic solutions to support key Report to Shareholder and Regulatory Reporting initiatives across the bank. Our team consists of highly accomplished professionals with various backgrounds in computer science, data engineering, business analytics, accounting and finance to deliver innovative solutions that supports data-driven decisions. We are hiring multiple Manager roles with areas of focus including: Personal Banking and Commercial Banking business and products Capital Markets business and products International Banking (U.S. and Caribbean) Insurance and Corporate Support business and products Wealth Management business and products
Requirements
- Demonstrated experience with data extraction, transformation, and loading from a wide variety of data sources using SQL and related technologies (Oracle, Vertica, Hive, etc).
- Working knowledge in implementing and performance tuning ETL pipelines using Dagster, Apache Airflow or Prefect.
- Proficiency in Python, specifically Pandas, Sqlalchemy, Numpy and Selenium packages.
- Excellent analytical skills & critical thinking skills to investigate system and business issues, determine root cause, and deliver sustainable solutions.
- Commitment to continuous improvement; specifically, ability to identify existing processes and gaps across the current system landscape.
Nice To Haves
- Experience in RBC IT systems and service platforms (e.g. Core, Confluence, ServiceNow, Access Manager).
- Open to learn and innovate using tech stack or framework like Flask, Django and any front-end framework.
- Experience in managing Windows Servers using IIS.
- Proficiency in Excel VBA.
- Experience with Business Intelligence Reporting & visualizations using Tableau.
- Basic knowledge of git, APIs, Docker and/or DevOps.
Responsibilities
- Work closely with subject matter experts to document detailed business requirement, and ensures requirements are in line with business goals and objectives
- Analyze large data sets and system extracts to build business rules behind automated data pipelines
- Using SQL to understand data sets about different systems and extract data
- Identify, analyze implications and communicate program issues, risks and dependencies, so that they can be appropriately mitigated
- Work collaboratively with cross-functional teams and develop and manage relationship with relevant stakeholders
- Manage, communicate and author changes to the requirements
- Design, develop and test reporting solutions and reconciliation processes using Python
- Develop and execute tests, log and track issues and drive them to resolution with verification of bug fixes, document test results and research findings
- Develop scripts as needed to assist in the systems validation process
- Integrate with existing data storage solutions
- Coordinate with front-end developers and data engineers
Benefits
- Opportunities to do challenging work utilizing latest technologies
- Opportunities to see measurable results in relatively short term
- Opportunities to take on progressively greater accountabilities
- Opportunities to building close relationships with counterparts across the bank
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Manager
Education Level
No Education Listed
