Data Warehouse Developer

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

Overview

Req ID: 128916

Remote Position: Hybrid

Region: Americas

Country: Canada

State/Province: Ontario

City: Toronto

Summary

The Data Warehouse Developer is responsible for designing, developing, and maintaining scalable and efficient data warehousing solutions. This role is crucial for enabling data-driven decision-making by structuring and optimizing data to support business intelligence, reporting, and analytical needs. The ideal candidate will have hands-on experience with data modeling, ETL/ELT processes, and database optimization as well as experience with BI and reporting tools such as PowerBI, preferably in the HR space.

Responsibilities

• Data sourcing: Identify and enable data sources, collaborating with HR stakeholders to understand business needs and data required to satisfy them.

• Data Modeling : Create and maintain ERD (Entity-Relationship Diagrams) and other data models to ensure data security, integrity, consistency, and optimal performance. Structure data to support specific business intelligence and reporting requirements.

• Design and Development : Design, build, and maintain data warehouse architectures, including data marts and data lakes. Develop and implement ETL/ELT processes to ingest data from various sources.

• Plan and execute the migration of traditional SQL data warehouses into modern platforms based on data lake or lakehouse concepts.

• Plan, execute, and monitor data ELT (Extract, Load, Transform) and ETL (Extract, Transform, Load) jobs to ensure data integrity and accessibility.

• Implement and maintain automated data pipelines for efficient data extraction, transformation, and cleansing from various sources.

• Develop and build interactive reports and dashboards using Power BI to visualize key performance indicators (KPIs) and provide business insights.

• Performance and Optimization: Monitor and optimize performance, including query tuning and schema refinement. Troubleshoot data-related issues and ensure data quality and accuracy.

• Collaboration : Work closely with business stakeholders, the data analytics team, and other stakeholders to understand data needs and translate them into working solutions.

• Ensure data quality and governance by implementing best practices and monitoring data flows.

Knowledge/Skills/Competencies

• 5+ years of hands-on professional experience in a data-focused role, with a proven track record of implementing data lakes, data warehouses, and automating data pipelines to support HR requirements. Experience with modern data warehousing platforms (e.g., Azure Synapse, Google BigQuery) is a must.

• Demonstrated Expert-level knowledge of data modeling concepts, including dimensional modeling (Star and Snowflake schemas) and ERD diagramming.

• Hands-on experience with Data Lake and Lakehouse architectures.

• Strong Proficiency in SQL and experience with both relational and NoSQL databases.

• Strong programming skills in Python for data scripting, automation, and analysis.

• Experience with Notebook environments (e.g., Jupyter, Databricks) for data exploration and development.

• Expert-level knowledge of Microsoft Power BI for building data models, reports, and dashboards.

• Solid understanding of data modeling, data warehousing concepts, and ETL/ELT principles .

• Excellent problem-solving skills and the ability to translate business requirements into technical solutions.

• Strong communication and collaboration skills to work effectively with cross-functional teams.

Physical Demands

• Duties of this position are performed in a normal office environment.

• Duties may require extended periods of sitting and sustained visual concentration on a computer monitor or on numbers and other detailed data. Repetitive manual movements (e.g., data entry, using a computer mouse, using a calculator, etc.) are frequently required.

Typical Experience

• 5+ years in a similar role or industry (preferably in the HR space)

Typical Education

• Bachelor's degree in Computer Science, Information Technology, Statistics, or a related field.

• Educational Requirements may vary by Geography

Notes

This job description is not intended to be an exhaustive list of all duties and responsibilities of the position. Employees are held accountable for all duties of the job. Job duties and the % of time identified for any function are subject to change at any time.

Celestica is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, genetic information, disability, status as a protected veteran, or any other protected category under applicable federal, state, and local laws.

At Celestica we are committed to fostering an inclusive, accessible environment, where all employees and customers feel valued, respected and supported. Special arrangements can be made for candidates who need it throughout the hiring process. Please indicate your needs and we will work with you to meet them.

Company Overview

Celestica (NYSE, TSX: CLS) enables the world’s best brands. Through our recognized customer-centric approach, we partner with leading companies in Aerospace and Defense, Communications, Enterprise, HealthTech, Industrial, Capital Equipment and Energy to deliver solutions for their most complex challenges. As a leader in design, manufacturing, hardware platform and supply chain solutions, Celestica brings global expertise and insight at every stage of product development – from drawing board to full-scale production and after-market services for products from advanced medical devices, to highly engineered aviation systems, to next-generation hardware platform solutions for the Cloud.

Headquartered in Toronto, with talented teams spanning 40+ locations in 13 countries across the Americas, Europe and Asia, we imagine, develop and deliver a better future with our customers.

Celestica would like to thank all applicants, however, only qualified applicants will be contacted.

Celestica does not accept unsolicited resumes from recruitment agencies or fee based recruitment services.