Specialist, Data Engineering

Location: remote/Hybrid (Montreal/Sherbrooke) Here's What We Do And Why We Do It 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/. Here's how you will contribute to the success of the company 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.

• 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.

Here's what you need to have and master to get the job

• 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.

Benefits Of Working At Sherweb Sherweb is, above all, an environment where the needs of our customers are at the heart of our actions. We are committed to living our values of passion, teamwork and integrity every day. 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 Flexible Total Compensation Offer

• 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

Considerable growth opportunities

• 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

Last but not least: “Sherweblife” - a rich calendar of activities that allow us to gather virtually and face-to-face throughout the year At Sherweb, we believe in pay transparency and fairness. The salary range provided is intended to give an indication of what you might expect for this role. However, we recognize that each candidate brings a unique set of skills and experiences. As such, the final compensation package will be tailored to reflect the specific qualifications and expertise of the chosen candidate, ensuring that we remain competitive and equitable in our offerings. Reasons for the requirement of English: Sherweb has international customers and fluency in English is the only way to ensure proper service delivery to them. The main tasks related to this position require written and oral communication with an English-speaking clientele at all times.