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
-
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, … R2d 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 R4d 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 R6d 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 R14d 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 R16d ago
-
Principal Architect & Data Engineer CAD 160K-170KABAC | AWS | AWS Glue | Amazon Bedrock | Amazon RedshiftSenior-level Full TimeToronto, Canada (ONT40) R16d ago
-
Microsoft AI and Data Architect CAD 120K-150KAI Foundry | AI Search | AI Services | AI Workflow Development | AI workflowCollaborative culture | Continuous learning opportunities | Employer sponsored deferred profit sharing | Flexible remote work | Flexible schedulesSenior-level Full TimeRemote (Canada) with optional hybrid work … R17d ago
-
Senior Data Architect CAD 115K-145KAgile | Azure Data | Azure Data Factory | CI/CD | Data FactoryContinuous learning opportunities | Employer sponsored deferred profit sharing | Flexible remote work | Flexible schedules | Health dental and wellness benefitsSenior-level Full TimeRemote (Canada) with optional hybrid work … R17d 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 R22d ago
-
Amazon Web Services | Azure | Cloud Computing | Cloud platform | Data GovernanceSenior-level Full TimeRemote (Canada) R22d ago
-
Senior Data Architect (PostgreSQL + Graph Databases) CAD 130K-160KAmazon Neptune | Cloud Native | Cloud-native Databases | Data Architecture | Data GovernanceSenior-level Full TimeRemote (Canada) R22d ago
-
Senior Graph Database/Semantic Data Architect CAD 130K-160KAI Reasoning | AWS | Amazon Neptune | Azure | Data ModelingSenior-level Full TimeRemote (Canada) R22d ago
-
Senior Data Architect CAD 111K-152KAzure Data | Azure Data Factory | Boomi | Data Architecture | Data FactoryHealth and welfare benefits | Paid time offSenior-level Full TimeCanada Remote R24d ago
-
Senior-level Full TimeCanada R27d ago
-
Director and Practice Lead, Data Engineering CAD 211K-302KAI strategy | Analytics engineering | Artificial Intelligence | Cloud Data | Cloud Data PlatformsHealthcare benefits | Pension plan | Remote work flexibilitySenior-level Full TimeRemote, Ontario R29d ago
-
Amplitude | Data Governance | Data Pipelines | Data Reconciliation | Data WarehousingCo-working space access | Health insurance coverage | Health savings account | Life insurance coverage | Long-term disabilitySenior-level Full TimeMontréal - Remote R29d ago
-
API Development | Agentic Workflows | Cloud Architecture | Cloud platform | Database Design401k | Healthcare | Paid time offMid-level Full TimeRemote, Canada R1mo ago
-
Director, Data Engineering (AI Native) USD 216K-318KAmplitude | Anomaly Detection | Artificial Intelligence | Cloud Cost Management | Cost ManagementRemote work environmentExecutive-level Full TimeRemote, USA; Remote, Canada R1mo 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, … R1mo 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 R1mo ago
-
Automated testing | Azure | Batch Data Processing | Batch data | CI/CDSenior-level Full TimeOttawa (centre-ville), ON, CA R1mo ago
-
Data & AI Manager CAD 110K-199KAgile delivery | Azure | Azure Data | Azure Data Factory | Azure SynapseSenior-level Contract Full TimeCanada - Remote R1mo ago