HR Data Engineering Analyst - Snowflake

Location

Brookfield Place - 181 Bay Street

Brookfield Culture

Brookfield has a unique and dynamic culture.  We seek team members who have a long-term focus and whose values align with our Attributes of a Brookfield Leader:  Entrepreneurial, Collaborative and Disciplined.  Brookfield is committed to the development of our people through challenging work assignments and exposure to diverse businesses.

Job Description

Human Resources Services (HRS) is an internal function providing global operations and business support across Brookfield’s lines of business.

We are seeking a proactive and technically proficient HR Data Engineering Analyst to join our Human Resources Shared Services team. This role will focus exclusively on enabling HR data solutions and reporting capabilities across our global workforce by leveraging Snowflake as the centralized enterprise data platform. 

The ideal candidate will support the ingestion, modeling, and optimization of HR data assets—such as employee demographics, compensation, benefits, time tracking, and payroll—ensuring accuracy, scalability, and alignment with enterprise-wide reporting and compliance requirements. This role provides an excellent opportunity to build foundational expertise in cloud data engineering within a mission-critical function. 

This position is based out of our downtown Toronto office, and requires onsite work at our office five days per week.

What You Will Do 

• Build and maintain ETL/ELT data pipelines in Snowflake to support HR analytics, compliance, and operational reporting 

• Support the integration and transformation of data from HRIS, payroll, benefits administration, and third-party vendors into Snowflake 

• Develop and optimize HR data models, ensuring efficient structures for reporting on headcount, turnover, benefits, compensation, and organizational structure 

• Partner with HRIS, Total Rewards, Payroll, and Workforce Planning teams to understand data needs and develop scalable solutions 

• Ensure data quality, validation, and reconciliation across systems, including control frameworks for sensitive and regulated data 

• Assist with building secure, governed data views for internal stakeholders while complying with data privacy and protection policies (e.g., PII, GDPR) 

• Document technical specifications, data dictionaries, and transformation logic for HR datasets and workflows 

• Support troubleshooting, monitoring, and performance tuning of Snowflake processes and queries 

• Contribute to agile sprint planning and execution as part of the HR Technology or HR Analytics function 

• Maintain familiarity with evolving HR data standards and reporting regulations (e.g., EEO, DEI, ACA, OSHA) 

Qualifications and Skills 

• Bachelor’s degree in Computer Science, Information Systems, HR Technology, Data Analytics, or related field 

• 1–3 years of experience in data engineering, HR analytics, or HR systems (internships/co-ops considered) 

• Strong SQL proficiency; working knowledge of Python for scripting and automation 

• Hands-on exposure to Snowflake, including schema design, data loading, and query optimization 

• Familiarity with common HR systems (e.g., Workday, UKG, ADP) and HR data structures 

• Understanding of ETL/ELT workflows, data modeling, and integration design 

• Knowledge of data privacy best practices related to handling employee data 

• Experience with data orchestration tools such as Workato, dbt, or similar preferred 

• Strong analytical mindset with attention to detail and commitment to data integrity 

• Effective communicator with ability to partner across HR, Finance, and Technology stakeholders 

• Snowflake or cloud platform certification is a plus 

Brookfield is committed to maintaining a Positive Work Environment that is safe and respectful; our shared success depends on it.  Accordingly, we do not tolerate workplace discrimination, violence or harassment.

Brookfield is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act. Should you require a Human Rights Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs.