We are building a governed consumption layer on our Snowflake data platform, a curated set of business-aligned data products and semantic definitions that make enterprise data trustworthy, discoverable, and usable at scale. This role sits at the boundary between data engineering and business consumption. You will define what "ready to use" means for our data, lead the team that builds it, and work closely with our Data Platform & Engineering team who owns the underlying data models, platform services, and production deployment.

You bring hands-on experience with the up-to-date data stack, have built or led semantic/consumption layers before, and have evolved into a leader who can translate business needs into governed data products. You understand that the future of analytics is self-serve and increasingly AI-assisted, and that a well-defined semantic layer is what makes that future reliable. Design, deliver, and govern business-ready views and data products on Snowflake, defining entities, metrics, and datasets that serve BI, operational systems, and AI applications with consistent, trusted definitions.

Partner with Data Platform & Engineering: Work daily with the team that owns data modeling and platform infrastructure. They own the contracted data models and production deployment; Work with BI analysts and data consumers to identify needs, prioritize data product development, and ensure the layer evolves based on real usage. Establish governance criteria for the consumption layer, naming conventions, metric definitions, testing, documentation, lineage, access policies, and maintain them as the platform scales.





Work with IT partners on security, compliance, and infrastructure; align with AI programs on data requirements. Enable self-serve and AI-readiness: Position the semantic layer as the foundation for self-serve analytics and generative AI use cases (text-to-SQL, contextual retrieval), where correctness depends on embedded business context rather than user expertise.

Technical depth: Hands-on SQL experience and fluency with modern transformation tools (dbt or equivalent) on cloud data warehouses (Snowflake required). You have built or led a semantic layer, data products function, or governed mart/reporting layer before. You know the difference between a data model and a data product, and you've navigated that boundary in practice.

Experience working alongside (not above) data engineering or platform teams, shared standards, code review across team boundaries, joint delivery accountability. Proven experience managing analytics engineers or similar technical roles. Track record of building small teams that deliver disproportionate impact through standards and leverage, not headcount.

Ability to prioritize based on business value, communicate trade-offs to non-technical stakeholders,



and drive adoption of governed data products over ad-hoc alternatives.

Experience establishing data governance, quality, and access standards in large or regulated organizations. Ability to define long-term direction while delivering incrementally. Familiarity with AI/ML feature stores or LLM context layers.

Experience defining RBAC or row/column-level security policies on Snowflake. A Total Rewards program that includes flexible benefits, work/life balance and career development programs and investment and retirement savings plans Competitive pay and high-earning potential All the tools, training, and team support you need to grow your business and career Flexible work/life balance options RBCI software tools to boost your productivity and grow your business Agile Product Development, Communication, Customer Service, Customer Success, Decision Making, Group Problem Solving, Leadership, Long Term Planning, Teamwork, Time Management Full time You have the potential to earn RBC's discretionary variable compensation program which gives you an opportunity to increase your total compensation, provided that business meets its performance targets and you meet your individual goals. Maintaining a workplace where our employees feel supported to perform at their best, effectively collaborate, drive innovation, and grow professionally helps to bring our Purpose to life and create value for our clients and communities.

RBC strives to deliver this through policies and programs intended to foster a workplace based on respect, belonging and opportunity for all. #

📌 Director, Data Products & Semantics (Mississauga)
🏢 ODAIA
📍 Mississauga