Posted:
9/10/2024, 9:09:58 AM
Location(s):
Ontario, Canada ⋅ Toronto, Ontario, Canada
Experience Level(s):
Senior
Field(s):
Software Engineering
The Opportunity
We are looking to hire a Software Engineer with expertise in Python for data processing and data engineering. This role will be essential for various projects over the next six years.
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 Oracle/MSSQL for data manipulation.
Automation: Write shell scripts to automate various processes.
Treasury Module: Manage all payments, services, and billing from different regions and stations.
Administrative Systems: Engage with systems related to insurance, clinics, investment procedures, and employee transactions.
Data Transactions: The main task involves data transactions in Azure, you’ll ensure data integrity and consistency across various administrative systems.
Systems Integration: Work with Oracle systems (moving to SQL) and ensure seamless data integration and processing.
How will you create impact?
The opportunity involves working on various modules, including treasury systems, payments, billing, and administrative systems. These systems are integral to Manulife’s financial operations and require meticulous data handling and transformation.
This position offers significant growth opportunities, including potential progression to full-stack development or project management 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 of experience 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.
Familiarity with Azure Data Factory, Synapse for data warehousing, and Power BI for dashboards.
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 stakeholders 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 [email protected].
Primary Location
Working Arrangement
Salary range is expected to be between
$74,270.00 CAD - $137,930.00 CADIf you are applying for this role outside of the primary location, please contact [email protected] 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 [email protected] for more information about U.S.-specific paid time off provisions.
Website: http://www.manulife.com.hk/
Headquarter Location: Kowloon City, Kowloon, Hong Kong
Employee Count: 1001-5000
Year Founded: 1897
IPO Status: Private
Industries: Financial Services ⋅ Life Insurance ⋅ Retirement ⋅ Wealth Management