Data Architect - Senior
Tasks
- Build ETL using SQL Server Integration Services
- Communicate architecture decisions and risks
- Conduct architecture risk assessments
- Consolidate reporting data marts into EDW
- Design ETL workflows
- Design enterprise data architecture
- Develop conceptual logical physical data models
- Implement data quality validation and controls
- Perform data profiling
- Support data governance and information security
- Translate business requirements into data solutions
- Validate datasets for reporting and analytics
Perks/Benefits
Skills/Tech-stack
Architecture Risk Assessment | Business Intelligence | Cybersecurity | Data Architecture | Data Governance | Data Marts | Data Modeling | Data Quality | Data Validation | Data Warehouse | Data Warehousing | Data profiling | Dimensional data | Dimensional data modeling | ETL | Enterprise Data | Enterprise data warehouse | Information Management | Information security | Integration Services | Power BI | Public Sector | Public Sector Policies | Relational databases | Risk Assessment | SQL | SQL Server | SQL Server Integration Services | SQL Server integration | SSIS | Server Integration Services
Education
Associate Degree | Bachelor of Engineering | Bachelor of Science | Master of Science
Roles
Related jobs
-
Azure | Azure Data | Azure Data Factory | Azure Synapse | Azure Synapse AnalyticsMentorship | Remote work | Strategic influenceSenior-level Contract Full TimeCanada R1d ago
-
Agentic AI | Attention Mechanisms | CI/CD | CUDA | Cloud ComputingExposure to emerging technologies | Fully remote | Strategic influence | Technical leadershipSenior-level Full TimeCanada R2d ago
-
Lead Databricks Consultant CAD 137K-196KAccess Control | Amazon Web Services | Apache Spark | Azure | CI/CD401k retirement plan | Dental insurance | Employee assistance program | Medical insurance | Paid HolidaysSenior-level Full TimeCAN, ON, Work-at-Home, Canada R2d ago
-
Staff Engineer - Analytics & Data Architecture USD 220K-262KClickHouse | Columnar Execution | Connection pooling | Data Architecture | Data IngestionLTD insurance | Life insurance | Meal allowance | Medical, dental coverage | OffsitesSenior-level Full TimeRemote - Canada R5d ago
-
Senior Principal Data Architect USD 170K-180KAWS Data | AWS Data Pipeline | AWS EKS | AWS EMR | AWS GlueCalm app subscription | Days off | EAP | Medical, dental & vision coverage | Open PTOSenior-level Full TimeOntario, Canada R6d ago
-
Principal Engineer - SAP Analytics Solution Architect CAD 140K-214KAnalytics Cloud | BW on HANA | BW4HANA | CDS Views | Data ModelingRemote workSenior-level Full TimeRemote, Remote, Canada R8d ago
-
Azure Data | Azure Data Factory | Azure Synapse | Azure Synapse Analytics | Cloud DataCareer advancement | Collaborative environment | Hybrid work | Innovative projects | Professional developmentSenior-level Full TimeToronto R9d ago
-
Senior Data Architect CAD 96K-120KAgile | Confluence | DBT | Data Architecture | Data ModelingCompany holidays | Dental coverage | Disability coverage | Employee assistance program | Flexible work arrangementsSenior-level Full TimeToronto - Queen's Quay - Headquarters, … R12d ago
-
Data Architect CAD 165K-210KAWS | AWS Lake | AWS Lake Formation | Access Control | Amazon AthenaCommunity engagement support | Culture events | Flexible workday | Health and dental benefits | Wellness daysSenior-level ContractOakville, Ontario, Canada (Hybrid) R13d ago
-
AVP, Enterprise Data Architecture CAD 145K-235KAdvanced Analytics | Business Intelligence | Cloud Computing | Data Architecture | Data GovernanceSenior-level Full TimeSun Life Toronto One York, Canada R13d ago
-
Lead Data AI Architect CAD 113K-210KAIOps | API Standards | Analytics | Azure | CI/CDDental insurance | Disability insurance | Employee assistance program | Health insurance | Life insuranceSenior-level Full TimeCAN, Ontario, Toronto, 200 Bloor Street … R13d ago
-
AVP, Enterprise Data Architecture CAD 145K-235KAnalytics | Business Intelligence | Cloud Computing | Data Architecture | Data GovernanceSenior-level Full TimeSun Life Toronto One York, Canada R13d ago
-
AWS | Azure | Clustering keys | Cost Optimization | Data GovernanceMentorship opportunitiesSenior-level Full TimeNorth York, Ontario; Remote, Canada or … R14d ago
-
Anthos | Backup and Recovery | BigQuery | Cloud Storage | Cloud platformCertification opportunities | Conference opportunities | Flexible vacation policy | Health benefits | Learning opportunitiesSenior-level Full TimeToronto, Ontario; North York, Ontario; Toronto, … R14d ago
-
API Management | APIs | Access Control | ActiveMQ | Azure APISenior-level Full TimeToronto, ON, Canada R19d ago
-
Senior Data Architect CAD 115K-145KAWS | Agile | Azure | CI/CD | Cloud platformDeferred profit-sharing | Dental benefits | Flexible remote work | Flexible schedules | Health benefitsSenior-level Full TimeRemote (Canada) with optional hybrid work … R21d ago
-
Microsoft AI and Data Architect CAD 120K-150KAI Foundry | AI Search | API Management | Agent Framework | AutogenContinuous learning | Deferred profit-sharing | Dental benefits | Flexible remote work | Flexible schedulesSenior-level Full TimeRemote (Canada) with optional hybrid work … R21d 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 R30d 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 R1mo ago
-
AWS Solutions Architect- AI/ML CAD 146K-211KAWS | AWS CloudFormation | AWS Glue | AWS Security | AWS Well ArchitectedFully remote | Travel requiredSenior-level Full TimeCanada - Remote R1mo ago
-
Principal Data Engineer USD 180K-220KAWS | Apache Airflow | Artificial Intelligence | CI/CD | Confluence401k | Autonomy | Company paid life insurance | Disability coverage | FSASenior-level Full TimeRemote - US, Canada and Poland R1mo ago
-
Lead Embedded Developer CAD 116K-155KAlgorithms | Automated testing | Bash | BigQuery | C#Baby bonus | Competitive medical and dental benefits | Electric vehicle purchase incentive program | Flexible working arrangements | Home office reimbursement programSenior-level Full TimeOakville, Ontario - Canada R1mo ago
-
Principal Architect & Data Engineer CAD 160K-170KABAC | AWS | AWS Glue | Amazon Bedrock | Amazon RedshiftSenior-level Full TimeToronto, Canada (ONT40) R1mo ago
-
Amazon Web Services | Azure | Cloud Computing | Cloud platform | Data GovernanceSenior-level Full TimeRemote (Canada) R1mo ago
-
Senior Data Architect (PostgreSQL + Graph Databases) CAD 130K-160KAmazon Neptune | Cloud Native | Cloud-native Databases | Data Architecture | Data GovernanceSenior-level Full TimeRemote (Canada) R1mo ago