Director, Cloud Data Lakehouse

Job Description What is the opportunity? You will join RBC Insurance’s Active Data Platform team, working with professionals dedicated to delivering solutions to the insurance business and its clients. The team embraces Agile development, DevOps, open‑source technologies, SaaS and modern tools and processes. Your work will have a visible impact on real, impactful projects. We are looking for an experienced and innovative Director of Data Engineering who will lead the strategy, architecture, and delivery of an Insurance Cloud Data Lakehouse using Snowflake. The role will enable advanced analytics, regulatory reporting and AI‑driven insights for the insurance business, combining deep technical leadership with strong business partnership. What will you do? Collaborate closely with insurance business leaders, product managers, data scientists and IT stakeholders to translate data needs into engineering priorities and deliver trusted, high‑quality data assets. Define and own the data engineering roadmap aligned with the enterprise data strategy and business transformation agenda. Design and implement a scalable, secure, and governed data Lakehouse on Snowflake, integrating structured, semi‑structured and unstructured data across distribution systems. Lead technical discussions and collaborate with enterprise architects to drive design and development of the target architecture for the cloud data lakehouse, integrating Snowflake, dbt, Kafka/streaming, and data model/governance layers. Oversee the design and deployment of the Snowflake‑based data lakehouse, partnering with business to prioritise data domains (Policy, Claims, Risk, Customer, Broker, etc.). Enable data sharing and consumption models for analytics, Power BI dashboards and AI/ML applications. Modernise legacy data environments into a unified cloud platform supporting real‑time analytics, self‑service BI and AI/ML workloads. Establish data engineering standards for the transformation journey, ensuring data quality in collaboration with Data Governance, Architecture and data consumers. Stay abreast of releases on the Snowflake platform, AI/ML, particularly Agentic AI and process automation, and evaluate applicability to the insurance sector. Establish and enforce robust data quality checks and monitoring frameworks, ensuring resilience, uptime and disaster recovery for all production systems. What do you need to succeed? Must Have 8+ years of data engineering experience, focusing on modern data stacks, Snowflake and cloud technologies. 3+ years in a leadership role managing high‑performing data engineering teams. Hands‑on experience with Snowflake, data modelling, warehousing and governance. Experience with cloud platforms (AWS, GCP, Azure). Strong understanding of data engineering principles: pipelines, architectures and workflows. Experience with data governance, security and compliance frameworks. Excellent communication and collaboration skills. Bachelor’s degree in Computer Science, IT or a related field. Nice to Have Experience with Apache Beam, Apache Spark or AWS Glue. Experience with DevOps practices and CI/CD pipelines. Knowledge of data science and machine learning concepts. Experience with agile development and Git. Snowflake, cloud computing or data engineering certification. Education Bachelor’s degree in Computer Science, Machine Learning, AI, Electrical Engineering or a related quantitative field. Master’s or Ph.D. preferred. What’s in it for you? A comprehensive Total Rewards Programme including bonuses, flexible benefits, competitive compensation, commissions and stock where applicable. Leadership development through coaching and management opportunities. Impactful, lasting contribution to clients and community. A dynamic, collaborative, high‑performing team. A world‑class training program in financial services. Flexible work/life balance options. Opportunities for challenging work and progressive accountabilities. Access to cross‑business and geographic opportunities. Additional Job Details Location: Meadowvale Business Park, 6880 Financial Dr, Mississauga, Canada Work hours: 37.5 hours/week Employment type: Full‑time, Regular, Salaried Platform: Technology and Operations Posted date: 2025‑11‑02 Application deadline: 2025‑11‑30 11:59 PM Inclusive Workplace / Equal Opportunity Employment At RBC, we believe in an inclusive workplace that values diverse perspectives. We uphold policies and programs that foster respect, belonging and opportunity for all employees, enabling them to perform at their best. All qualified applicants will receive consideration for employment without regard to race, colour, religion, creed, gender, sexual orientation, gender identity, age, marital status, national origin, citizenship, veteran status, disability, or any other protected characteristic. Join our Talent Community Stay informed about career opportunities at RBC. Sign up for custom updates on the latest jobs, career tips and recruitment events that matter to you. #J-18808-Ljbffr