Skip to main content

Job ID:

Job Category:


Job Type:

Date Posted:

Apply Now >>    
Job Title :
Salesforce Data Analyst
Job ID :
Category :
Information Technology
Location :
Kitchener, ON CA
Job Type :
Full Time
Posted On :
Job Description :

Are you looking for unlimited opportunities to develop and succeed?  With work that challenges and makes a difference and a flexible and supportive environment, we can help our customers achieve their dreams and aspirations.
As a key member of Manulife’s new Core Engineering and Architecture team, your job is to advance the strategy and stewardship of Manulife CRM application data.  Core responsibilities include collaborating with application build teams and provide guidance for getting and setting the customer data.   This role is right for you if you have a technical background and you’re ready to roll up the sleeves to learn data quality, establish data governance, build matching and merging methods, and create quality metrics.  If you’ve seen how data is the new currency and you’re eager to learn, this is your opportunity!     
Specific Duties
  • Specialize in collecting, organizing, and analyzing data from various systems
  • Develop an in-depth understanding of the interrelationships of data and multiple data domains
  • Create thorough documentation artifacts and maintain same for duration of project
  • Identify and document data migration paths and processes
  • Demonstrate commitment to providing customer-focused quality service
  • Perform other duties as deemed relevant based upon experience to fulfill customer needs
  • Develop and perform standard queries to ensure data quality, identify data inconsistencies, missing data and resolve as needed
  • Standardize data naming, data definitions and modeling
  • Perform data extraction, storage, manipulation, processing, and analysis
  • Collect, profile, collate, and map appropriate data for usage in new or existing solutions as well as for ongoing data analysis activities
  • Interpret Customers functional and information needs and turn them into functional or data requirements, process models, etc.

Desired Skills and Experience
  • Bachelor’s Degree or equivalent in Computer Science, Information Systems, Engineering, Business, Mathematics, or other related scientific or technical discipline with two (2) or more years of experience related to this position
  • 1-5 years of demonstrated experience in data analysis, data manipulation, and decision support
  • Knowledge and application of relational database concepts
  • Experience or exposure to Extract/Transform/Load (ETL) and/or Business Intelligence
  • Strong SQL skills
  • Skilled at completing technical design via iterative mockups
  • High proficiency in MS Office Suite (esp. Word and Excel)
  • Openness to learning new skills and software as necessary
  • Demonstrated ability to manage simultaneous work flows while maintaining quality output and meeting deadlines
  • Demonstrated ability to learn new and exciting technologies with little assistance
Preferred Experience
  • Experience with ETL tools and procedures (any tool)
  • Prior experience working in the Cloud
  • Strong verbal and written communication skills with demonstrated ability to communicate at different levels of the organization
  • Ability to perform ad-hoc analysis and maintain clear and comprehensive documentation of decision-making, data preparation, and processes
Critical Skills
  • High aptitude in analytical and logical thinking
  • Demonstrated experience with data models and data mapping
  • Experience with Unified Modeling Language (UML), including Entity-Relationship Diagrams (ERD), Sequence Diagrams, and Data Flow Diagrams (DFD)
  • Understanding of XML, SQL, Data Modeling Language (DML), and Data Definition Language (DDL)
  • Strong communication skills, both written and spoken
  • Demonstrated ability to produce highly detailed, comprehensive documentation artifacts
  • Client-focused attitude
  • High-level knowledge of enterprise IT organizational, business, and technical environments
  • Ability to analyze processes and recommend improvements as needed
Preferred Qualifications
  • Advanced Excel skills (Macro, Pivot Tables, VLookups)
  • Experience using Salesforce data tools (Data Loader, DemandTools, Eclipse IDE)
  • Experience with, Dun & Bradstreet,, Unomy, and other data providers
  • Excellent working knowledge of
  • Certified Administrator (ADM-201), Advanced Administrator (ADM-211 or ADM-301) or equivalent experience
  • Experience working with large-scale, complex datasets
  • Track record for being detail-oriented with a demonstrated ability to self-motivate and follow-through on projects
  • Highly organized, have multi-tasking skills, and efficient in ambiguous situations
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 primarily 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. As of September 30, 2017, we had over $1 trillion (US$806 billion) in assets under management and administration, and in the previous 12 months we made $27.1 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.
Information Technology
Apply Now >>    
Link for schema


Any personal information you provide through this site will be privy only to Manulife for the purpose of evaluating your qualifications and experience. At all times, your personal information will be protected by the application of our Privacy Policy.