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.
#J-18808-Ljbffr
Data Platform Architect in Toronto employer: Hydro One Inc.
Hydro One is an exceptional employer that values its employees by fostering a collaborative and inclusive work culture in Ontario's vibrant energy sector. As a Senior Buyer, you will benefit from comprehensive professional development opportunities, competitive compensation, and a commitment to community safety, all while working for a company dedicated to delivering reliable electricity services. Join us to make a meaningful impact in the lives of Ontarians and grow your career in a supportive environment.
