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
-
Associate Data Engineer CAD 70K-90KAgile | CI/CD | Confluence | Data Modeling | Data PipelinesHybrid work schedule | Professional development | Work From Home FridayMid-level Full TimeSupport Centre - Toronto Office, Canada R2d ago
-
AWS | Amazon Bedrock | Amazon SageMaker | Apache Spark | Automated DeliveryEmployer pension contribution | Equipment and home office stipend | Learning and development stipend | Long-Term Disability coverage | Paid HolidaysSenior-level Full TimeCanada R2d ago
-
AI Assisted Development | Airflow | Apache Spark | Astronomer | Cost OptimizationCross-functional collaboration | Fully remote | Leadership and mentoring opportunities | Reasonable accommodations for disabilities | Remote work autonomyMid-level Full TimeCanada R2d ago
-
Product Engineering (Fabric Data Engineering) CAD 80K-120KAzure DevOps | Azure Monitor | BI Semantic Model | CI/CD | Change Data FeedCommunity volunteering | Employee discounts | Flexible work arrangements | Good Office Program | Personal daysMid-level Full TimeCanadian Head Office (It), Canada R3d ago
-
Engineering Manager, Data Modeling CAD 105K-135KAirflow | Apache Spark | Astronomer | Compliance | Data GovernanceMid-level Full TimeCanada Remote R3d ago
-
Principal Data Architect — Databricks Enablement CAD 180K-202KAmazon Bedrock | Amazon Redshift | Amazon S3 | Amazon SageMaker | Amazon Web ServicesEquipment stipend | Health insurance | Learning and development stipend | Long-term disability | Paid HolidaysSenior-level Full TimeCANADA R3d ago
-
.NET | AI orchestration | API Integration | Automation | C#Autonomy in work | Comprehensive benefits package | Fully remote work | Learning opportunities | Professional developmentSenior-level Full TimeCanada R3d ago
-
Advisor, Data engineering CAD 83K-133KAlgorithms | Data Engineering | Data Modeling | Data Pipelines | Data StorageDefined benefit pension plan | Flexible vacation | Group insurance | Health & wellness reimbursement | TelemedicineSenior-level Full TimeComplexe Desjardins Montréal, Canada R4d ago
-
Lead Databricks Consultant CAD 114K-164KAWS | Access Control | Apache Spark | Azure | Batch Processing401k retirement plan | Dental insurance | Employee assistance program | Medical insurance | Paid HolidaysSenior-level Full TimeCAN, ON, Work-at-Home, Canada R4d ago
-
Staff Data Engineer CAD 131K-164KAWS | Azure | CI | CI/CD | Cloud platform401k | Dental insurance | Discretionary time off | Equity participation | Health insuranceSenior-level Full TimeRemote - Canada R4d ago
-
Access Management | Business glossary | Change Data Capture | Data Capture | Data Catalog401k matching | Dental insurance | Flexible work arrangements | Fully remote | Health insuranceMid-level Full TimeCanada R4d ago
-
Databricks Data Engineering Advisor CAD 105K-120KAzure Databricks | Azure Functions | Azure Storage | C# | Data GovernanceFlexible vacation | Group insurance | Health and wellness reimbursement | Pension plan | TelemedicineMid-level Full TimeComplexe Desjardins Montréal, Canada R5d ago
-
Databricks Data Engineering Advisor CAD 105K-115KAPI Development | Azure Databricks | Azure Functions | Azure Logic | Azure Logic AppsDefined benefit pension plan | Flexible vacation | Group insurance | Health and wellness expense reimbursement | TelemedicineMid-level Full TimeComplexe Desjardins Montréal, Canada R5d ago
-
Head of Data Engineering & Platform USD 289K-362KData Governance | Data Modeling | Data Privacy | Data Quality | Data StorageExecutive-level Full TimeSan Francisco, CA, New York, NY, … R7d ago
-
Azure Virtual | Azure Virtual Desktop | Data Architecture | Data Modeling | Data WarehouseFlexible scheduling | Part-time hours | Remote workSenior-level Part TimeEdmonton, Alberta (Remote) R7d ago
-
Data Analytics Lead CAD 150K-250KAI | Data Architecture | Data Modeling | Data integration | Large DatasetsCharitable giving program | Company-Paid Holidays | Dental insurance | Health insurance | Life insuranceSenior-level Full TimeCanada - Toronto R8d ago
-
Data Architect - Senior CAD 103K-128KAWS | Agile | Cloud Migration | Data Governance | Data LakeCollaborative work environment | Comprehensive benefits | Hybrid work scheduleSenior-level Full TimeNorth Vancouver, British Columbia, Canada R9d ago
-
Data Engineering Developer CAD 85K-166KAPI Integration | Apache Spark | Azure Data | Azure Data Factory | Azure FunctionsActivities | Flexible hours | Paid sabbatical | Parental program | TrainingMid-level Full TimeMontreal (EN) R9d ago
-
Director, Data Engineering CAD 151K-200KAI Pipelines | APIs | Apigee | Azure DevOps | BigQueryCareer development training | Collaborative culture | Employee resource groups | Flexible benefits package | Hybrid work scheduleExecutive-level Full TimeToronto - 181 Bay St, Canada R11d ago
-
Consultant, Databricks Developer CAD 92K-112KAutosys | Azure | Azure Data | Azure Data Factory | Azure DatabricksBanking benefits | Defined benefit pension plan | Employee share purchase plan | Paid day off for growth and development | Vacation offeringSenior-level Full TimeToronto-81 Bay, 27th Floor, Canada R11d ago
-
Artificial Intelligence | Azure | BigQuery | Code review | DBTHealth benefits | Hybrid work | Paid time off | Supportive team cultureSenior-level Full TimeMarkham, Ontario, Canada R12d ago
-
Director and Practice Lead, Data Engineering CAD 211K-302KArtificial Intelligence | Business Development | Cloud Native | Cloud Native Data | Cloud-native data platformsSenior-level Full TimeRemote, Ontario R15d 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 R15d 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 R18d 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 R18d ago