Data Engineer - Advanced Analytics
Manulife
PH-Quezon
8d ago

Description

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.

Description The Data Engineer for Advanced Analytics is primarily responsible for assisting in the Extract, Transform and Load script development to support all data management, reporting solutions and data preparation to support advanced analytics projects.

Working knowledge of SQL, SSIS / SSDT, and VBA in Excel are key skills for this role. Responsibilities

  • Support data management tasks, including extracting, transforming and loading data from various systems into a SQL Server and / or an MS Access database
  • Develop automated and repeatable processes for extracting requested information from database systems and / or building new automated and ad hoc reports
  • Explore and discover new data sources, and transform raw data extract through profiling, cleaning, mapping and validation with expert resources
  • Present and visualize the data with the relevant use of graphs and charts in business intelligence clients (e.g. Tableau)
  • Document any changes in data systems, flow, relationships, and dependencies
  • Assess data quality, identify gaps in the data and eliminate irrelevant data
  • Maintain current database processes to ensure data and reporting consistency, accuracy, and integrity
  • Support ad-hoc requests for data analysis, summary statistics, and data mining as required by stakeholders
  • Qualifications

  • Bachelor’s degree in Statistics, Mathematics, Engineering, Operations Research, Computer Science, Information Technology or related fields.
  • Proficiency in SQL, MS Access, VBA and MS Excel required
  • Working experience on SSIS / SSDT and SQL Server required
  • Experience and familiarity with relational databases, data warehouse and datamarts
  • Expertise in data extraction, manipulation, and reporting
  • Knowledge of business intelligence tools such as Tableau preferred
  • Knowledge of data mining and advanced analytics techniques for predictive modeling preferred
  • Strong communication skills
  • Strong organization and project management skills
  • Excellent customer focus and a commitment to quality while still meeting deadlines
  • Ability to effectively communicate ideas and recommendations orally and in writing, while considering the viewpoint of others
  • 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.

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form