Data Warehouse Engineer
Tasks
- Build self service data foundation for SQL querying
- Collaborate with report developers to validate data accuracy
- Design, build, and optimize data pipelines
- Develop Gold layer data models for reporting
- Implement data governance security and access control
- Maintain documentation for data models pipelines and workflows
- Onboard new data sources and select ingestion strategy
- Partner with business stakeholders to define business logic
- Profile data to translate stakeholder requirements
- Review and guide work of other data engineers
- Troubleshoot and resolve data pipeline issues
Perks/Benefits
- N/A
Skills/Tech-stack
Access Control | Agile Development | Amazon S3 | Apache Flink | Azure | Azure Data | Azure Data Lake | Azure Data Lake Storage | Cloud Storage | Cloud platform | Data Catalog | Data Governance | Data Lake Storage | Data Modeling | Data Processing | Data Security | Data pipeline | Data pipeline optimization | Databricks | Git | GitHub Copilot | Google Cloud | Google Cloud Platform | Google Cloud Storage | Hadoop | Kafka | LLM | Medallion Architecture | Metadata Management | Microsoft Fabric | Near Real-Time Data Processing | Near-Real-Time data | Near-real-time | Performance Tuning | Pipeline Optimization | PySpark | Python | Query Performance Tuning | Query performance | Real-time Data Processing | SQL | Slowly Changing Dimensions | Star Schema | Synapse | Window Functions
Education
Related jobs
-
Analytics Engineer CAD 75K-122KAirflow | Alation | Amazon Redshift | BigQuery | CI/CDCompany-paid certifications | Healthcare insurance | Internal events | Internal mobility opportunities | Life insuranceMid-level Full TimeCanada8h ago
-
Airflow | Computer Vision | Computer vision models | DBT | DagsterCanada based candidates preferred | Climate focused initiatives | Cross-functional collaboration | Fully remote work | Impact on infrastructure resilienceSenior-level Full TimeCanada R11h ago
-
AI Agents | API Integration | Access Control | Amazon Bedrock | Argo CDCollaborative culture | Equity or bonus opportunities | Professional growth opportunities | Remote work within Canada | Work on cutting edge AI and cloud projectsSenior-level Full TimeCanada R14h ago
-
A/B | A/B Testing | API Integration | Airflow | B testingCross-functional collaboration | Professional growth | Remote work | Self service enablementSenior-level Full TimeCanada R17h ago
-
Staff Software Engineer, Backend (Online Storage) CAD 181K-241KAWS | Capacity Planning | Connection pooling | Database Benchmarking | Disaster RecoveryDental and vision coverage | ESPP (Employee Stock Purchase Plan) | Flexible spending wallets | Health care coverage | Tech spending stipendSenior-level Full TimeRemote Canada R17h ago
-
Data Engineer USD 170K-209KAWS | Amazon Kinesis | CI/CD | Compliance Frameworks | Container OrchestrationSenior-level Full TimeUS - Remote; Canada - Remote R19h ago
-
Senior Machine Learning Engineer, Growth CAD 170K-190KAWS | Azure | CI/CD | Data Pipelines | Drift DetectionCareer growth and learning opportunities | Discount on fitness memberships | Flexible hybrid schedule | Generous vacation and PTO | Health and dental benefitsSenior-level Full TimeToronto, Ontario, Canada R20h 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 R20h ago
-
AWS Bedrock | Anthropic | Azure OpenAI | LLM | LangchainBabbel access | Gym access | Happy hours 5 to 7 | Health Insurance 100 percent covered | OPUS transit subsidyMid-level Full TimeMontreal, Canada20h ago
-
Mid-level Full TimeRemote, Ontario R20h ago
-
Python Developer – AI Operations CAD 90K-111KAPI Design | Agentic Workflows | Algorithms | As-a-Service | Async PythonHybrid work environmentMid-level Full TimeMontréal, Quebec R21h ago
-
Senior AI DevOps Developer [584] USD 150K-206KACP | AI Security | AWS | AgentCore) | Agentic OrchestrationCompany benefits | Learning and development opportunities | On-call rotationSenior-level Full TimeRemote (United States); Canada R1d ago
-
Senior Data Platform Developer - AI Platform CAD 104K-135KAWS | Azure | Bedrock | CrewAI | DockerElectric vehicle purchase incentive program | Flex working arrangements | Home office reimbursement | Medical and dental benefits | Online learning and networking opportunitiesSenior-level Full TimeOakville, Ontario - Canada R1d ago
-
Senior Solutions Principal CAD 126K-173KAWS | Access Control | Amazon Redshift | Apache Airflow | Apache SparkSenior-level Full TimeToronto, ON, Canada1d ago
-
Data Engineer CAD 64K-114KAgentic AI | Apache Spark | Azure Data | Azure Data Factory | Azure DatabricksDisability insurance | Extended health and dental benefits | Hybrid work | Paid time off | Perk programsMid-level Full TimeCambridge, Ontario, Canada R1d 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 R1d ago
-
Staff Engineer (AI & Engineering) CAD 140K-170KAI Application Development | AI application | AI orchestration | API Design | Agent workflowsSenior-level Full TimeToronto1d ago
-
Software Engineer II – GenAI Quality Engineering CAD 104K-142KAutomated testing | Automation frameworks | C# | C++ | CI/CDDisability insurance | Health, dental and vision coverage | Hybrid work model | Life insurance | Paid family leaveMid-level Full TimeLocations: Vancouver, British Columbia, Canada1d ago
-
Sr Data Engineering Developer CAD 83K-133KAzure Data | Azure Data Lake | Azure Data Lake Storage | Azure Purview | Azure SynapseDental coverage | Disability coverage | Employee assistance program | Flexible work options | Health and wellness programsSenior-level Full TimeGuelph, Ontario, Canada; Toronto, Ontario, Canada; … R1d ago
-
Senior Data Engineer CAD 115K-145KAPI Integration | Azure Data | Azure Data Factory | Boomi | Cloud DataEmployee assistance program | Employee discounts | Health benefits | Life and disability insurance | On-site gymSenior-level Full TimeSaint John, NB, CA1d ago
-
Data Engineer CAD 70K-115KAPIs | Boomi | DBT | Data Governance | Data LineageCareer development | Dental coverage | Disability insurance | Employee assistance program | Employee discountsMid-level Full TimeSaint John, NB, CA1d ago
-
Associate Data Engineer CAD 70K-106KAPI Integration | Boomi | DBT | Data Governance | Data ModelingDental vision medical coverage | Employee assistance program | Employee discounts | Health benefits | Life and disability insuranceMid-level Full TimeSaint John, NB, CA1d ago
-
AI Engineer Lead, Application Development CAD 85K-123K.NET | AI Document Intelligence | API Management | Automated testing | AzureCareer advancement | Community volunteer opportunities | Health benefits | Social events | Supportive team cultureSenior-level Full TimeToronto, ON, CA1d ago
-
Développeur II - IA Vision par ordinateur - MLOps CAD 81K-135KAgile | Apache Spark | Azure | Big Data | CI/CDFlexible schedule | Health insurance | Hybrid telework | Life insurance | Retirement planMid-level Full TimeMontréal, QC, CA1d ago
-
Data Infrastructure Engineer USD 180K-215KBatch inference | Cloud Computing | Data Pipelines | Data Processing | Distributed SystemsAccess to latest technologies | Collaborative culture | Health insurance | Inclusive work environment | Professional growth opportunitiesMid-level Full TimeLos Angeles, Palo Alto, San Francisco, …1d ago