View all jobsData Engineering Advisor - 76917
Montreal (Hybrid), QCJob description:
Context: Create Data entity in Snowflake using DBT
Main tasks:
- Design, develop, implement and support robust ETL/ELT/Data Pipelining solutions
- Provide support in requirements definition, estimation, development and delivery of robust and scalable solutions
- Development and support of real-time data ingestion processes from various data sources
- Development and support of data models optimized for business intelligence usage
- Build integrations with APIs from external providers such as Google, Facebook, Salesforce, SAP and others
Qualification
- Master’s degree in business intelligence or equivalent
- 4 years of experience as a data engineer
- Solid and demonstrated experience on following technologies:
- Snowflake
- DBT
- Talend and/or Azure Data Factory
- Microsoft SQL Server
- Power BI
- Fluent in various programming languages such as:
- T-SQL
- Python
- Javascript / Node.js
- Java
- Understands and puts into practice data modeling, design and development of solid
- ETL/ELT data pipelines
- Fluent in writing, executing and optimizing complex SQL queries
- Experience implementing API Service architectures ( REST)
- Develop clean and maintainable code in a CI-CD Environment
- Experience in using cloud BI technologies such as Azure or similar
- Experience in data profiling