Senior Data Engineer

Job Description

Job Description What is the opportunity? RBC’s Data Analytics and Insights Team is responsible for developing and implementing automated processes, creating applications, and building dashboards to assist in decision making. We work alongside the teams within Workplace Technologies Platforms to create intuitive and insightful reporting and self-serve applications to allow stakeholders quick and easy access to important KPIs. We aim to drive decision-making through key insights, reduce manual work, and build automation to increase overall productivity and set best-in-class standards. What will you do? Designs, develops, and optimizes data solutions, ensuring the delivery of high quality data assets, reporting, and business intelligence to support organizational objectives Collaborates with business and technology teams to design and implement data solutions and dashboards, ensuring alignment with organizational strategies and compliance standards. Develops, tests, and deploys complex data and software architectures to generate reusable data assets, enabling advanced analytics and reporting capabilities. Leads the creation and maintenance of data architectures, pulling data through APIs, and ingesting and producing reports in Tableau, PowerBI, Kibana Provides strategic guidance on emerging technologies and best practices, contributing to the continuous improvement of data engineering processes and tools. Leads data engineering tasks or projects requiring advanced problem solving and decision making, navigating ambiguity. Drives decisions on issues requiring innovative thinking and technical expertise and providing recommendations that influence own team and across other work areas. Independently resolves data engineering related problems by identifying areas for improvement and implementing solutions that enhance efficiency within scope of responsibility. Maintains and enhances relationships with internal teams and external contacts to deliver measurable business outcomes. What do you need to succeed? Must have: Bachelor’s degree in computer science, software engineering, or equivalent 5 years’ experience developing scalable code using Python 3 years' experience with Elastisearch Stack (Logstash, Elasticsearch, Kibana) 5 years’ experience with relational/non-relational databases (MSSQL) Proficient in extracting data through APIs and writing code in Python, Logstash, and SQL for creating ETL processes Experience with creating dashboards in PowerBI, Tableau, Elastic/Kibana, and Grafana Nice-to-have : Experience building and executing machine learning pipelines Experience with or knowledge of Agile and Design Thinking Software Development methodologies. What’s 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 achievi

Required Skills