Salesforce Data Analyst

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 see 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