Senior/Staff Engineer, Data Warehouse

Location: Singapore, Singapore

Department: Engineering

About the team:

OKX data team is responsible for the whole data scope of OKG, from techincal selection, architecture design, data ingestion, data storage, ETL, data visualization to business intelligence and data science. We are data engineers, data analysts and data scientists. The team has end-to-end ownership of most of the data at OKx throughout the whole data lifecycle including data ingestion, data ETL, data warehouse and data services.  As a data engineer of the team, you will work with the team to leverage data technologies to empower evidence-based decision-making and improve the quality of the company's products and services.

Responsibilities:

• Design and build resilient and efficient Data Pipelines for both batch and real-time streaming data
• Design and implement Data Warehouse architectures, Data Modeling, and ETL pipeline development.
• Architect and design Data Infrastructure on cloud using industry standard tools
• Execute projects with an Agile mindset
• Build software frameworks to solve data problems at scale
• Collaborate with product managers, software engineers, data analysts and data scientists to build scalable and data-driven platforms and tools
• Ensure data integrity and scalability through enforcement of data standards. Improve data validation and monitoring processes to proactively prevent issues and quickly identify issues. Drive resolution on the issues.
• Define, understand, and test external/internal opportunities to improve our products and services.

Requirements:

• Bachelor’s Degree in Computer Science or equivalent industry experience
• Solid Experience in Data Warehousing
• Solid Experience with Data Processing tools such as Spark, Flink
• Solid Experience implementing batch and streaming data pipelines
• In-depth knowledge of both SQL and NoSQL databases, including performance tuning and troubleshooting
• Experience with Cloud technologies (e.g. AWS or AliCloud)
• Be proficient in SQL, familiar with advanced SQL features such as window functions, aggregate functions and creating scalar functions/user-defined functions.
• Proven successful and trackable experience in full end-to-end data solutions involving data ingestion, data persistence, data extraction and data analysis.
• Fluent in English, both written and spoken.

Preferred Qualifications:

• Experience in FinTech, eCommerce, SaaS, AdTech, or Digital Wallet business industries.
• Experience in working with teams across offices and timezones is a plus.
• Experience in big data tools such as Amplitude/Tableau/QlikView, AliCloud DataBricks, DataWorks, MaxCompute, Hadoop, Hive, Spark and HBase are a big plus.

Perks & Benefits:

• Competitive total compensation package
• L&D programs and Education subsidy for employees' growth and development
• Various team building programs and company events
• Wellness and meal allowances 
• Comprehensive healthcare schemes for employees and dependants 
• More that we love to tell you along the process!