Job Summary: The Data Analyst (Associate Business Intelligence Developer) will collaborate closely to the business and technical teams, responsible for providing business insights through in-depth analysis on financial and non-financial data. the resource will be responsible for transforming the data into insights, implement innovative solutions to analyze thru data visualization and recommend appropriate BI Tool (e.g. Power BI, Qlikview, QlikSense, Tableau) that will enable the users for any data driven actions based on the business needs. The role will also develop standardized reports and working files to be used as a data load in BI tools to create analytically rich solutions to critical information for individuals across all the functional groups within Manulife.

Key Accountabilities:

· Be partnered with users, product owners & data engineers to design, develop and maintain business intelligence solutions (dashboard & interactive reporting tools on key business measures)

· Work directly with business stakeholders and translate business data needs into technical requirements, design, and implementation thru data visualization.

· Develop, Test and Maintain BI Dashboard to high standards of quality and performance using the company approved BI Tools. (e.g. Power BI, Qlikview, QlikSense, Tableau)

· To utilize UI/UX best practices to craft visualizations that create a single, aligned version of truth, present clear information about business results & call for action.

· Responsible on training and/or assisting the Reporting Team on optimizing their reports. And implement best practices to ensure the quality and consistency of the solutions.

· Flexible on working with low to high complex projects with a possibility on utilizing multiple BI tool for each solutions.

· To be able to provide and maintain user accesses, report connections and troubleshooting by navigating to the management consoles or workspaces.

Minimum Skills Requirement to Hire:

The candidate:

· Bachelor’s degree in finance, business administration, economics, Computer Science, Mathematics, Statistics, and any relevant field with Business Intelligence.

· Advanced Excel spreadsheet and VBA skills and relational databases (MS SQL, Oracle) and Business Intelligence area.

· Hands on experiences on developing BI solutions preferably with Power BI, Qlikview, or QlikSense.

Technical Skills:

· Work with business stakeholders and senior management reporting & analytics analyst to define business requirements; identify and recommend potential data sources and solutions; and develop customized reports, analyses, and/or data visualizations that answer the problem.

· Identify and design data workflow processes that ensure data integrity and accuracy across the entire organization and ensure data is presented in a structured and easy to understand manner with actionable insights.

· Provides research and data gathering activities to enrich the data set

· Proficient in Data Modelling and Data Model normalization

· Knowledgeable with the ETL methodology.

· Working experience in Advanced Excel spreadsheet and VBA skills

· Accustomed on utilizing relational databases (MS SQL, Oracle) and Business Intelligence area.

· Understanding of design and development tools, SDLC methodologies and techniques, preferred

· Curiosity and analytical mindset – ability to ask the right questions and propose solutions. With a strong evidence of being able to transform data into actionable insights.

· Competent data storytelling and visualization – practiced creating solutions which aligns not only with the business requirements but as well as the company’s branding.

· Help provide business insights to uncover growth and expense levers (revenue and cost), identify, evaluate and size opportunities to improve business value.

· Manage assigned projects and support activities of team. Ensure accuracy and efficiency in project completion and work cooperatively with all internal and external contacts.

· Ensure adherence to data management/data governance regulations and policies

· Attends weekly updates to business sponsor, leadership, and other stakeholders to include a high-level overview of project progress, risks, and issues. Experienced with BI technologies (e.g. Qlikview, QlikSense, Power BI)

· Familiar on working in agile (SCRUM) is an advantage and well-versed on Project management is preferred

Soft skills:

· Manifest finesse with customer management and project administration.

· Outstanding communication skills for both written and verbal.

· Ability to allocate time efficiently, handle multiple demands and competing priorities.

· Planning and organization skills, including the ability to prepare schedules and communicate status of overall development effort.

· Ability to work independently and act professionally at all times.

· Adaptable to teamwork and dynamic work environment.

Process Specific Knowledge

· Software Development Life Cycle

· Business Solutions Discovery

· Data Modelling and Normalization

· Agile/Scrum Methodology

Tools Specific Knowledge:

· Advance Excel VBA skills

· MS SQL

· MS Access

· Enterprise Data Lake

· Intermediate Expertise on any of the following BI Tools, Power BI, QlikView, QlikSense

· Basic Qlik Management Consoles / Power BI Workspace Management

· Familiarity with Tableau

· Knowledgeable with MS Excel

· Familiarity with NPrinting or MS Reports Builder

· Practiced the following relational databases:

· Familiarity with MS Power Applications is a plus

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.