Description Are you experienced in leveraging data to highlight opportunities for operational efficiencies and building new operational reporting? Do you enjoy utilizing tools for reporting such as Excel, VBA, PowerBI and SQL? Do you like learning about new technologies such as Python? Do you like to connect with stakeholders to understand their business and operational needs to partner on solutions to automate or report on their day-to-day transactional activities? Do you want to own your work and help us be more effective and efficient as a Bank Operations team?What if I told you we're working towards modern tools and processes including Agile, Human Centered Design, Jira and CRM? What if I told you we are keen to innovate, and we’re growing?At Manulife Bank, we believe banking products are an integral part of every Canadian's financial plan. As one of Canada's youngest banks, we are growing at an unprecedented rate and need people with the skills, energy, and drive to maintain our position. We offer competitive pay, an encouraging work environment with flexible hours, and we have a team of highly engaged and motivated employees and leaders who want to make a difference.What will I be doing?You will join forces with other dedicated people to analyze business needs, create business requirements and deliver solutions to through various Automation and Digitization opportunities. Having some tech savviness along with strong analytical skills & business experience will be crucial in this role. If you thrive on this type of work, then we need your people-smarts and keen mind as an Operations Data and Reporting Consultant on our Operational Initiatives Team.Your responsibilities would include:Using your analytical skills and critical thinking to ask questions, understand sophisticated business processes and creating automated solutions using tools such as Power BI, SQL, CRM, and SharePoint and embedding good risk management practices along the waySupporting existing Operations reporting needs and delivering accurate self-serve reporting solutions using tools such as SQL Reporting Services, PowerBI, SQL, VBA, Access, and Excel using various data sourcesConducting current state analysis and documenting business processes.Connecting and communicating with stakeholders regularly to understand their businesses, systems and processes to pinpoint processing or data gaps and to highlight areas of opportunity that will help move our business forwardUsing a variety of requirements modelling techniques - such as user stories, process mapping, acceptance criteria, and business rules – to convey informationProviding consulting support for complex Operational initiatives by understanding business data interdependencies to identify efficient solutionsCapitalizing on your ability to build and foster positive, effective relationships to strengthen your partnership with key stakeholdersDelivering documented solution requirements so that everyone has a clear and consistent understanding of the proposed solutionUsing your strong communication skills to lead/collaborate with working groups and present information to all levels within the companyPreparing our business partners for changes that are introduced and articulating what it will mean for them specificallyWrites and executes test plans and test cases for your initiative and validate expected resultsUsing your analytical skills and critical thinking to ask questions, understand our business drivers and needs, and bring order and precision to scope and requirements on Operational initiativesInfluencing your teammates with your good humor and passion for your role!QualificationsAm I right for the job? Bachelors or diploma in Computer Science/Business Administration5 years or more of relevant work experienceYou are proficient in using TSQL/SQL Server, stored procedures and creating complex SQL queriesYou have advanced knowledge of Excel (Pivot Tables, VBA Macros), Access, Visio, Power Automate, Power Apps, PowerBI and SharePoint reporting servicesYou are knowledgeable in Process Management and Optimization approaches, methodologies, and tools such as LEAN, Six-Sigma, and BPMNFamiliarity with computer programming concepts and database architecture is an asset.You are familiar with web technologies like HTML, VBScript, R, JavaScript, CSS, and tools such as InfoPath and QlikViewYou have demonstrable experience in learning new technologies and tools at a rapid paceYou have extensive experience creating business reports that provide insight into key data pointsYou serve as a thought leader for low-tech/no-tech solutions to drive value for the business.You are a strategic thinker with the ability to think conceptually beyond day-to-day business realities and to effectively consider downstream impactsYou successfully manage competing priorities like a championYou maintain your composure and best-self during challenging times or challenging interactionsYou’re a capable and innovative problem-solver using sound judgement to make business decisions that drive results and solve customer problemsYou know how to build successful relationships with your coworkers and mesh naturally in an environment with geographically and culturally diverse cross-functional teamsYou already know a bit about financial services and Bank productsYou are accountable – you make it happen, you own it and you find solutionsSo what’s next?If you're interested in the idea of joining our team don't let this complete list of items deter you. We'd love to hear from you and a cover letter telling us about yourself and why you want to work with us. We are looking for our next great team member – and we want to hear from you!About Manulife and John HancockManulife Financial Corporation is a leading international financial services group that helps people make their decisions easier and lives better. With our global headquarters in Toronto, Canada, we operate as Manulife across our offices in Asia, Canada, and Europe, and primarily as John Hancock in the United States. We provide financial advice, insurance, and wealth and asset management solutions for individuals, groups and institutions. At the end of 2022, we had more than 40,000 employees, over 116,000 agents, and thousands of distribution partners, serving over 34 million customers. At the end of 2022, we had $1.3 trillion (US$1.0 trillion) in assets under management and administration, including total invested assets of $0.4 trillion (US $0.3 trillion), and segregated funds net assets of $0.3 trillion (US$0.3 trillion). We trade as ‘MFC’ on the Toronto, New York, and the Philippine stock exchanges, and under ‘945’ in Hong Kong.Manulife is an Equal Opportunity EmployerSalary & BenefitsThe annual base salary for this role is listed below.Primary LocationWaterloo, OntarioSalary range is expected to be between$65,775.00 CAD - $109,625.00 CADIf you are applying for this role outside of the primary location, please contact 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 for more information about U.S.-specific paid time off provisions.