Data Warehouse Architect & Power BI Specialist (Hybrid)

Celestica; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading technology solutions provider in Toronto is looking for a Data Warehouse Developer to design and maintain scalable data warehousing solutions. The role requires 5+ years of experience with data lakes and pipelines. Candidates should have strong knowledge of SQL and Power BI, and a Bachelor's degree in a relevant field. This hybrid position supports data-driven decision-making in the HR sector.

Benefits

Equal Opportunity Employer

Inclusive work environment

Qualifications

• 5+ years of hands-on professional experience in a data-focused role.
• Expert-level knowledge of data modeling concepts.
• Experience with modern data warehousing platforms.

Responsibilities

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

Skills

Data modeling

ETL/ELT processes

Database optimization

BI tools

SQL proficiency

Python programming

Power BI expertise

Data governance

Collaboration skills

Education

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

Tools

Azure Synapse

Google BigQuery

Power BI

Jupyter

Databricks

Job description

A leading technology solutions provider in Toronto is looking for a Data Warehouse Developer to design and maintain scalable data warehousing solutions. The role requires 5+ years of experience with data lakes and pipelines. Candidates should have strong knowledge of SQL and Power BI, and a Bachelor's degree in a relevant field. This hybrid position supports data-driven decision-making in the HR sector.