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 flourish and exceed your limits.
• We offer you opportunities to learn alongside generous experts in their field.
• We fully invest in you, who every day achieve 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 Master 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 company.

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 Master Data Management (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 the evolution of data architecture, 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 developing data solutions;
• 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 Snowflake SQL 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 data architectures;
• Experience in real-time data integration;
• *Feel that my role is important. Have fun every day. Grow at the pace of my ambitions. Earn a compensation that matches my contribution. That's the professional experience La Caisse offers!*

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

La Caisse offers equal employment opportunities to all. We encourage 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 promoting equity, diversity, and inclusion as a key 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 the Caisse de dépôt et placement du Québec and its subsidiaries.