Job ref no.: 36817299
PCCW Solutions Ltd

System Analyst / Analyst Programmer - Data Warehouse, Business Intelligence

PCCW Solutions Ltd


The successful candidate will participate in a Digital Transformation Project for the largest telecommunications company in Hong Kong – by transforming the legacy systems through the latest digital solution on agile architecture to support the next generation of CRM & Billing systems.  The new CRM & Billing Systems will provide the first class Customer Experience via innovative functions and features.


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 advantages
  • 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
  • Hands-on experience covering a combination in some of the following areas:
    • Performance and Commission System
    • Billing and Settlement System
    • Machine Learning
    • ETL Tools, Informatica
    • Data Modeling Tools
    • Reporting and Data Visualization Tools
    • Java, J2EE, JavaScript, XML, JSON, ASP.Net
    • Python, ActiveMQ, Apache Kafka, Elastic Search (ES)
    • Teradata, Oracle, PostgreSQL, MySQL, SQL Server, PL/SQL
    • Shell Script, SAS
  • Candidates with less qualification and experience will be considered as Analyst Programmer or Programmer

Interested candidates are encouraged to submit application via Apply Now.
For more information on other career opportunities and latest news at PCCW Solutions, please visit: Career opportunities or LinkedIn Career Page

PCCW is an equal opportunity employer and welcomes applications from all qualified candidates. Information provided will be treated in strict confidence and will only be used for recruitment-related purposes. Personal data provided by job applicants will be used strictly in accordance with the employer's personal data policies. A copy of which will be provided immediately upon request.

Privacy Policy Statement

More job information
Job ref no. 36817299
Job Function
  • Tai Kok Tsui
Employment Term
  • Full-time
  • 5 years - 7 years
Career Level
  • Middle management level
  • Degree
Require to Travel
  • No travel
  • 5-day week
  • Compassionate leave
  • Competitive pay
  • Discretionary bonus
  • Examination leave
  • Family medical plan
  • Insurance plan
  • Marriage leave
  • Medical plan
  • … + 4 more