Associate Director, Data Engineering
About the role
The Corporate Banking Operation Supervisory (CBOS) Technology group within RBC Capital Markets Quantitative and Technical Solutions builds business-focused solutions that optimize efficiency, automate processes, and enhance audit and compliance. As an Associate Director, Data Engineering, you will manage business requirements, stakeholder engagement, demos, validations, and cross-team coordination various functions to create a centralized reporting capabilities to provide business users insights and tracking capabilities. You will be responsible for the production, development, enhancement, and maintenance of centralized reporting systems across RBC’s lines of business. You will work in a fast-paced environment to comprehend, discover, and develop innovative solutions to address stakeholder business needs and opportunities. You will partner closely with our business partners to deliver management reports, financial reports, and statutory and regulatory reports that drive business decisions.
Responsibilities
- Accountable for the production, maintenance, and enhancements of required management reports, ensuring timely delivery and quality standards.
- Accountable for the development and delivery of scheduled, new, and ad hoc reports and change requests.
- Interact with business platforms to ensure accurate understanding of report requirements and provide timely responses to user requests.
- Ensure report quality standards are adhered to and continuous improvement initiatives are embedded within production and development.
- Maintain adequate and up-to-date documentation on report inventory, reporting processes, and related activities and components.
- Manage Key Performance Indicator (KPI) metrics and quality standards.
- Manage multiple competing priorities effectively, especially during intense period-end close cycles.
- Establish and maintain self-service multi-environment infrastructure with ability to translate business requirements into detailed technical specifications and governance frameworks.
- Mentor junior engineers and team members to enhance the collective technical expertise of the team.
Requirements
- Bachelor’s degree or Master’s degree in Computer Science, Analytics, Engineering, Accounting, Finance, or Finance/Accounting designation or equivalent education and experience.
- 4+ years of experience in analyzing existing code and refactoring to optimize codebases for enhanced performance and scalability.
- Database development and interaction with databases using Object-Relational Mapping (ORMs) and raw queries.
- 3+ years’ experience in Python Data Analysis and Visualization, including Matplotlib, Seaborn, Tableau, and Power BI.
- Python Data Manipulation and ETL Pipelining, using Pandas, Numpy and pySpark.
- Custom ETL pipeline development using Apache Airflow and Dagster.
- Creating and managing databases with SQL and NoSQL technologies such as PostgreSQL, MySQL or MongoDB.
- Visualization using tools such as Tableau, Power BI, or Looker.
- Proficiency with DAX Studio for data modeling and optimization.
- Experience with network drive management and data storage administration.
- Data platform development and optimization using Python, R, or Scala for building scalable data infrastructure and supporting advanced analytics workflows.
- Strong analytical, problem-solving, written, oral, and presentation skills with ability to assess stakeholder and project communication needs and deliver results on time.
- Solid project and time management capabilities with proven ability to manage multiple concurrent tasks and deadlines while maintaining high quality standards.
- Quick learner capable of grasping new reporting tools within a short time frame.
Qualifications
- Must-Have Qualifications: Bachelor’s degree or Master’s degree in Computer Science, Analytics, Engineering, Accounting, Finance, or Finance/Accounting designation or equivalent education and experience.
- 4+ years of experience in analyzing existing code and refactoring to optimize codebases for enhanced performance and scalability.
- Database development and interaction with databases using Object-Relational Mapping (ORMs) and raw queries.
- 3+ years’ experience in Python Data Analysis and Visualization, including Matplotlib, Seaborn, Tableau, and Power BI.
- Python Data Manipulation and ETL Pipelining, using Pandas, Numpy and pySpark.
- Custom ETL pipeline development using Apache Airflow and Dagster.
- Creating and managing databases with SQL and NoSQL technologies such as PostgreSQL, MySQL or MongoDB.
- Visualization using tools such as Tableau, Power BI, or Looker.
- Proficiency with DAX Studio for data modeling and optimization.
- Experience with network drive management and data storage administration.
- Data platform development and optimization using Python, R, or Scala for building scalable data infrastructure and supporting advanced analytics workflows.
- Strong analytical, problem-solving, written, oral, and presentation skills with ability to assess stakeholder and project communication needs and deliver results on time.
- Solid project and time management capabilities with proven ability to manage multiple concurrent tasks and deadlines while maintaining high quality standards.
- Quick learner capable of grasping new reporting tools within a short time frame.
Skills
- Agile Engineering
- Agile Methodology
- API Development
- Business Analysis
- Cloud Architectures
- Collaboration
- Communication
- Database Administration
- Database Architecture
- Data Pipelines
- Decision Making
- ETL Development
- Group Problem Solving
- Leadership
- Long Term Planning
- Performance Optimizations
- Problem Solving
- Stakeholder Management
- System Integration
- Teamwork
- Technical Leadership
- Time Management
Benefits
Comprehensive Total Rewards Program include competitive compensation and flexible benefits, such as 401(k) program with company-matching contributions, health, dental, vision, life, disability insurance, and paid-time off. 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. Opportunities to do challenging work. Opportunities to build close relationships with clients.
Pay
The expected salary range for this particular position is $120,000 - $200,000 depending on your experience, skills, and registration status, market conditions and business needs. You have the potential to earn more through RBC’s discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided the business meets its performance targets and you meet your individual goals.
Schedule
Work hours/week: 40
Employment Type
Full time
Platform
CAPITAL MARKETS
Job Type
Regular
Pay Type
Salaried
Note
Applications will be accepted until 11:59 PM on the day prior to the application deadline date above
Additional Job Details
Address: GOLDMAN SACHS TOWER, 30 HUDSON STREET
JERSEY CITY
City: Jersey City
Country: United States of America