ETL/Data Engineer

Location: Montreal, QC, Canada
Date Posted: 20-08-2018
We are recruiting for a contract consultant to work on a large Data Re-engineering project for a client in the Montreal area.
The ETL/Data Engineer will be responsible for developing the Data Pipeline and ETL processes.
Key Responsibilities:
  • Design & Build Data Pipeline
  • Establish best practices around data integration for the clients ETL tool of choice.
  • Design & establish a scalable data pipeline process.
Key Requirements:
  • Experience of working in cloud & open source environment is a must.
  • Data architecture experience in a medium-large enterprise environment
  • Knowledge of performance considerations for different database designs in different environments
  • Background in data warehouse design (e.g. dimensional modeling) and data mining
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
  • Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI)
  • Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
  • Experience in structured methodologies for the design, development and implementation of applications
  • Experience in the use of data modelling methods and tools, including a working knowledge of metadata structures, repository functions, and data dictionaries.
  • Experience in monitoring and enforcing data modelling/normalization standards
  • Experience with various aspects of information management at the enterprise level (data governance, data quality, master data management, information life cycle, etc.)
Thank you for your interest. We will contact all qualified candidates.
this job portal is powered by CATS