Home
Jobs
Smart IT Frame LLC
Senior Data Warehouse Architect

Senior Data Warehouse Architect

On site

Toronto, Canada

Senior

Freelance

09-12-2025

Share this job:

Score my CV

Skills

Communication Python Data Warehousing Data Governance Azure Data Factory Architecture power bi Azure Databricks PySpark

Job Specifications

Job Title: CLOUD AMAZE - Data Warehouse Architect

Location: Toronto, ON (Hybrid - 4 days onsite a week)

Full time

About Smart IT Frame:

At Smart IT Frame, we connect top talent with leading organizations across the USA. With over a decade of staffing excellence, we specialize in IT, healthcare, and professional roles, empowering both clients and candidates to grow together.

Domain: Banking

Job Description

• 10+ years of experience in Data Discovery & Analysis, Data Quality and Data Integration2.

• 7+ years of experience in designinig and building realtime, near realtime and batch data processing Pipelines

• Worked on the data migration data warehousing projects on cloud mainly Azure

• Should be able to debug and understand existing ETL and write new ETL’s pipelines

• Hands-on experience with data ingestion and data transformations using Azure Data Factory, DataBricks, Synapse and other Azure services

• Good understanding of data governance framework and tools

• Experience in building architecture frameworks, debugging the data pipelines for performance issues and providing the solution for the same

• Experience in building metadata driven pipelines

• Good understanding and hands on experience on some of the Azure components related to data (DataBricks, Data Lake, Purview, Synapse)

• Understanding of the Power BI to create visualizations

• Good to have an experience in Python/PySpark

• Writing high-performance, reliable and maintainable code with modern data tools

• Strong communication skills

Apply today or share profiles at dhamodharan@smartitframe.com

About the Company

Smart IT Frame stands as a leading NMSDC-certified IT Solutions and Servicing company, founded in 2012 with headquarters in Somerset, New Jersey. Our commitment to promoting Diversity, Equality, and Inclusion (DEI) values is unwavering. With our expertise, we support client initiatives by offering innovative IT solutions and services to leading System Integrators in the private and public sectors. Specializing in a comprehensive range of end-to-end services, including Artificial Intelligence (AI), Machine Learning (ML), IT ... Know more