Senior Data Warehouse Engineer for HR Analytics

Celestica Inc.; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading technology firm in Toronto is seeking a Data Warehouse Developer to design and maintain data warehousing solutions that enable data-driven decision-making. The ideal candidate will have 5+ years of experience in data modeling, ETL processes, and proficiency in tools such as Azure Synapse and Power BI. Collaboration with stakeholders and the ability to optimize data quality are crucial for this role.

Qualifications

• 5+ years of hands-on experience in a data-focused role.
• Expert-level knowledge of data modeling concepts.
• Strong proficiency in SQL and experience with both relational and NoSQL databases.

Responsibilities

• Identify and enable data sources with HR stakeholders.
• Create and maintain ERDs and data models.
• Design, build, and maintain data warehouse architectures.

Skills

Data modeling

ETL/ELT processes

Database optimization

Power BI

SQL

Python

Data governance

Problem-solving

Collaboration

Education

Bachelor's degree in Computer Science, IT, or related field

Tools

Azure Synapse

Google BigQuery

Jupyter

Databricks

Job description

A leading technology firm in Toronto is seeking a Data Warehouse Developer to design and maintain data warehousing solutions that enable data-driven decision-making. The ideal candidate will have 5+ years of experience in data modeling, ETL processes, and proficiency in tools such as Azure Synapse and Power BI. Collaboration with stakeholders and the ability to optimize data quality are crucial for this role.