Developer, IT Risk Management Reporting - Halifax

As the Developer, IT Risk Management Reporting at RBC, your main responsibilities will include developing and maintaining Tableau dashboards, writing Python scripts for data automation, optimizing SQL queries, collaborating with stakeholders to gather requirements, and ensuring the accuracy of data in reporting and analytics. You’ll also enhance data pipelines and troubleshoot any issues related to dashboard performance and data integrity.

To succeed in the Developer, IT Risk Management Reporting role at RBC, you need a bachelor’s degree in Computer Science or a related field, proven experience in data analytics and Tableau development, strong Python programming skills, and in-depth knowledge of SQL. Experience in data engineering and familiarity with tools such as Docker and Kubernetes will further enhance your candidacy.

While prior experience in IT risk management is considered a nice-to-have for the Developer position at RBC, it is not mandatory. What is essential is a solid background in data analytics, Tableau, and Python, along with a keen interest in IT risk management.

In the Developer, IT Risk Management Reporting role at RBC, you will work with a variety of advanced technologies, including Tableau for data visualization, Python for creating scripts, SQL for database management, and tools like DataBuildTool (dbt) and Kubernetes for data engineering and orchestration.

RBC offers extensive opportunities for professional development and growth for the Developer, IT Risk Management Reporting role. You’ll have access to coaching and training programs, a chance to work with innovative technologies, and a dynamic team environment that encourages collaboration and innovation, allowing you to advance in your career.

When asked about your Tableau experience, focus on specific projects where you developed dashboards. Discuss your process, the types of data visualizations you created, and how those dashboards aided decision-making in a business context to showcase your practical application.

In answering this question, detail your methodology for scripting in Python, from defining the problem to coding and testing. Mention libraries you use, such as Pandas or NumPy, and give examples of scripts you've written, including challenges you faced and how you resolved them.

Highlight your proficiency in SQL by discussing your experience with crafting complex queries for data extraction and manipulation. Provide examples of projects where you optimized SQL queries for efficiency and how that impacted data processing speed.

Stress the importance of data validation and testing in your reporting processes. Line out the steps you take to verify data accuracy, including using checks and balances in your dashboards, conducting routine audits, and how you troubleshoot inaccuracies when they arise.

Describe a specific data engineering challenge you've faced, such as optimizing a data pipeline or resolving data inconsistencies. Discuss the steps you took to analyze the problem, implement a solution, and the positive outcomes of your method.

List the tools you're proficient in, such as Tableau, dbt, and Docker. Provide context around how you've used these tools in previous roles, including specific projects or outcomes achieved through their application.

Speak about your approach to project management. Consider discussing how you assess project importance, time requirements, and available resources to determine priorities, while emphasizing your ability to adapt to changing deadlines or business needs.

Share your strategies for staying current, such as following industry blogs, participating in webinars, attending conferences, and joining professional organizations. Talk about how you apply what you learn to your work to improve practices and introduce innovative solutions.

Explain your experience collaborating with cross-functional teams, such as stakeholders and other developers. Emphasize your communication skills, ability to gather requirements, and how collaborative efforts lead to better project outcomes.

Reflect on your motivation for wanting to work specifically in IT risk management at RBC. Mention the company’s reputation, the impact you can make in risk strategies, and how the collaborative culture aligns with your professional values and career aspirations.