Associate Director, Data Engineering

RBC•Jersey City, NJ

5d•$120,000 - $200,000•Onsite

About The Position

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.

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.
Curiosity and continuous learning mindset: Proactive approach to developing new skills and staying current with evolving tools and technologies.
Openness to change and adaptability: Comfort with evolving platforms, methodologies, technology and business requirements.
Business Domain Expertise & Adaptability: Deep understanding of Capital Markets business domains and the ability to quickly adapt to evolving business group requirements, translating business needs into technical solutions including rapid development and deployment of ad hoc dashboards and reports.
Cross-functional collaboration and stakeholder management: Ability to work effectively across RBC’s lines of business and partner with senior leadership.
Detail-oriented with strong problem-solving and validation rigor: Ability to identify issues, validate data accuracy, and implement robust solutions in a complex reporting environment.
Ability to manage multiple competing priorities: Particularly during intense period-end close cycles.
Business Systems & Change Management: Business Systems and Change Management expertise including the oversight of production Change Requests (CRs), documentation, approvals, and Post-Implementation Validation (PIV) to ensure seamless deployments.
Strong communication skills: Ability to clearly articulate technical and reporting concepts to teams and senior leadership.

Nice To Haves

Experience in AI implementations or leveraging AI tools for testing
Exposure to performance testing and system monitoring tools
Experience with task scheduling and workflow automation tools such as Windows Task Scheduler, Control-M, or equivalent orchestration platforms
Containerization experience using Docker and Kubernetes
Quick learner with ability to pick up new technologies, tools, and business knowledge
Ability to facilitate between and influence key decision makers
Strategic thinker with excellent interpersonal skills to work across functions and businesses

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.