Python Data Processing Engineer

The Opportunity

We are looking to hire a Data Processing Engineer with expertise with 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.

How will you create impact?

This position offers significant growth opportunities, including potential progression to leadership roles.

What motivates you?

• You obsess about customers, listen, engage and act for their benefit.

• You think big, with curiosity to discover ways to use your agile approach and enable business outcomes.

• You thrive in teams and enjoy getting things done together.

• You take ownership and build solutions, focusing on what matters.

• You do what is right, work with integrity and speak up.

• You share your humanity, helping us build a diverse and inclusive work environment for everyone.

What we are looking for

• Bachelor’s degree in Computer Science, or Software Engineering, or Mathematics.

• 5 years of enterprise development experience with Python for data processing (inc. data integration, data transformation, data migration).

• 5 years demonstrated ability in SQL.

• 2 years of experience in building shell scripts (nice to have).

• Python scripting experience with data processing

• 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 eg. 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 the wisest of our 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 packages.

• 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.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit https://www.manulife.com/en/about/our-story.html.

Manulife is an Equal Opportunity Employer

At Manulife/John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process, contact recruitment@manulife.com.

Salary range is expected to be between

If you are applying for this role outside of the primary location, please contact recruitment@manulife.com for the salary range for your location. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

Manulife offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S., please contact recruitment@manulife.com for more information about U.S.-specific paid time off provisions.