Data Platform Architect

Hydro One Inc.; Toronto; Híbrido; CAD 120.000 - 190.000; A tiempo parcial

Descripción de la vacante

Hydro One Inc. is seeking a senior data architect to own the end-to-end Snowflake environment design, ensuring secure, scalable, and cost-efficient enterprise data services. You will define target architectures, patterns, and governance in partnership with security and governance teams.

Lead design reviews, provide escalation support to engineering, and drive platform adoption of new Snowflake features. Hybrid work model with two office days per week is required.

Formación

• 7+ years in data architecture/engineering.
• 2+ years hands-on Snowflake.
• Deep cloud experience (AWS, Azure, or GCP).
• Expert SQL and dimensional/data-vault modelling.
• Strong grasp of security, governance, and cost-management frameworks.
• Experience leading enterprise data platform migrations.
• SnowPro Advanced: Architect certification strongly preferred.

Responsabilidades

• Own end-to-end design of Hydro One's Snowflake environment and ensure it scales securely and cost-effectively.
• Define target-state data architecture, including account/warehouse topology, database and schema layout.
• Establish reusable design patterns, naming standards, and frameworks for ingestion, transformation, data modelling, and secure data sharing.
• Set guardrails for security, RBAC, masking, row-access policies, and data governance with security teams.
• Design for cost efficiency—warehouse sizing, auto-suspend/resume, resource monitors, workload isolation.
• Provide technical oversight, lead design reviews, and act as second-level support for engineering teams.
• Own the platform roadmap: evaluate new Snowflake features and adoption timing.

Conocimientos

Snowflake architecture

Data architecture

Cloud platforms

SQL and data vault modelling

RBAC and governance

Cost optimization

Enterprise migrations

SnowPro Advanced certification

Herramientas

Snowflake

Descripción del empleo

This is a temporary contractor position for an existing vacancy.

Mission: Own the end-to-end design of Hydro One's Snowflake environment and ensure it scales securely and cost-effectively across the enterprise.

Key responsibilities:

• Define the target-state data architecture, including account/warehouse topology, database and schema layout, and a promotion strategy across dev, test, and production environments.
• Establish reusable design patterns, naming standards, and frameworks for ingestion, transformation, data modelling (e.g., medallion / data-vault), and secure data sharing.
• Set guardrails for security, role-based access control (RBAC), masking, row-access policies, and data governance in partnership with security and governance teams.
• Design for cost efficiency — warehouse sizing standards, auto-suspend/resume policies, resource monitors, and workload isolation.
• Provide technical oversight, lead design reviews, and act as second-level support and escalation point for engineering teams.
• Own the platform roadmap: evaluate new Snowflake features and define how and when Hydro One should adopt them.

Qualifications:

• 7+ years in data architecture/engineering
• 2+ years hands‑on Snowflake
• Deep cloud experience (AWS, Azure, or GCP)
• Expert SQL and dimensional/data‑vault modelling
• Strong grasp of security, governance, and cost‑management frameworks
• Experience leading enterprise data platform migrations.
• SnowPro Advanced: Architect certification strongly preferred.
• Snowflake architecture, data modelling, RBAC & data governance, cloud networking & storage, cost optimization, stakeholder leadership. Success metrics (first 6?12 months): Approved reference architecture in place, environment strategy operational, and documented standards adopted by all engineering teams.

This role operates under a hybrid work model and requires employees to work from the office a minimum of two days per week.