Principal Data Integration and Master Data Management (MDM) Developer

Become an asset for the community!

Join La Caisse's team and feel proud to contribute to the financial future of millions of Quebecers by creating a more sustainable world.

At La Caisse:

• We value your unique contribution within a global team.
• We trust you with work that allows you to thrive and exceed your limits.
• We offer opportunities to learn alongside generous experts in their fields.
• We fully invest in you, who every day accomplish our mission.

Over the years, we have built a strong culture based on four pillars: ambition to exceed, accountability to concretize our beliefs, openness to enrich ourselves with creative ideas, and collaboration to propel us towards the best results for Quebec's population.

• *The job level may vary depending on the retained profile.*
• Your Role

Within the Reference Data Management team, you contribute to the development, evolution, and maintenance of strategic data solutions that feed the organization's transactional, analytical, and regulatory systems. The team acts as a reference provider for several critical business domains by integrating data from multiple internal and external sources and ensuring their quality, governance, integration, and dissemination across the enterprise.

As part of the modernization of La Caisse's data platforms, you participate in the implementation of robust, high-performance, and scalable solutions to accelerate information access, improve data quality, and support the evolution of analytical and artificial intelligence capabilities. You play a key role in the development, integration, and orchestration of strategic data flows, as well as in the evolution of Master Data Management (MDM) capabilities.

What You Will Do

• Design, develop, and maintain robust, high-performance, and scalable data solutions supporting the organization's activities;
• Develop and optimize ETL/ELT processes, advanced SQL components, and interfaces ensuring data integration, transformation, and dissemination;
• Design and implement data integration and orchestration mechanisms between multiple enterprise systems and platforms;
• Ensure the monitoring, stability, performance, and automation of data flows, including recovery and processing mechanisms;
• Participate in the development and evolution of enterprise data repositories and MDM capabilities;
• Implement data validation, enrichment, reconciliation, quality, and governance rules;
• Provide support for solutions under your responsibility, contribute to incident resolution, and continuous improvement of practices, tools, and processes;
• Collaborate with multidisciplinary teams, contribute to data architecture evolution, and act as a resource person for team members.

What Sets You Apart

• Excellent analytical skills and ability to solve complex problems;
• Rigor and constant concern for quality;
• Strong autonomy and sense of responsibility;
• Initiative and results-oriented mindset;
• Excellent communication and collaboration skills;
• Ability to positively influence your work environment;
• Comfort in evolving within a rapidly changing technological context.

Required Qualifications

• University degree in computer science, software engineering, information systems, or a related discipline;
• Minimum of five (5) years of experience in data solution development;
• Significant experience in developing and operating ETL or ELT processes (MS SSIS, DBT, Dynamic table, etc.);
• Demonstrated experience in integrating and orchestrating complex data flows;
• Practical experience in Master Data Management (MDM) environments;
• Advanced expertise in SQL Snowflake and SQL Server and SQL performance optimization;
• Experience in Python programming;
• Experience in relational and analytical data modeling;
• Experience in implementing data repositories and MDM solutions;
• Knowledge of data quality and governance concepts;
• Experience with Git and DevOps practices;
• Experience in designing and developing data orchestration flows;
• Experience with enterprise schedulers such as Control-M, Autosys, UC4, TWS, or equivalent;
• Good understanding of distributed, asynchronous, and event-driven architectures;
• Knowledge of monitoring, recovery, and automation mechanisms.

Desired Qualifications

• Experience in large-scale critical data environments;
• Experience in the financial or asset management sector;
• Experience with application integration or ESB (Enterprise Service Bus) solutions;
• Knowledge of Databricks;
• Knowledge of Apache Airflow;
• Knowledge of Spark;
• Experience in developing REST APIs;
• Knowledge of cloud-based data architectures;
• Experience in real-time data integration;
• #LI-DNI

*Feeling that my role is important. Enjoying my daily work. Being able to evolve at the pace of my ambitions. Receiving compensation commensurate with my contribution. That's the professional experience La Caisse offers!*

We carefully review each application and will contact the selected candidates for an interview.

La Caisse offers equal employment opportunities to all. We invite women, visible and ethnic minorities, Indigenous people, and people with disabilities to apply. If this job posting motivates you but you do not meet all the criteria, please contact us anyway!

La Caisse is also committed to pursuing equity, diversity, and inclusion as a core value and to making it a source of enrichment and pride for all members of the organization. Please let us know if your current condition requires accommodation measures within the recruitment process.

La Caisse represents La Caisse de dépôt et placement du Québec and its subsidiaries.