Data Engineering Solutions Architect - Technology Services Group
Tasks
- Build data warehouses and data marts
- Build logical and physical data models
- Collaborate with cross-functional teams for solution alignment
- Create architecture documentation and project plans
- Create entity relationship diagrams
- Design analytics-ready data models
- Design and build data pipelines
- Design scalable data architectures
- Design solutions across database platforms
- Develop data ingestion transformation and integration workflows
- Facilitate client requirement gathering
- Implement ETL ETL best practices
- Manage schema lifecycle and change control
- Prepare and deliver client presentations
- Reverse engineer databases into ERDs
- Translate technical concepts for technical and non technical audiences
- Troubleshoot pipeline performance and data quality issues
Perks/Benefits
- 12 paid Optimus days
- Annual bonus
- Company equity for managers
- Health benefits
- Health spending dollars
- Hybrid work
- Life and disability insurance
- Maternity and Parental Leave Top-Up
- Retirement savings via RRSP
Skills/Tech-stack
Alteryx | Azure Data | Azure Data Factory | Data Architecture | Data Factory | Data Governance | Data Marts | Data Modeling | Data Warehousing | Databricks | ELT | ETL | Entity Relationship Diagrams | Entity relationship | Metadata Management | MySQL | OLAP | OLTP | PostgreSQL | Power Automate | Relationship Diagrams | SQL | SQL Scripting | SQL Server | SSIS | Schema versioning
Education
N/A
Related jobs
-
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) R1d 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 R1d ago
-
AWS | Azure | Clustering keys | Cost Optimization | Data GovernanceMentorship opportunitiesSenior-level Full TimeNorth York, Ontario; Remote, Canada or … R2d ago
-
Mid-level Full TimeRemote, Toronto; Remote, USA; Toronto, Ontario; … R2d 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, … R2d ago
-
API Management | APIs | Access Control | ActiveMQ | Azure APISenior-level Full TimeToronto, ON, Canada R7d ago
-
AWS | Alteryx | Amazon Redshift | Azure Synapse | Azure Synapse AnalyticsContinuous learning opportunities | Fully remote work | Professional growthSenior-level Full TimeCanada R8d ago
-
Apache Hadoop | Apache Kafka | Apache Spark | Batch Processing | Cloud DataFully remote | International team collaboration | Training and professional developmentSenior-level Full TimeCanada R8d ago
-
Mid-level Full TimeRemote, Canada R8d 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 … R9d 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 … R9d ago
-
Databricks Technical Lead CAD 145K-217KApache Spark | CI/CD | Data Quality | Data orchestration | DatabricksContinuous learning resources | Hybrid work model | Remote work option | Wellbeing support | Work-life balance programsSenior-level Full TimeLocation(s): Mississauga, Ontario, Canada R10d ago
-
None Full TimeVancouver, British Columbia, Canada R11d ago
-
Associate Architect - Data Engineer CAD 100K-130KAI Search | API Design | Azure AI | Azure AI Search | Batch ProcessingMid-level Full TimeCanada - Remote R12d ago
-
Data Quality Engineer (Contract) CAD 120K-130KAgile | Data Governance | Data Quality | Data Reconciliation | Data TestingDonation matching | Early leave days | Education assistance | Flexible health benefits | Flexible-hybrid workSenior-level Contract Full TimeToronto, 105 Adelaide St W, Canada R14d 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 R18d ago
-
Staff Data Analytics Engineer USD 159K-220KApache Airflow | Apache Spark | BigQuery | DBT | Data ContractsFlexible working hours | Remote work flexibilitySenior-level Full TimeAmericas - Remote, US - Remote, … R23d 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 R25d 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 R27d 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
-
Manager, Analytics Engineering CAD 170K-200KCI/CD | DBT | Data Cataloging | Data Governance | Data ModelingCharitable donation match | Dental insurance | Flexible time off | Health insurance | Paid certification supportMid-level Full TimeRemote - 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
-
Staff Software Engineer Data - DC Tech Lead USD 148K-242KDBT | Databricks | ETL | PySpark | Python401k match | Flexible remote work | Health and wellness benefits | Home office stipend | Mental health supportSenior-level Full TimeRemote - Toronto, Ontario, Canada 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