Find similar career opportunities
Data Engineer Senior Category: Software Development/ Engineering
Main location: Canada, Quebec, Montréal
Position ID:J1126-0148
Employment Type: Full Time
Position Description: The Data Engineer Senior acts as a specialist in the design, development, integration and optimisation of data solutions. They contribute to the implementation of pipelines, integration flows, data models and consumption layers, enabling clients to utilise reliable, integrated and high-quality data.
They work in modern analytics environments, primarily Azure, and collaborate with technical teams, business analysts, architects, BI teams and business stakeholders to deliver solutions tailored to clients' operational and analytical needs.
Your future duties and responsibilities: 1. Design, develop and optimise robust, scalable and maintainable data pipelines.
2. Develop and maintain ETL/ELT flows for the integration, transformation and consolidation of data from multiple sources.
3. Contribute to the design of data models, consumption layers and analytical structures tailored to business needs.
4. Work with cloud and data environments, including Azure Data Factory, Data Lake, Synapse, Databricks or comparable technologies.
5. Develop or support data products, reports, dashboards or value-added analytical solutions.
6. Ensure the quality, validation, traceability, performance and documentation of data processing.
7. Collaborate with business analysts, architects, developers, BI teams and business partners.
8. Participate in the integration of solutions with various data platforms, APIs, source systems and consumption tools.
9. Contribute to the testing, validation, deployment and support of delivered solutions.
10. Take part in Agile ceremonies, work estimation and continuous improvement.
11. Interact directly with clients to understand their needs, explain technical issues in layman's terms and contribute to discussions on solutions.
Required qualifications to be successful in this role: Technical skills required
1. Excellent command of SQL and Python.
2. Significant experience in the design, development and optimisation of data pipelines.
3. Experience with ETL/ELT concepts, data integration, transformation and orchestration.
4. Experience with Azure environments, ideally Azure Data Factory, Data Lake, Synapse or comparable technologies.
5. Experience with Databricks is highly desirable.
6. Good understanding of data modelling, consumption models and analytical environments.
7. Knowledge of the principles of data quality, validation, governance, traceability and security.
8. Experience with BI or data visualisation tools.
9. Experience in an Agile environment.
Technical Assets
1. Knowledge of AWS, Microsoft Fabric, Power BI or Snowflake.
2. Experience with ETL tools such as Informatica, Talend, SSIS or equivalents.
3. Knowledge of Data Vault, Star Schema, Data Mart or dimensional modelling.
4. Experience with CI/CD, Git, Jira, Confluence or comparable tools.
5. Experience in data preparation for AI, ML or advanced analytics use cases.
6. Experience in the retail, distribution, logistics or shared services sectors.
Key requirements
1. Approximately 5 to 7 years' experience in IT, primarily in data engineering.
2. A bachelor's degree in computer science, software engineering, information systems or equivalent experience.
3. Ability to work independently in a client-facing environment.
4. Good communication and explanation skills, and the ability to collaborate effectively with technical and business teams.
5. Ability to analyse complex issues and propose practical solutions.
6. Bilingual in French and English.
7. Based in the Montreal area or available to work with clients in Montreal.
Target salary range: ideally between $105,000 and $115,000.
Use of the term 'engineering' in this job posting refers to the technical sense related to Information Technology (IT) and does not imply that the individual practices engineering or possesses the requisite license as prescribed by the applicable provincial or territorial engineering regulator. We are seeking individuals with expertise in IT engineering-related functions, but licensure from an engineering regulator is not a prerequisite for this position. Engineering is a regulated profession in Canada which is restricted in terms of use of titles and designation.
Skills: 
