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
-
AI Solution Architect CAD 120K-170KAWS SageMaker | Azure Machine Learning | CI/CD | Data Lineage | Data platformsSenior-level Full TimeSaskatoon, SK, CA, S7K 5R620h ago
-
Senior Data Architect CAD 120K-160KAWS | Apache Airflow | Apache Flink | Apache Kafka | Apache SparkSenior-level Full TimeToronto, Canada1d ago
-
API Integration | Artificial Intelligence | Data Governance | Data Modeling | Data QualityEmployee assistance support | Health, dental and vision coverage | Learning budget | Mental health resources | Paid time offSenior-level Full TimeCanada1d ago
-
GenAI Delivery Architect USD 76K-179KAPI Integration | Agent Orchestration | Agent systems | Amazon Web Services | AutogenCompany-Paid Holidays | Employee assistance programs | Life and disability insurance | Medical, dental, and vision coverage | Paid time offSenior-level Full TimeMississauga, CA2d ago
-
Data Architect - Tangerine CAD 91K-136KAWS | Amazon Web Services | Apache Airflow | Azure | BigQueryFlexible work arrangement | Health and wellness benefits | Learning and developmentSenior-level Full TimeToronto, ON, CA, M2H0A12d ago
-
Enterprise Data Architect CAD 120K-170KBig Data | Conceptual data model | Data Architecture | Data Governance | Data LineageChildcare benefits | Internal mobility | Robust training programSenior-level Full Time5900 HURONTARIO STREET MISSISSAUGA, Canada2d ago
-
Data Architect CAD 98K-135KCompliance | DBT | Data Architecture | Data Catalog | Data ClassificationSenior-level Full TimeToronto, Ontario, Canada2d ago
-
Senior Data Architect CAD 120K-160KAmazon S3 | Authentication | Azure Blob | Azure Blob Storage | Blob StorageSenior-level Full TimeCA-ON-Toronto3d ago
-
Customer Experience AI Architect CAD 131K-177KAI Agents | API Integration | Agentic Workflows | Application development | Artificial IntelligenceHybrid work option | Remote work flexible schedule | Travel to headquarters optionalSenior-level Full TimeCanada - Remote (0002) R4d ago
-
Lead Data Architect – Data & AI Platform CAD 122K-162KAccess Control | Azure Databricks | Data Governance | Data Lakehouse | Data LineageSenior-level Full TimeMississauga, ON, CAN - 2300 Meadowvale …5d ago
-
AI Solutions Architect CAD 216K-228KAI/ML | Data Architecture | Data Governance | Data Modeling | Enterprise ArchitectureAnnual performance refresh grants | Equity grants | Flexible work location | In-person events | Remote workSenior-level Full TimeCanada - Remote (ON, AB, BC, … R5d ago
-
Principal Agentic AI Solutions Architect CAD 136K-178KAPI Design | AWS | Azure | Cloud Architecture | Cloud platformAdoption Assistance | Health insurance | Internal mobility programs | Learning resources | Paid time offSenior-level Full TimeVirtual Office (Ontario), Canada R6d ago
-
Architect Software Developer CAD 140K-170KAPI rate-limiting | AWS | Aiohttp | Asynchronous programming | AsyncioRemote workSenior-level Full TimeCA NB Fredericton, Canada6d ago
-
Lead Data AI Architect CAD 113K-210KAI Services | AIOps | API Design | Azure | Azure AIDental insurance | Disability insurance | Employee assistance program | Health insurance | Life insuranceSenior-level Full TimeCAN, Ontario, Toronto, 200 Bloor Street …6d ago
-
Automated testing | Azure | Batch Data Processing | Batch data | CI/CDSenior-level Full TimeOttawa (centre-ville), ON, CA R7d ago
-
AI machine learning | API | Analytics | Archer GRC | Audit compliance37 50 hours per week | Contract position 5 months | Hybrid work schedule | Toronto office 3 days per weekSenior-level ContractToronto, Canada7d ago
-
Delivery Solutions Architect CAD 175K-241KBusiness Analysis | Data Architecture | Distributed Systems | KPI Reporting | Program ManagementHybrid work | Travel up to 30%Senior-level Full TimeVancouver, Canada7d ago
-
Vice-President, Data Platforms CAD 111K-152KAnalytics | Artificial Intelligence | Auditability | Business Intelligence | Capacity PlanningEmployee recognition program | Paid time off for growth and development | Wellbeing supportExecutive-level Full TimeToronto-81 Bay, 16th Floor, Canada8d ago
-
Admin & AI Architect, RevOps & CRM Systems CAD 110K-120KAnthropic API | Apex | Autogen | CrewAI | Human-in-the-loopCareer development opportunities | Flex Time Off | Team-oriented work environmentSenior-level Full TimeOakville8d ago
-
Admin & AI Architect, RevOps & CRM Systems CAD 100K-110KAgent systems | Anthropic API | Apex | Autogen | CrewAICareer development opportunities | Comprehensive benefits package | Flex Time OffSenior-level Full TimeWinnipeg8d ago
-
AWS | Autogen | Autonomous Agents | Azure | CRMContinuous learning opportunities | Flexible work environmentSenior-level Full TimeCanada8d ago
-
Senior Data Analyst – DEM&S Ecosystem Support / Analyste principal(e) des données – Soutien à l’écosystème DEM&S - NETE CAD 103K-138KAPI | Agile Development | Data Modeling | Data Quality | Data SerializationSenior-level Full TimeCA011 - MIN - Lasalle - …9d ago
-
AI Security | AI Services | AI compliance | APIs | AWS401k retirement plan | Flexible work options | Medical/dental/life/disability | Paid time off | Performance bonusSenior-level Full TimeKitchener, ON, Canada9d ago
-
AI/ML Specialist Solutions Architect USD 175K-275KAWS | Ansible | Azure | CUDA | Cloud platform401k match | Career growth | Disability insurance | Health insurance | Life insuranceSenior-level Full TimeCanada; Remote - United States R11d ago
-
Senior Data Architect - Hybrid CAD 116K-146KAPI Integration | Agile | Automated Deployment | Bronze Layer | CI/CDDefined benefit pension | Flex days | Flexible benefits program | Flexible hours | Health spending accountSenior-level Full TimeCalgary Head Office, Canada R12d ago