Solution Analyst - ICC Data Integration

Apply now »

Date: 07-Jun-2019

Location: Hong Kong Special Administrative Region of China 

Department: Information Technology - Business Intelligence Competency Centre

Report To: Solution Lead/ Senior Soulution Lead

To ensure requirements are mapped and documented to functional and technical specifications for software development of complex and cross-departmental / cross domains projects / programmes through working with various internal and external stakeholders and leveraging external and internal resources to deliver quality and working software application(s) that is aligned with business vision and goal in the delivered software application.


Key Responsibilities

  • Lead assigned projects in technical aspect and participate detailed design data modelling of Integrated Operational Datahub and/or Customer Information datawarehouse, Extract/Transform/Load (ETL) data integration and Business Intelligence (BI) reporting and presentation; as well as assist in data discovery and metadata management
  • Critically evaluate and analyze requirements gathered from multiple sources, reconcile conflicts and leverage project team members to deliver functional and technical specifications including technical constraints, assumptions and risks associated with requirements.
  • Develop solution components using combination of Oracle DBMS, Oracle PL/SQL, Informatica; as well as Qlik, Cognos and other relevant technologies
  • Work as part of project teams to deliver solution and potentially support all aspects of the delivery including analysis, testing and demonstration.
  • Ensure provided functional and technical specifications are managed, accessed and archived across the enterprise aligned within quality, availability, compliance and security requirements
  • Manage vendors and QA their deliverables and all solution components. Ensure the solution meets business requirements and complies with all relevant Cathay Pacific standards
  • Ensure compliance and support existing and future Software Development Methodologies
  • Support the implementation of the solution
  • Carry out level 2 and level 3 incident supports for in-production systems and manage end user expectations.
  • Work closely and collaboratively with internal stakeholders.
  • Collaborate with other IT domains to drive innovation
  • Keep abreast of the latest trends in software development technology and practice
  • Keep abreast of business domain’s strategy, business plan and latest industrial trends.
  • Provide mentoring to system analysts and promote knowledge sharing on analysis practices


  • 6 years of IT experience with at least 3 years hands-on implementation experience in data integration solution (candidate with less years of experience will be considered for junior position with training provided)
  • Bachelor degree (or equivalent education qualifications) in Computer Science, Computer Engineering, or related disciplines
  • Knowledge and experience in SDLC and development methodologies
  • Strong knowledge in application development methodologies, data integration analysis and design, database concepts and competence in SQL (prefereably Oracle PL/SQL)
  • Experience with tools and technologies (data modelling, data integration/ETL, reporting, metadata management, data quality management, data mining, corporate performance management etc.), particularly by using INFORMATICA tools and technologies, Data Quality management and Managed Files Transfer
  • Strong understanding of data model and database structure to be able to perform data discovery from existing production systems
  • Knowledge on metadata management tool and data governance is preferred
  • Knowledge on analytics tools such as Qlik suite and/or Cognos is preferred
  • Ability and experience to work well with others, including onshore/off-shore/near-shore teams
  • Ability to listen and articulate ideas verbally and in written formats to a broad range of audiences; ability to ask probing questions and deliver presentations
  • Well-developed analytical, problem-solving, decision-making, and leadership skills, leveraging both logic and creativity; strong troubleshooting skills; ability to identify patterns and generate ideas
  • Focus on the end user’s or customer’s needs; ability to set expectations and understand end user behaviour
  • Ability and willingness to proactively accept and drive change to accomplish positive outcomes
  • Ability to understand strategy and align tactical and strategic work in a well-balanced way
  • Good understanding of applicable technology concepts, trends and capabilities
  • Good business domain and industry knowledge

Application deadline: 26 July 2019

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.


Job Segment: Database, Engineer, Oracle, SQL, Application Developer, Technology, Engineering

Apply now »