Data Warehouse Engineer
Kingsville, Ontario, Canada
CAD 90K-110K (estimate) Mid-level Full Time
Tasks
- Design and build medallion bronze silver gold pipelines
- Design and maintain star schema dimensional models
- Enable end users to write SQL and build reports on governed models
- Implement SQL first data models for self service reporting
- Implement data governance, security, and access controls
- Ingest new data sources with full incremental CDC near real time strategy
- Maintain documentation for data models pipelines and workflows
- Optimize pipeline performance and reliability
- Profile data for stakeholder requirements
- Provide guidance and review work of other data engineers
- Troubleshoot and resolve data pipeline and data quality issues
Perks/Benefits
- N/A
Skills/Tech-stack
Access Control | Agile methodology | Amazon S3 | Azure Data | Azure Data Lake | Azure Data Lake Storage | Azure Synapse | Azure Synapse Analytics | Cloud Storage | Data Access Control | Data Governance | Data Lake Storage | Data Modeling | Data Quality | Data Security | Data access | Data pipeline | Dimensional Modeling | Git | Google Cloud | Google Cloud Storage | Medallion Architecture | Microsoft Fabric | PySpark | Python | SQL | Slowly Changing Dimensions | Star Schema | Synapse Analytics | Version control
Education
Related jobs
-
AI Agents | APIs | Cloud infrastructure | Governance | Language ModelsAccess to modern tools and innovation focused environment | Flexible remote work options | Holidays | Medical, dental, and vision coverage | Paid parental leaveSenior-level Full TimeCanada7h ago
-
Lead Machine Learning Engineer CAD 156K-251KAWS | Azure | CI/CD | Cloud Computing | Cloud platformAutonomy | Career development support | Learning and development programs | Mentorship and coachingSenior-level Full TimeToronto, Canada R15h ago
-
Principal AI Engineer CAD 214K-344KCI/CD | Container Orchestration | Docker | Fine Tuning | Information RetrievalInteractive career development tools | Learning and development programs | MentorshipSenior-level Full TimeToronto, Canada17h ago
-
Data Warehouse Engineer CAD 85K-95KAccess Control | Agile Development | Amazon S3 | Apache Flink | AzureMid-level Full TimeKingsville, Ontario, Canada20h ago
-
Data Analytics Engineer CAD 55K-60KData Analysis | Data Modeling | Dimensional Modeling | GitHub Copilot | LLMAccommodation for disabilitiesMid-level Full TimeKingsville, Ontario, Canada21h ago
-
Data Analytics Engineer CAD 55K-60KData Analysis | Data Modeling | Dimensional Modeling | GitHub Copilot | LLMAccommodation support for disabilitiesEntry-level Full TimeKingsville, Ontario, Canada21h ago
-
Senior Machine Learning Engineer (Fraud) CAD 153K-213KAirflow | Apache Spark | Batch Processing | CatBoost | DaskDental coverage | Employee Stock Purchase Plan (ESPP) | Flexible spending wallets | Health coverage | Remote work optionSenior-level Full TimeRemote Canada R22h ago
-
AI Foundry | Agent systems | Anthropic Claude | Azure AI | Azure AI FoundryCaregiver leave | Continuous development support program | Employee assistance program | Flexible paid time off | Parental leaveMid-level Full TimeMississauga R22h ago
-
AWS SageMaker | Azure Machine Learning | CI/CD | Computer Vision | DockerBilingual work environmentMid-level Full TimeMontréal, Canada1d ago
-
Data Engineering Consultant CAD 95K-109KAmazon Web Services | Apache Airflow | Apache Spark | Cloud platform | DatabricksCare days | Dental care | Extended health benefits | Health savings account | Paid vacation daysMid-level Full TimeToronto1d ago
-
Machine Learning Engineer (Platform) USD 156K-211KAWS | CPU Optimization | Data Processing | Data throughput | Distributed TrainingRemote workSenior-level Full TimeRemote-US R1d ago
-
Senior-level Full TimeToronto R1d ago
-
AI Engineer - New Grad CAD 55K-64KAPIs | Agentic Frameworks | Fine Tuning | LLM Agents | Language ModelsDiscount program | Flexible medical spending account | Health benefits | Leadership training | RRSP matchingEntry-level Full TimeGreater Toronto Area, ON, Canada1d ago
-
Senior Data Engineer CAD 90K-110KCost Optimization | Data Ingestion | Data Modeling | Data Transformation | Data pipelineAdditional paid time off option | Annual bonus eligibility | Career development opportunities | Corporate wellness programs | Employee driven diversity programsSenior-level Full TimeCanada - Markham ON 10 Aviva …1d ago
-
Senior Software Engineer (Data Engineering) CAD 140K-210KAWS | Apache Avro | Apache Flink | Apache Iceberg | Apache KafkaFlexible work schedule | Hybrid work model | On-call supportSenior-level Full TimeCanada, BC, Vancouver1d ago
-
Ab Initio Developer (Big Data & Hadoop) CAD 88K-95KAb Initio | Apache Hadoop | CI/CD | Data Lake | Data ModelingCompany-Paid Holidays | Employee assistance program | Life and disability insurance | Medical, dental, and vision coverage | Paid time offSenior-level Full TimeToronto, CA1d ago
-
Senior Software Engineer, MLOps CAD 175K-220KAgile | Airflow | Batch Processing | DBT | Data PipelinesCharitable donation match | Flexible time off | Medical/Dental/Vision | Paid parental leave | Professional development budgetSenior-level Full TimeRemote - Alberta, Canada R1d ago
-
Senior Staff Machine Learning Platform Engineer CAD 248K-341KAWS | Airflow | Amazon S3 | Apache Iceberg | Apache KafkaHybrid work schedule | Remote work flexibilitySenior-level Full TimeKitchener-Waterloo, ON; Toronto, ON R1d ago
-
Machine Learning Engineer USD 156K-281KAirflow | Apache Spark | Data Drift | Data drift monitoring | Delta LakeSenior-level Full TimeMiami, FL; Toronto, Canada; Seattle, WA1d ago
-
Machine Learning Engineer - (Computer Vision) CAD 100K-149KAWS SageMaker | Airflow | Amazon EC2 | Amazon EKS | BiometricsMid-level Full TimeMontreal1d ago
-
AI Solutions Engineer CAD 90K-110KAI Agents | API Integration | Alerting | Cause analysis | Content ManagementDental insurance | Employee discounts | Medical insurance | Paid time off | RRSP matchMid-level Full TimeHybrid- Toronto, ON R1d ago
-
AI Assisted Development | Claude Code | Code review | Cursor | JavaScriptFlexible hours | Ongoing project based workSenior-level Full TimeMiami1d ago
-
Data Engineer CAD 82K-123KAzure Data | Azure Data Factory | Azure Data Lake | Azure Functions | Azure SynapseMid-level Full TimeToronto, ON, CA1d ago
-
Senior Database Reliability Engineer CAD 120K-160KAWS | Apache Iceberg | Blue-Green Deployment | Blue/green | BlueGreen RolloutsSenior-level Full TimeMontreal, Canada2d ago
-
Airflow | Autogen | ClickHouse | CrewAI | DagsterAnnual performance bonus | Equipment support | Flexible working hours | Gifts and rewards | Lunch allowanceSenior-level Full TimeCanada R2d ago