Senior Software Developer / Développeur de logiciels principal

The Maples Group (Financial Services)•Montreal, QC

8d•Onsite

About The Position

We are looking for an accomplished Lead Software Developer to join our Information Technology team as part of our financial services business in Montreal. The Senior Software Developer reports to the Manager, Architecture & Development and supports Information Technology Team. We are seeking a highly skilled Senior Developer with Data analysis expertise to design, build, and maintain scalable data solutions that support reporting, analytics, and data migration initiatives. The ideal candidate combines strong SQL expertise with advanced data analysis capabilities and hands-on experience in scripting languages such as C# and Python. This role requires a detail-oriented professional capable of working across the full data lifecycle—from sourcing and transforming data to enabling business insights and executing complex data migrations between systems. The candidate will collaborate closely with both technical teams and business stakeholders to ensure data accuracy, consistency, and integrity across platforms. Experience in financial services or fiduciary environments is considered a strong asset. Consistently recognised as one of Montreal’s Top Employers, the Maples Group established our operations in the central downtown area in 2009. Our Montreal office exemplifies our culturally rich and entrepreneurial organisation, with over 300 colleagues from 50 countries collaborating to deliver best-in-class solutions to clients worldwide.

Requirements

Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience)
Strong expertise in SQL (advanced querying, performance tuning, data modeling)
Proven experience in data engineering and data pipeline development
Demonstrated experience with data migration or system integration projects
Solid programming/scripting skills in Python and/or C#
Strong analytical and problem-solving skills
Experience working with relational databases (e.g., SQL Server, PostgreSQL, Oracle)

Nice To Haves

Experience in financial services, banking, or fiduciary environments
Familiarity with ETL tools (e.g., SSIS, Azure Data Factory, or similar)
Experience with cloud data platforms (e.g., Azure, AWS, or GCP)
Knowledge of REST APIs, file-based integrations (CSV, XML, JSON)
Understanding of data warehousing concepts and dimensional modeling
Experience with data reconciliation, validation, and migration frameworks
Experience with data virtualization platforms (e.g. Denodo)
Exposure to data governance and regulatory frameworks

Responsibilities

Design, develop, and maintain robust data pipelines and ETL/ELT processes
Build and optimize complex SQL queries, stored procedures, and database structures
Ensure data integrity, quality, and consistency across systems
Develop scalable data models to support analytics, reporting, and operational use cases
Plan and execute data migration initiatives across systems and platforms
Analyze source and target data structures, and define transformation logic
Develop migration scripts and tools using SQL, Python, and/or C#
Validate migrated data to ensure completeness, accuracy, and reconciliation
Support system implementations, upgrades, and decommissioning activities
Perform in-depth data analysis to support business and operational decisions
Collaborate with stakeholders to translate business requirements into data solutions
Identify trends, anomalies, and data quality issues through exploration
Develop and maintain scripts using Python and/or C# for data processing and automation
Integrate APIs, external data sources, and file-based systems into workflows
Automate repetitive processes to improve efficiency and reliability
Monitor and optimize database performance and query execution
Implement best practices for indexing, partitioning, and data storage
Troubleshoot and resolve data-related issues in production environments
Work closely with data analysts, architects, and business teams
Contribute to data governance, documentation, and standards
Ensure compliance with data security and regulatory requirements