Data Architect - Intermediate
North Vancouver, British Columbia, Canada
CAD 86K-110K (estimate) Mid-level Full Time
Tasks
- Advise on end to end solutions from strategy to architecture
- Apply SCD Types 1 2 and 3 for historical tracking and governance
- Architect data solutions using S3 Glue Athena and Redshift
- Create data architecture standards and best practices
- Design data models using AWS services and Medallion Architecture
- Develop and optimize fact tables and dimension tables
- Establish data lineage data profiling and data quality management
- Implement dimensional models using Star schema and Snowflake schema
Perks/Benefits
- N/A
Skills/Tech-stack
AWS | AWS Glue | Agile | Amazon Athena | Amazon Redshift | Apache Spark | Azure | Data Catalog | Data Governance | Data Lineage | Data Quality | Data Quality Management | Databricks | Dimensional Modeling | Medallion Architecture | Parquet | Power BI | Python | Quality management | S3 | SCD Type 1 | SCD Type 3 | SCD Type-2 | SQL | Scrum | Snowflake | Snowflake Schema | Star Schema | Tableau | Type 1 | Type 2)
Education
N/A
Roles
Regions
Countries
States
Related jobs
-
AI orchestration | AWS | Agent systems | Conversation memory | Document processingContract extension opportunity | Fully remote | US time zone overlapSenior-level Contract Full TimeCanada R2d ago
-
Senior Data & AI Solution Architect CAD 113K-179KAPIs | Azure | Azure Data | Azure Data Lake | Azure Data Lake StorageDental insurance | Employee assistance program | Health insurance | Mental health benefits | Paid time offSenior-level Full TimeCAN, Ontario, Toronto, 200 Bloor Street …2d ago
-
Master Data Architect CAD 140K-195KAPI Integration | AWS | Amazon Web Services | Azure | CDC401k thrift plan | Disability programs | Life insurance | Private medical care | Work-life balanceSenior-level Full TimeCA-ON-OTHER ONTARIO, Canada2d ago
-
Data Architect CAD 105K-125KAzure Data | Azure Data Factory | Boomi | Data Factory | Data GovernanceCompany holidays | Dental coverage | Disability insurance | Employee assistance programs | Life insuranceSenior-level Full TimeToronto, CA2d ago
-
AI Engineer Lead, Application Development CAD 85K-128KAI Document Intelligence | API Management | Automated testing | Azure | Azure AICommunity Giving Events | Health spending account | Maternity and Parental Leave Top-Up | Modern office environment | Ongoing Social EventsSenior-level Full TimeToronto, ON, CA2d ago
-
AI Solutions Deployment Manager, Cloud Applied AI, Telco USD 183K-266KAPI tools | Agentic AI | Architectural Guidance | Cloud Architecture | Cloud platformSenior-level Full TimeWaterloo, ON, Canada; New York, NY, …3d ago
-
AI Architect (T & I) (Telework/Hybrid) CAD 110K-130KA2A | AI Agent | AI agent architectures | AWS | AccelerateHybrid work | TeleworkSenior-level Full TimeMontreal - MRC (Papineau) (36.25), Canada R3d ago
-
Solutions Design IT Specialist CAD 96K-136KAccess Management | Apache Spark | Azure Data | Azure Data Factory | Azure Data LakeCareer development | Health and well-being benefits | Paid time off | Reward and recognition programs | Savings and retirement programsSenior-level Full TimeTD Centre - South - 79 …3d ago
-
Lead Solution Architect, Customer Analytics, EDW & AI CAD 122K-162KAPIs | Agent Orchestration | Agentic AI | Azure | Azure AISenior-level Full TimeMississauga, ON, CAN - 2300 Meadowvale …4d ago
-
Senior Enterprise Data Architect CAD 90K-140KAI Governance | Agentic AI | Architecture Documentation | Architecture governance | Business AnalysisBackground check requirement during employment | Hybrid work flexibilitySenior-level Full TimeSun Life Toronto One York, Canada4d ago
-
Senior Enterprise Data Architect CAD 90K-140KAI Governance | AWS | Agentic AI | Architecture governance | Artificial IntelligenceBackground checks | Hybrid work arrangementSenior-level Full TimeSun Life Toronto One York, Canada4d ago
-
AI/ML Technical Practice Lead CAD 131K-170KAWS Agentic AI | AWS CloudFormation | AWS ECS | AWS Fargate | AWS IAMContinuous learning culture | Professional development | Remote work | Training sessions | Travel opportunitiesSenior-level Full TimeCanada - Remote R5d ago
-
Data Architect Sr CAD 140K-170KAmazon Web Services | Apache Hive | Apache Kafka | Apache Pig | Apache SqoopDiversity and inclusion programs | Employee resource groups | Health benefits | Home office equipment allowance | Hybrid work arrangementsSenior-level Full TimeToronto Office, Canada R5d ago
-
AI Architect (T & I) (Telework/Hybrid) CAD 111K-140KA2A | AI Agents | AWS | Accelerate | AzureBilingual work environment | Hybrid work | Telework optionsSenior-level Full TimeMontreal - MRC (Papineau) (36.25), Canada R5d ago
-
Director, Data Architecture & Information Management CAD 110K-135KAdvanced Analytics | Artificial Intelligence | Business Information | Business Information Architecture | Cloud ArchitectureDiscounts | Employee assistance program | Health and dental plans | Hybrid work environment | Professional developmentSenior-level Full TimeToronto, Canada7d ago
-
Data Architect CAD 86K-127KAWS | Apache Spark | Azure | Big Data | Business ProcessCommunity Giving | Comprehensive benefits plan | Diversity, equity, inclusion and belonging initiatives | Employer-matched pension | Learning and developmentSenior-level Full TimeFSRA Head Office, Canada8d ago
-
Lead Data AI Architect CAD 113K-210KAIOps | API Standards | Azure | CI/CD | Data GovernanceDental insurance | Disability insurance | Employee assistance program | Health insurance | Life insuranceSenior-level Full TimeCAN, Ontario, Toronto, 200 Bloor Street …8d ago
-
AI Agents | AI Foundry | AI Services | API Integration | Access ControlSenior-level ContractWinnipeg (Transcona), Canada9d ago
-
Solutions Architect CAD 164K-224KApache Kafka | Apache Spark | Data Architecture | Data Engineering | Data WarehousingSenior-level Full TimeToronto, Canada9d ago
-
Alteryx | Azure Data | Azure Data Factory | Data Architecture | Data Factory12 paid Optimus days | Annual bonus | Company equity for managers | Health benefits | Health spending dollarsSenior-level Full TimeToronto R9d ago
-
Data Engineer / Architect CAD 110K-160KAPI Integration | Cloud | Data Governance | Data Modeling | Data PipelinesBenefits | Equity | Hybrid workSenior-level Full TimeMontréal, Canada9d ago
-
AI Foundry | AI Services | APIs | Access Control | Artificial IntelligenceSenior-level Full TimeWinnipeg, MB, Canada10d ago
-
Principal AI Engineer - Tangerine CAD 126K-170KAngular | Audit trails | Authentication and Authorization | Bias detection | CI/CDSenior-level Full TimeToronto, ON, CA10d ago
-
Data Solutions Architect CAD 120K-145KAgile | Amazon Web Services | Apache NiFi | Azure Data | Azure Data FactorySenior-level Full TimeToronto, Calgary10d ago
-
AWS Solutions Architect- AI/ML CAD 146K-211KAWS | AWS Bedrock | AWS CloudFormation | AWS Glue | AWS SecurityFully remote | Travel requiredSenior-level Full TimeCanada - Remote R12d ago