Are you looking for unlimited opportunities to develop and succeed? With work that challenges and makes a difference, within a flexible and supportive environment, we can help our customers achieve their dreams and aspirations.Job DescriptionJob description SummaryResponsible for the design and development of business intelligence solutions based on requirements provided by the businessKey Accountabilities:Design, build and deploy business intelligence solutions based on specifications
Enhance and improve implementation of business intelligence solutions
Application stability and maintenance processes
Specialty programming and scripting associated with QlikView, QlikSense, Microsoft Power BI and Tableau (or any other similar tool)
Evaluate and improve existing Business Intelligence dashboards
Administration of business intelligence solutions
Execute database queries and conduct analyses
Undertake projects and ad-hoc requests as required
Help build center of excellence for Business Intelligence solutions implementations
Other duties and tasks as assigned by Operations Management
Minimum Skills Requirement to Hire:The candidate:Computer Science, Engineering, Mathematics, Statistics, programming background preferred
Atleast 2 years experience with data visualization or business intelligence development
Project management experience preferred
Technical Skills:In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, Transform, Load) framework
Experienced with BI technologies (e.g. Qlikview, QlikSense, Power BI, Tableau)
Background in data warehouse design (e.g. dimensional modeling) and data mining
Knowledge of structured analysis and design techniques preferred
Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
Understanding of design and development tools, SDLC methodologies and techniques, preferred
Acute numerical and analytical skills. Intermediate mathematical skills
Soft skills: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
Excellent English written and verbal communication skills.
Ability to work independently and act professionally at all times
Minimum Skills Requirements to Go-live:
Product Specific Knowledge
Demonstrate basic knowledge of data model for business intelligence solutions
Ability to layout and design BI solutions
Understanding the basic use of business intelligence objects
Ability to identify which chart will provide the best visual representation of data to the viewer
Ability to resolve data structure issues
Ability to debug and fix identified issues
Ability to use common images, scripting text and graphics
Able to define the basic and advanced uses of the script editor, including calendar and date manipulations
Able to use transformative functions in the script
Able to understand the PDF report writer
Basic knowledge and understanding of Set Analysis and other advanced level features as required
Ability to connect BI tools to different data sources
Process Specific KnowledgeBusiness Discovery
Data Visualization
Software Development Life Cycle
Tools Specific KnowledgeQlikView 12 and newer (Desktop Edition)
Qlik NPrinting
Microsoft Power BI
QlikView Management Console
MS Access
MS SQL
MS Excel
Other Database Expertise
If you are ready to unleash your potential it’s time to start your career with Manulife/John Hancock.About Manulife
Manulife Financial Corporation is a leading international financial services group that helps people achieve their dreams and aspirations by putting customers' needs first and providing the right advice and solutions. We operate as John Hancock in the United States and Manulife elsewhere. We provide financial advice, insurance, as well as wealth and asset management solutions for individuals, groups and institutions. At the end of 2016, we had approximately 35,000 employees, 70,000 agents, and thousands of distribution partners, serving more than 22 million customers. At the end of 2016, we had $977 billion (US$728 billion) in assets under management and administration, and in the previous 12 months we made almost $26 billion in payments to our customers.
Our principal operations are in Asia, Canada and the United States where we have served customers for more than 100 years. With our global headquarters in Toronto, Canada, we trade as 'MFC' on the Toronto, New York, and the Philippine stock exchanges and under '945' in Hong Kong.
Manulife is committed to supporting a culture of diversity and accessibility across the organization. It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will consult with applicants contacted to participate at any stage of the recruitment process who request an accommodation. Information received regarding the accommodation needs of applicants will be addressed confidentially.
