Sr. Data Architect, Enterprise Data Platform

Responsibilities

• Work with Investment Management stakeholders to understand requirements and define solutions to address them.
• Work with product and domain stakeholders to translate analytical and operational requirements into Snowflake-first data solutions (schemas, marts, data products, and pipelines), iterating quickly as needs evolve.
• Partner with Enterprise Architecture to define target-state patterns for Snowflake (data modeling, layering/medallion, data sharing, and secure-by-design standards) and ensure alignment to enterprise standards.
• Define and maintain Snowflake platform reference architectures and reusable implementation patterns (e.g., onboarding templates, naming conventions, security patterns, and data product standards) and socialize them across engineering teams.
• Drive architecture governance for major data initiatives by documenting architecture decisions and tradeoffs, reviewing designs for alignment to standards, and escalating risks or gaps with pragmatic mitigation plans.
• Provide technical leadership across teams by aligning stakeholders on standards and outcomes, mentoring engineers on platform best practices, and representing the data platform in cross-functional forums.
• Own Snowflake platform configuration and optimization: warehouses & sizing, resource monitors, query profiling, clustering/materialized views where appropriate, and cost/performance tuning.
• Implement Snowflake access management and security controls (RBAC/roles, grants, least privilege, secure views, masking/row access policies as applicable) and support governed subscription/onboarding processes.
• Design and build scalable data architectures and data products with Snowflake as the core platform, balancing performance, cost, reliability, and governance.
• Enable AI/ML capabilities by supporting AI/ML agents and governed semantic models for analytics and decisioning.
• Participate in design sessions and code reviews; troubleshoot production issues end-to-end (pipelines, Snowflake objects, and workloads) and iterate quickly to restore service and improve reliability.
• Define and implement consumption patterns for BI and analytics (e.g., Power BI), including semantic models, performance best practices, and governed access to Snowflake-backed datasets.
• What you bring:
• 12+ years of proven hands-on experience as a Data Architect building modern data platforms and pipelines in AWS platform.
• 4+ yrs deep hands-on Snowflake experience, including access management (RBAC/ro

Benefits

Additional Information

Why you'll love working here: high-performance, people-focused culture our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees' career growth membership in HOOPP's world class defined benefit pension plan, which can serve as an important part of your retirement security competitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team's diversity and mental health (e.g., gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, parental leave top-up, and a health spending account). optional post-retirement health and dental benefits subsidized at 50% yoga classes, meditation workshops, nutritional consultations, and wellness seminars the opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workers Job Summary The Sr. Data Architect is responsible for Strategy, Architecture, implementation, and optimization of scalable data architecture and data pipelines, with a primary focus on the Snowflake platform. This role owns key Data Platform and Snowflake capabilities including access management (RBAC, roles, grants), performance and cost tuning (warehouses, clustering, query optimization), and enablement of AI/ML capabilities. The candidate is also responsible for design and implementation of production-grade data pipelines and data products using Python and PySpark, partnering with business stakeholders (for example Investment Management) and technology teams to deliver secure, governed, and high-performing solutions in a fast-moving environment. This role owns the enterprise architecture definition of the Enterprise Data Platform by defining the target-state architecture, establishing reference architectures and standards, shaping multi-quarter roadmaps, and leading architecture governance to ensure solutions remain aligned to enterprise security, risk, and compliance requirements across domains. The role applies enterprise architecture frameworks and governance practices (e.g., reference architectures, standards, and decision records) to drive consistent outcomes across teams.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at hoopp? Share your experience