Specialist, Data Engineering

Sherweb•Montreal, QC

13d•Hybrid

About The Position

We work to simplify the cloud for IT professionals so they can focus on what really matters, making their customers’ lives better. Find out how we do that here: www.sherweb.com/about/. As a Specialist, Data Engineer,ing you’ll be responsible for designing, building and maintaining data systems using the Microsoft Fabric platform. Your tasks will include creating and managing data using a lakehouse, designing pipelines to copy data into the lakehouse and using Spark job definitions for batch and streaming jobs. You’ll work with tools like Azure Data Factory, PySpark notebooks, Spark SQL and Python to implement scalable and efficient data pipelines, covering data ingestion, transformation and loading processes.

Requirements

Bachelor’s degree in Information Technology, Software Engineering, Computer Science, Master's degree in Business Intelligence or a relevant field for the role.
Minimum of 4 years of experience in implementing data extraction, transformation and loading (ETL or ELT or ELTL) processes.
Knowledge of the Microsoft Azure data platform (Azure Data Factory/Azure Synapse/Azure Functions/Databricks/Azure SQL Database/Azure Storage).
Knowledge of data modeling for a data warehouse.
Demonstrated experience with databases and SQL language.
Demonstrated experience in Python programming.
Excellent oral and written communication skills in English and French is an asset.
Strong analytical and synthesis skills, result-oriented and customer service-focused.
Initiative-driven with good problem-solving abilities.

Nice To Haves

Excellent oral and written communication skills in English and French is an asset.

Responsibilities

Design and optimize the structure of databases and data lakes to store and organize a large volume of data.
Design and modify the necessary data model to support analytical needs of data representations and storage.
Implement processes for complex data extraction, transformation and loading.
Set up automation processes to facilitate data flows from various sources to the data warehouse and storage environment.
Prepare and integrate data feeding analytical solutions using the Microsoft Azure platform (Azure Data Factory, Azure Synapse, Azure Databricks, Azure SQL Database, Azure Storage).
Document the established data transformation rules.
Be responsible for managing costs related to usage and storage to maintain an optimized environment.

Benefits

A fast-paced work environment that adapts to you
A friendly and diverse work culture with inclusion and equality at the heart of our actions
State-of-the art technology and tools
A results-oriented culture where talent, action, and thinking outside the box are given due recognition
Annual salary review based on performance
Generous and caring colleagues of various professional and cultural backgrounds
A base salary ranging between 81 270$ and 116 100$ yearly
Vacation time that considers your previous experience
Advanced paid hours to recharge your batteries (holidays and mobile days)
Flexible benefits plan that adapts to your needs
Flexible savings fund option
A monthly home internet allowance
A career path with opportunities to learn and grow
Proximity to your direct manager and open, honest communication to support your development
Multiple initial and on-the-job training opportunities and tools to track your progress and help you scale up in your career