Data Engineer

Job description / Role

• Production support and maintenance of data systems and processes
• Design and create data models based on various business requirement
• Create database objects such as tables, views to build data proof-of-concept projects
• Design packages related to the extraction, transformation and loading (ETL) process using Oracle PL/SQL
• Reviewing query performance and optimizing code
• Creating table indexes to improve database performance and apply appropriate index maintenance
• Responsible for data profiling as well as SQL and database tuning / optimization
• Analyze the client requirements and design technical solutions based on those requirements
• Execute testing and implementation strategy, conduct appropriate functional and performance testing to identify and resolve process bottlenecks and data quality issues
• Leverage self-service visualization tools to provide actionable insights into key business performance metrics
• Develop applications from ground up using modern Analytics and BI platforms
• Ensure code security, integrate continuously and ship code into our cloud Production environments
• Participate in development and creation of a new enterprise data warehouse
• Ability to grasp new technologies, quantitative methods and advanced analytics rapidly as needed to progress varied initiatives

Requirements

The role of the Data Engineer is to provide your passion for data prep and analysis to generate actionable insights that we will use to improve the experience for our member brands and clients. As a member of the analytics team, you will collaborate with different stakeholders, partners, vendors and product owners to design, implement and support the data architecture for advanced analytics.
To be successful in the role you will need to be intellectually curious, detail-oriented, open to new ideas, and possess a strong aptitude for visualization best practices and analytical methods.
Knowledge of scripting languages such as Python, JavaScript, shell scripts, and TensorFlow is a plus.
This is a mid-level position for engineers of 2-4 years of experience.

• Bachelor’s Degree in Computer Science (CS), Information System (IS), Management of Information System (MIS), Statistics, Analytical Finance, etc.
• 2-4 years of practical experience with SQL technologies or ETL platforms as well as creation of stored procedures
• Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, indexes, & constraints
• Excellent communication and analytical skills
• Ability to work in team environment and client interfacing skills

About the Company

Global Hotel Alliance brings together a unique collection of independent hospitality brands for GHA DISCOVERY, a multi-brand loyalty programme leveraging a shared technology platform. Through membership in GHA, hotel brands expand their global reach, drive incremental revenue by sharing customer data, and reduce dependence on third-party channels, all while maintaining management independence and individual positioning.

GHA represents a collection of 35 brands with 500 hotels in 85 countries serving more than 11 million members. The award-winning GHA DISCOVERY programme generates approximately $2 billion in revenue and over 8 million room nights annually.