Original job description
Location: Montreal, Quebec - Onsite Work Required
We are looking for a Python/Data Software Engineer with a focus on building and maintaining complex data pipelines and tooling within our global financial services environment. This role primarily supports data engineering, reconciliation processes, and enterprise productivity tooling on platforms serving millions of customers worldwide.
Key Responsibilities:
Develop, maintain, and optimize ETL pipelines primarily using Python and Informatica.
Design and implement data workflows on Snowflake or comparable cloud data platforms.
Build reliable data reconciliation tools and enterprise automation scripts to support business-critical operations.
Write efficient, maintainable, and well-tested Python code following object-oriented principles.
Develop and optimize complex SQL queries for data extraction, manipulation, and analysis.
Automate the management of data workflows using scripting languages such as Shell, Bash, or PowerShell.
Collaborate with cross-functional teams to gather requirements and deliver scalable solutions that improve data integrity and operational efficiency.
Contribute to best practices around code quality, testing, and deployment.
Required Skills & Experience:
Strong proficiency in Object-Oriented Python development.
Experience designing and executing ETL processes, preferably with Informatica.
Hands-on experience with modern cloud data warehouses such as Snowflake, Redshift, or BigQuery.
Solid SQL skills for complex query writing and performance optimization.
Proficiency in scripting languages like Shell, Bash, or PowerShell.
Understanding of data modeling, data pipeline optimization, and distributed data processing concepts.
Familiarity with software development best practices, source control, and CI/CD pipelines.
Experience working in Agile environments.
Full working proficiency with English (Written and Verbal)
Preferred Qualifications:
Bachelor’s or Master’s degree in Computer Science, Data Engineering, or a related discipline.
Prior experience in financial services, especially with data reconciliation or risk-related data workflows
