Skip to content

ETL and Business Data Analyst (IT)

Job Category:

Information Tech

Job Level:

Professional

Open Date:

21-Jul-2021

Location:

QUEZON CITY

Close date:

20-Aug-2021

Client Overview:

 Leading insurance and wealth and asset management group with global headquarters in Canada, operating regionally in Asia and the United States with 35,000 employees across the globe. It’s global shared service centre in Quezon City and Lapu – Lapu City provides administrative, finance, investments, analytics, professional services, support, contact centre and information technology services to companies around the world and puts the customers at the forefront.

The company aims to attract, develop and retain a diverse workforce and to foster an inclusive work environment that embraces the strength of cultures and individuals.

Client Industry:

SHARED SERVICES

Job Description and Qualification:

Responsibilities:

  • Responsible in documentation of the Business Data needs.
  • Transformation requirements from Staging to the Final Reporting Table(s)
  • Data required from IDDL to be loaded into SQL staging tables
  • Writing complex SQL queries to analyze data and provide results to business users or project team members
  • Create detailed technical documentation for data integration (ETL) programs and other deliverables.
  • Responsible in Data Profiling and Data Analysis

Qualifications:

·       Candidate must possess at least a Bachelor’s/College degree

·       4 to 5 years’ relevant experience.

  • Must have experience writing complex SQL queries to analyze data and provide results to business users or project team members
  • Broad knowledge in data warehousing, including data mapping and transformations, data dependencies, data source analysis and profiling.
  • Willing to work in a night shift schedule and work from home setup temporarily.

Salary:

0.00