Python data processing engineer

The Opportunity

We are looking to hire a Data Processing Engineer with expertise in Python, ETL, and SQL Script. This role will be essential for various projects over the next few years. The role is mainly to build ETL transformation jobs for feeds received from upstream systems in different data types, to be processed with different applications in the downstream systems.

Responsibilities

• Python Development: Develop and maintain Python scripts for data processing and engineering tasks.
• Data Engineering: Handle data transformation jobs, ensuring data integrity across different systems.
• ETL Processes: Build ETL (Extract, Transform, Load) jobs for data feeds received from upstream systems and processed by downstream applications.
• SQL Queries: Develop complex SQL queries in Microsoft SQL for data manipulation.
• Automation: Write shell scripts to automate various processes.
• Systems Integration: Work with SQL and ensure seamless data integration and processing.
• Experience with Shell Scripting is an asset for this role.
• Work through the software development lifecycle - design, develop, test, deliver, and improve business applications.
• Acting as the Finance systems Domain Expert, work closely with other areas in Group Function, architecture, platform, and operations team to ensure architecture and system design meet the business requirements and attain any support required to complete development initiatives.
• Manage risk associated with systems changes by following change and release management processes.
• Collaborate with the Group Function Information Risk Management team to implement all system controls and processes correctly.
• Work closely with the business teams to gather requirements for new and changes to existing business solutions.
• Uphold thorough and accurate documentation procedures within the department to communicate requirements, design, testing, and implementation approaches and plans for development initiatives.
• Continuously interact with operations teams by involving them in appropriate stages of analysis, development, testing, and implementation handovers.

What we are looking for

• Bachelor’s degree in Computer Science, Software Engineering, or Mathematics.
• 5 years of enterprise development experience with Python for data processing (including data integration, data transformation, data migration).
• 5 years demonstrated ability in SQL.
• 2 years of experience in building shell scripts (nice to have).
• Strong background in data engineering, particularly in handling data transformations.
• Advanced skills in writing complex SQL queries.
• Experience with ETL processes, especially using Python.
• Technical knowledge of application development lifecycle and testing methodologies.
• Working knowledge of GitHub, Selenium, Postman, C#, SQL Server, Oracle, Hadoop/Hive, and BI tools (e.g., Power BI / OLAP tool).
• Dedicated and able to work independently with an appetite for learning.
• A focus and passion for creating excellent customer experiences.
• Innovation, creativity, and curiosity.
• Clear, concise, tactful communication skills.
• Confidence to challenge and ask hard questions of colleagues, technical teams, and vendors.
• Demonstrated ability to be flexible and exercise judgment in a changing environment and able to adapt and respond to rapid changes and shifting priorities.

What can we offer you?

• A competitive salary and benefits package.
• A growth trajectory that extends upward and outward, encouraging you to follow your passions and learn new skills.
• A focus on growing your career path with us.
• Flexible work policies and strong work-life balance.
• Professional development and leadership opportunities.

Our commitment to you

• Values-first culture: We lead with our Values every day and bring them to life together.
• Boundless opportunity: We create opportunities to learn and grow at every stage of your career.
• Continuous innovation: We invite you to help redefine the future of financial services.
• Delivering the promise of Diversity, Equity, and Inclusion: We foster an inclusive workplace where everyone thrives.
• Championing Corporate Citizenship: We build a business that benefits all customers and has a positive social and environmental impact.

Location: Toronto, Ontario

Work Schedule: Compressed workweek, Hybrid

Salary Range: $75,880.00 CAD - $140,920.00 CAD