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
- Design, develop and optimise robust, scalable and maintainable data pipelines.
- Develop and maintain ETL/ELT flows for the integration, transformation and consolidation of data from multiple sources.
- Contribute to the design of data models, consumption layers and analytical structures tailored to business needs.
- Work with cloud and data environments, including Azure Data Factory, Data Lake, Synapse, Databricks or comparable technologies.
- Develop or support data products, reports, dashboards or value-added analytical solutions.
- Ensure the quality, validation, traceability, performance and documentation of data processing.
- Collaborate with business analysts, architects, developers, BI teams and business partners.
- Participate in the integration of solutions with various data platforms, APIs, source systems and consumption tools.
- Contribute to the testing, validation, deployment and support of delivered solutions.
- Take part in Agile ceremonies, work estimation and continuous improvement.
- Interact directly with clients to understand their needs, explain technical issues in layman’s terms and contribute to discussions on solutions.
Technical Skills Required
Required qualifications to be successful in this role
- Excellent command of SQL and Python.
- Significant experience in the design, development and optimisation of data pipelines.
- Experience with ETL/ELT concepts, data integration, transformation and orchestration.
- Experience with Azure environments, ideally Azure Data Factory, Data Lake, Synapse or comparable technologies.
- Experience with Databricks is highly desirable.
- Good understanding of data modelling, consumption models and analytical environments.
- Knowledge of the principles of data quality, validation, governance, traceability and security.
- Experience with BI or data visualisation tools.
- Experience in an Agile environment.
Technical Assets
- Knowledge of AWS, Microsoft Fabric, Power BI or Snowflake.
- Experience with ETL tools such as Informatica, Talend, SSIS or equivalents.
- Knowledge of Data Vault, Star Schema, Data Mart or dimensional modelling.
- Experience with CI/CD, Git, Jira, Confluence or comparable tools.
- Experience in data preparation for AI, ML or advanced analytics use cases.
- Experience in the retail, distribution, logistics or shared services sectors.
Key requirements
- Approximately 5 to 7 years’ experience in IT, primarily in data engineering.
- A bachelor’s degree in computer science, software engineering, information systems or equivalent experience.
- Ability to work independently in a client-facing environment.
- Good communication and explanation skills, and the ability to collaborate effectively with technical and business teams.
- Ability to analyse complex issues and propose practical solutions.
- Bilingual in French and English.
- Based in the Montreal area or available to work with clients in Montreal.
Target salary range: ideally between $105,000 and $115,000.
Together, as owners, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll reach your full potential because…
You are invited to be an owner from day 1 as we work together to bring our Dream to life. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.
At CGI, we value the strength that diversity brings and are committed to fostering a workplace where everyone belongs. We collaborate with our clients to build more inclusive communities and empower all CGI partners to thrive. As an equal-opportunity employer, being able to perform your best during the recruitment process is important to us. If you require an accommodation, please inform your recruiter.
That same commitment to fairness extends to how we use technology. To support our recruitment team, AI tools may be used to help assess applications though they never replace human judgement. All hiring decisions remain entirely in the hands of our recruitment professionals.
To learn more about accessibility at CGI, contact us via email. Please note that this email is strictly for accessibility requests and cannot be used for application status inquiries.
Come join our team - one of the largest IT and business consulting services firms in the world.
