Posted on 2022-09-08
Cathay Pacific Airways Ltd

Solution Analyst - Technical Data Modeling

Cathay Pacific Airways Ltd

Reports to: Senior Solution Lead, Technical Data Modeling and Application DBA

Department: Information Technology (IMT)

Role Introduction

This role, Solution Analyst, Technical Data Modeling and Application DBA, is the analyst
that understands the IT product or applications in their area and how these can support
the business. The main focuses are to provide subject matter technical competence in
designing data model, implementing, maintaining and administrating the end-to-end
integrated data warehouse solutions.
You are responsible to develop solutions to bridge gaps and make sure the project scope is maintained, and solutions implemented in line with design.


Key Responsibilities

Business Engagement

  • Support pre-project consulting for a portfolio pipeline of initiatives
  • Capture business challenges and requirements
  • Analyze technically viable ideas to improve the business performance
  • Interact and work closely with solution provider or internal team

Technology Design and Implementation

  • Understand and translate business needs into data models supporting long-term solutions
  • Collaborate with the Application Development teams to implement data strategies, build data flows and develop conceptual data models
  • Understand and critically review physical data models
  • Develop, implement, and support IT products and applications to meet the customer and IT needs
  • Contribute best practices in continuous integration and delivery
  • Generate ideas to improve data quality
  • Streamline delivery of product/system with adherence to security policy and data governance framework

Project Delivery

  • Focus on multiple small to medium to large scale initiatives
  • Plan and execute tasks / initiatives
  • Test all solution aspects including but not limited to security, performance, integration
  • Facilitate project progress through relevant gates
  • Understand areas of risk and act on the mitigation for the projects
  • Adapt to changes as per project progress

People Development

  • Keep abreast of latest trends in technology, industry and corresponding business domain
  • The Solution Analyst also:
  • Participate in Product Vertical Teams to continuously experiment, iterate and deliver product objectives through adopting Agile development practices
  • Act as an IT practice-sioner



  • Degree qualification in Information Technology related discipline, Masters preferred
  • 6 years of related IT experience covering but not limited to:
    • Software development
    • System analysis
    • Business analysis
    • Solution definition
    • System Testing
  • At least 2 years of experience in leading the implementation of large scale data
  • warehouse with hands-on experience in BI Tools and technologies (data modelling, data integration/ETL, reporting, metadata management, data quality management, data mining, corporate performance management etc.)
  • Strong in Database concepts and competence in SQL query and optimization, preferably Oracle PL/SQL
  • Experience with dimensional modelling concepts including star schema, slowly changing dimensions etc.
  • Proven extensive client facing experience with successful relationship management Outstanding verbal and written communication skill
  • Experience managing a software development team
  • Professional, passionate, innovative, self-motivated and able to present solutions to diverse groups of stakeholders
  • Excellent analytical, problem-solving, and decision-making skills, leveraging both logic and creativity
  • Proven troubleshooting skills; ability to identify patterns and generate ideas
  • Experienced in driving technical innovation
  • Experience with utilization of outsourced and/or globally distributed resources
  • Airline or travel industry knowledge is highly beneficial
  • Solid software development skill is highly beneficial
  • Experience in working with Agile projects
  • Understanding of cloud, DevOps, APIs / Mobility would be added advantage

Personal & Application Information

Cathay Pacific is an Equal Opportunities Employer. Personal data provided by job applicants will be used strictly in accordance with our personal data policy and for recruitment purposes only. Candidates not notified within eight weeks may consider their application unsuccessful. All related information will be kept in our file for up to 24 months. A copy of our Personal Information Collection Statement will be provided upon request by contacting our Data Protection Officer.

Please note that with effect from 1 June 2022 onwards, all Cathay employees and contractors who work in Cathay City and all other Cathay Group Company premises in Hong Kong must have received a third dose of COVID 19 vaccine.  Being tested regularly for COVID-19 is not an option. Consideration will be given to those who are unable to get vaccinated for valid medical reasons.

More job information
  • 5-day week
  • Family medical plan
  • Insurance plan
  • Meal allowance
  • Medical plan
Job Function
  • Chek Lap Kok
  • Tung Chung
Employment Term
  • Permanent
  • Full-time
  • 6 years - 8 years
Career Level
  • Non-management level
  • Degree