This is a temporary contractor position for an existing vacancy.

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

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.

7+ years in data architecture/engineering

Deep cloud experience (AWS, Azure, or GCP)

Expert SQL and dimensional/data‑vault modelling

Experience leading enterprise data platform migrations.

Snowflake architecture, data modelling, RBAC & data governance, cloud networking & storage, cost optimization, stakeholder leadership. This role operates under a hybrid work model and requires employees to work from the office a minimum of two days per week.

#

📌 Data Engineer Contractor (Toronto)
🏢 Hydro One
📍 Toronto