Global Treasury Operations Analyst - Bank Reconciliation

Responsibilities:

1. Database Administration - Develop range of spreadsheet modelling applications and database/web-mining tools utilizing SQL and VBA for applications. Includes manipulation and development of automated spreadsheets and database applications through VBA programming.
2. Technology Tool Enabler ­­– act as champion in utilizing automation tools in enhancing business processes like Power Platform (BI, Automate, Apps) and Alteryx.
3.Continuous Improvement - Serve as a change agent by continuously searching and proposing more efficient ways of doing day-to-day activities/processes.
4. Stakeholder Management - Effectively gather stakeholder requirements, through workshops and focus group discussions, and incorporate in the output/product. Ensure that requirements are also aligned with the organization's directions. Create user manuals based on output/product and conduct training, if necessary.
5. Project Management - Follow short iterative and incremental development cycles to produce prototypes allowing faster product delivery, early testing of prototype and continuous integration. Create test plans to ensure requirements are captured and executed correctly. Document product timeline and transition plan.
6.Special Projects - AdHoc projects as required will arise from time-to-time.

Requirements:

• University degree (preferably BS Computer Science or BS Information Technology).
• Advanced Excel VBA experience is required.
• Strong experience of automation / optimizing PROD performance via MS Excel.
• Strong background on Alteryx and Power Platform (Power BI, PowerApps and Power Automate) Tools.
• SQL Server and SSIS background, preferred.
• Effective verbal and written communication for both technical and non-technical stakeholders / audience.
• Well-developed analytical skills, with the ability to define document and resolve problems utilizing a variety of analytical tools.
• Capable of gathering and validating requirements in order to resolve issues and problems.
• Good understanding of agile development.
• Well-developed planning and organization skills.
• Understanding of general finance systems or applications.

When you join our team:

• We’ll empower you to learn and grow the career you want.

• We’ll recognize and support you in a flexible environment where well-being and inclusion are more than just words.

• As part of our global team, we’ll support you in shaping the future you want to see.

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 hr@manulife.com.