Operations Data & Reporting Consultant - Jobs in Halifax

Job Description

We are a leading financial services provider committed to making decisions easier and lives better for our customers and colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. To help us stand out, we help you step up, because when colleagues are healthy, respected and meaningfully challenged, we all thrive. Discover how you can grow your career, make impact and drive real change with our Winning Team today.Working ArrangementHybridJob Posting DescriptionAre 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 teamWhat if I told you we #39;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 #39;re growingAt Manulife Bank, we believe banking products are an integral part of every Canadian #39;s financial plan. As one of Canada #39;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 doingYou 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 skillsamp; 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 way
• Supporting 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 sources
• Conducting 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 forward
• Using a variety of requirements modelling techniques - such as user stories, process mapping, acceptance criteria, and business rules - to convey information
• Providing consulting support for complex Operational initiatives by understanding business data interdependencies to identify efficient solutions
• Capitalizing on your ability to build and foster positive, effective relationships to strengthen your partnership with key stakeholders
• Delivering documented solution requirements so that everyone has a clear and consistent understanding of the proposed solution
• Using your strong communication skills to lead/collaborate with working groups and present information to all levels within the company
• Preparing our business partners for changes that are introduced and articulating what it will mean for them specifically
• Writes and executes test plans and test cases for your initiative and validate expected results
• Using 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 initiatives
• Influencing your teammates with your good humor and passion for your role!

QualificationsAm I right for the job

• Bachelors or diploma in Computer Science/Business Administration
• 5 years or more of relevant work experience
• You are proficient in using TSQL/SQL Server, stored procedures and creating complex SQL queries
• You have advanced knowledge of Excel (Pivot Tables, VBA Macros), Access, Visio, Power Automate, Power Apps, PowerBI and SharePoint reporting services
• You are knowledgeable in Process Management and Optimization approaches, methodologies, and tools such as LEAN, Six-Sigma, and BPMN
• Familiarity 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 QlikView
• You have demonstrable experience in learning new technologies and tools at a rapid pace
• You have extensive experience creating business reports that provide insight into key data points
• You 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 impacts
• You successfully manage competing priorities like a champion
• You maintain your composure and best-self during challenging times or challenging interactions
• You #39;re a capable and innovative problem-solver using sound judgement to make business decisions that drive results and solve customer problems
• You know how to build successful relationships with your coworkers and mesh naturally in an environment with geographically and culturally diverse cross-functional teams
• You already know a bit about financial services and Bank products
• You are accountable - you make it happen, you own it and you find solutions

So what #39;s nextIf you #39;re interested in the idea of joining our team don #39;t let this complete list of items deter you. We #39;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#39;MFC #39; on the Toronto, New York, and the Philippine stock exchanges, and under#39;945 #39; in Hong Kong.Manulife is an Equal Opportunity EmployerAt 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.Salaryamp; 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 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 amp;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.