Data Warehouse Analyst

Data Warehouse Analyst

PCCW Solutions Philippines Inc
5-8 years
Not Specified

Job Description

Job Duties:

He / She will be responsible for application development and ongoing maintenance support of the Data Analytics area with the following scope of duties:
Perform user requirement collection, data engineering, systems development, set up and documentation
Lead the analyst programmers/programmers by providing guidelines and assistance to enable solution development and implementation, with passion to be hands-on with coding
Implement software components according to the specifications and guidelines
Develop unit test cases, perform comprehensive unit testing & record the results
Support user acceptance testing and system implementation
Prepare system and operations documents
Provide ongoing user and application support

The Person:

University graduate in Computer Science, Information Technology or Data Science related disciplines
5+ years working / project experience participating in Data Management, Data Warehouse and Data Lake Management, EDM, Extract-Transform-Load (ETL), Business Intelligence or Data Analysis related duties
Solid hand's on building ETL process, reporting, and building dashboard
Skilled in SQL, python and other related scripting and programming language
Good knowledge in Informatica, SQL, Data analysis, Relational Database Management System and NOSQL System
Also possess relevant experience in Big data, API development and Cloud technologies are added advantage
Must have Skills: ·
  • ETL Tools, Informatica
  • Data Modeling Tools
  • Reporting and Data Visualization Tools
  • Apache Kafka, JSON
  • Teradata, Oracle, PostgreSQL, MySQL, SQL Server, PL/SQL

Nice to have skills:
  • Performance and Commission System
  • Billing and Settlement System
  • Machine Learning
  • Python, ActiveMQ, Elastic Search (ES)
  • Java, J2EE, JavaScript, XML, ASP.Net
  • Shell Script, SAS

Able to work under pressure
Effective verbal and written communication in English and Chinese
Good team player with strong interpersonal and communication skills
Positive attitude, fast-learning, energetic, able to perform in challenging environment
Candidates with less qualification and experience will be considered as Programmer

PCCW Solutions, the IT flagship of PCCW Group, is a leading IT services company, a digital transformation and outsourcing partner of choice for clients in all industries across the Pan-Asia region. We adopt cutting-edge technologies to empower clients transform digitally, create business values and success in the ever-changing economic environment.

With our global data center coverage and innovative Infinitum solutions suite, including Cloud, Advanced Analytics, AI, Digital and IoT solutions, we have digitally transformed businesses across many industries, revolutionizing the way they operate, and transforming customer experiences along the way.

About Recruiter




Active jobs

Functions : IT/Software Development - System Programming, IT/Software Development - System Programming/Middleware

Industries : IT/Computers - Software

Skills/Roles I hire for: Programming

level Hiring For: Mid Level, High Level

Similar Jobs

People Also Considered

Career Advice to Find Better