Solution Lead (BICC Technical Data Model & App DBA)

Reports to: Senior Solution Lead, Technical Data Model BICC
Department: Information Technology (IMT)

Role Introduction
This role, Solution Lead – Technical DM & App DBA, is responsible for developing and governing fit-for-purpose data model designs that address the business requirements and align to the architecture design and infrastructure standards.
The key focus is to provide subject matter technical leadership in designing, implementing, maintaining and administrating databases in the data and analytics domain, including data warehouse and big data platform. You are responsible to make sure the solutions are implemented and maintained in line with the design

Key Responsibilities

Technical Design and Implementation

• Understand and translate business needs into data models supporting long-term solutions.
• Cross-team collaboration with the Application Development teams to implement data strategies, build data flows and develop conceptual data models.
• Design initial logical and physical data models using best practices
• Evaluate data models and physical databases for variances and discrepancies. Validate business data objects for accuracy and completeness.
• Design, develop, implement, and support IT products and applications to meet the customer and IT needs
• Support design walkthroughs with IT and business people
• Recommend best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Provide an escalation point for solution analysts in order to deliver business solutions that include technology implementations and/or adaptations
• Generate ideas and develop new approaches to improve overall system design and/or streamline delivery of product/system

Project Delivery

• Focus on multiple medium to large scale initiatives
• Initiate, define, plan and execute tasks / initiatives
• Test all solution aspects including but not limited to security, performance, integration
• Manage the day-to-day activities of the software development team and external 3rd parties as required
• Identify areas of risk and prepare strategies for mitigation for the projects

People Management

• Contribute to team resource planning
• Manage external 3rd parties as required
• Keep abreast of latest trends in technology, industry and corresponding business domain

Requirements

• Degree qualification in Information Technology related discipline.
• 8+ years of related IT experience covering but not limited to:
  • Database administrator
  • Software development
  • System analysis
  • Solution definition
  • System Testing
• At least 3 years of experience in leading the implementation of large scale data warehouse with hands-on experience in database technologies (data modelling, data integration/ETL (Informatica PowerCenter), reporting, metadata management, data quality management, data mining, corporate performance management etc.)
• Solid experience in database administrative tasks.
• Strong in Data Warehouse concepts and competence in SQL query and optimization, preferably Oracle PL/SQL, and/or Amazon Redshift/PostgreSQL
• Proficient knowledge in cloud based architecture and design framework.
• 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
• Passion and ability to learn new technologies.
• 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

 Application Deadline: 31 March 2023

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.