Data Architect (EDW)
Tasks
- Act as trusted advisor between business and technical teams
- Architect and design end to end EDW and BI solutions
- Define best practices for data modeling data engineering and visualization
- Design and oversee scalable data pipelines ETL ELT
- Design scalable dimensional data models
- Drive cloud deployment and production readiness
- Ensure performance, scalability, and reliability
- Establish data governance and security standards
- Facilitate architecture and technical design sessions
- Implement data quality, validation, and monitoring
- Integrate and enhance BI solutions on prem and in cloud
- Integrate multi source analytics data for data consumers
- Lead and mentor BI developers data engineers and analysts
- Lead data transformation cleansing and enrichment
- Own full lifecycle delivery requirements design build deploy adoption optimization support
- Perform performance optimization
- Translate business requirements into data analytics solutions
Perks/Benefits
Skills/Tech-stack
AWS Glue | Amazon Redshift | Azure | Business Intelligence | C Sharp | Data Modeling | Data Warehousing | DataStage | Dimensional Modeling | ELT | ETL | Informatica | Informatica PowerCenter | Java | Microsoft SQL | Microsoft SQL Server | Power BI | Python | SQL | SQL Server | SSIS | Salesforce | Star Schema | Tableau
Education
N/A
Roles
Related jobs
-
Principal Machine Learning Architect CAD 125K-162KAlgorithms | Classification | Data Transformation | Data verification | Feature EngineeringCommuter benefits | Dental insurance | Donation-matching program | Employee assistance program | Equity packagesSenior-level Full TimeToronto (8 Spadina Ave)20h ago
-
Data Architect - Life Sciences CAD 144K-208KAPI Integration | AWS | Access Management | Architecture evaluation | DBTSenior-level Full TimeToronto, Canada2d ago
-
Agile | Cloud Architecture | Data Governance | Data Modeling | Database DesignSenior-level ContractDowntown Toronto (Ryerson), Canada3d ago
-
Machine Learning & Game Tech Architect CAD 180K-247KAPI Design | C# | C++ | Code optimization | Game enginesDental insurance | Flexible work hours | Medical insurance | Mental health support | Paid time offSenior-level Full TimeMontreal, QC, Canada R4d ago
-
Principal Knowledge Graph Architect (Hybrid) CAD 82K-135KGraph Databases | Knowledge graphs | Neo4j | OWL | Ontology DesignHybrid work environmentSenior-level Full TimeMontreal 700, Canada R5d ago
-
Specialist I TIS AI and Data Analytics USD 94K-135KAI | Agile | Azure Data | Azure Data Factory | Azure DevOpsCompressed work week | Employee and family assistance program | FlexWork hybrid work option | Flexible benefits program | Paid maternity and parental leaveSenior-level Full TimeCalgary, Canada5d ago
-
Embedded Artificial Intelligence Architect CAD 107K-147KC# | C++ | CI/CD | CUDA | Computer ScienceDental benefits | Disability income protection | Employee assistance program | Extended healthcare | Family assistance programSenior-level Full TimeSainte-Anne-de-Bellevue, Quebec, Canada5d ago
-
Senior Data Architect -Healthcare CAD 116K-152KAzure Data | Azure Data Factory | Azure Databricks | Azure Synapse | Azure Synapse AnalyticsEAP ehealth care access | Flexible work location | Health/dental/vision/life/disability insurance | MyLife days | Paid parental leaveSenior-level Full TimeHalifax, NS, CA5d ago
-
Senior Data Architect CAD 99K-136KAzure Data | Azure Data Factory | Boomi | Data Factory | Data GovernanceHealth and welfare benefits | Paid time off | Wellness programsSenior-level Full TimeMississauga, Canada6d ago
-
AI Developer CAD 125K-150KAI Foundry | Authentication | Authorization | Azure AI | Azure AI FoundryHybrid work | Training and workshops | Wellbeing programsSenior-level Full TimeMontreal, Canada7d ago
-
Azure | Cloud Architecture | Data Architecture | Data Governance | Data ModelingEmployee recognition | Flexible benefits | Generous time off | Hybrid working | Professional developmentSenior-level Full TimeCA.ON.Toronto.185 The West Mall, Canada8d ago
-
Active Directory | Azure | Azure Active Directory | Azure Data | Azure Data FactorySenior-level Full TimeMontreal, Quebec, Canada9d ago
-
Anthos | BigQuery | Cloud Security | Cloud Storage | Cloud platformCertification opportunities | Conference opportunities | Flexible vacation policy | Health benefits | Learning opportunitiesSenior-level Full TimeToronto, Ontario9d ago
-
Director, Enterprise Data Architecture CAD 125K-195KAWS | Amazon Redshift | Cloud Computing | Data Governance | Data ManagementFlexible hybrid work model | Pension | Professional growth | Savings programs | Stock programsSenior-level Full TimeSun Life Toronto One York, Canada12d ago
-
AWS Cloud | AWS Cloud Architecture | Amazon Bedrock | Amazon SageMaker | Cloud ArchitectureSenior-level Full TimeOttawa, Ontario, CAN12d ago
-
Director, Enterprise Data Architecture CAD 125K-195KAWS | Amazon Redshift | Cloud Computing | Data Catalog | Data GovernanceBilingual support Quebec requirement for French and English | Flexible hybrid work model | Inclusive collaborative culture | Pension | Professional growth opportunitiesSenior-level Full TimeSun Life Toronto One York, Canada12d ago
-
Data Architect, Wealth and Asset Management CAD 153K-197KAWS | Azure | Cloud Architecture | Cloud platform | Data ArchitectureContinuous learning | Disability insurance | Employee assistance program | Employer Match RRSP | Health insuranceSenior-level Full TimeCanada - Toronto12d ago
-
Platform Data Architect CAD 80K-130KAzure | Azure Functions | Big Data | Big Data Security | Data ArchitectureSenior-level Full TimeCanada13d ago
-
Archimate | Artificial Intelligence | GitHub | Java | Language ModelsBilingual French required | Functional EnglishSenior-level Full TimeRive-Sud de Montréal, Canada13d ago
-
Agent runtimes | CI/CD | Cloud platform | Conversational Analytics | Data CatalogCareer growth and development | Community contribution opportunities | Health and wellbeing resources | Hybrid work environment | Inclusive workplaceSenior-level Full TimeToronto, ON, M2M 4G3, CA13d ago
-
Principal Embedded Software Developer - Architect CAD 101K-135KAgile | C++ | Cloud Computing | Containerization | Embedded SystemsAgile team collaboration | International travelSenior-level Full TimeOttawa, Ontario14d ago
-
Principal Platform Architect - AI and Data Platforms CAD 65K-108KAgent Orchestration | Amazon Web Services | Architecture | Azure | Azure DataMental health benefits | Profit sharing | Retirement and savings programs | Store discounts | Supported learningSenior-level Full Time2300 Yonge, Canada14d ago
-
AI Data Platform Lead CAD 145K-202KAWS | Apache Airflow | Audit Logging | DBT | Data GovernanceFloating holidays | Wellness daySenior-level Full TimeCanada14d ago
-
Associate Director, Data Platforms CAD 138K-188KAzure Data | Azure Data Factory | Azure Data Lake | Azure Data Lake Storage | CollibraCommunity support | Employee connections | Flexible-hybrid work | Professional development | Wellness programsMid-level Full TimeHead Office Toronto, Canada15d ago
-
Lead Solution Architect AI/ML CAD 113K-210KAPI Integration | Agile | Amazon Web Services | Artificial Intelligence | Automated testingSenior-level Full TimeCAN, Ontario, Toronto, 200 Bloor Street …15d ago