Data Engineer - Data Warehouse
By Traveloka At Area DKI Jakarta, Indonesia
Create and manage data pipelines infrastructures
Understand data warehousing concept (eg: Kimball, Inmon, data vault, etc) and experience in data modeling and measure + improve data quality
Having knowledge in machine learning, building robust API, and web development will be an advantage
Define data model convention and governance
Design, develop and maintain data pipelines (external data source ingestion jobs, ETL/ELT jobs, etc)
Design, develop and maintain data pipeline framework (combined open source and internal software to build and govern data pipelines)

Are you looking for a challenging and rewarding career in Data Warehousing? We are looking for a motivated and experienced individual to join our team as a Data Warehouse Analyst. You will be responsible for designing, developing, and maintaining data warehouses and data marts to support business intelligence and analytics. You will also be responsible for developing ETL processes to ensure data accuracy and integrity. If you have a passion for data and analytics, then this is the perfect opportunity for you!

Overview Data Warehouse is a type of database used to store and analyze large amounts of data. It is used to store data from multiple sources and provide a single source of truth for business intelligence and analytics. Data Warehouse professionals are responsible for designing, developing, and maintaining data warehouses and related systems. Detailed Job Description Data Warehouse professionals are responsible for designing, developing, and maintaining data warehouses and related systems. This includes designing and developing data models, ETL processes, and data warehouse architectures. They must also ensure the accuracy and integrity of the data, as well as optimize the performance of the data warehouse. Data Warehouse professionals must also be able to work with other IT professionals to ensure the data warehouse is integrated with other systems. Data Warehouse Job Skills Required
• Knowledge of data warehouse design and architecture
• Knowledge of ETL processes and tools
• Knowledge of data modeling and data analysis
• Knowledge of SQL and database systems
• Knowledge of data security and privacy
• Ability to troubleshoot and debug data warehouse systems
• Ability to work with other IT professionals
• Excellent communication and problem-solving skills
Data Warehouse Job Qualifications
• Bachelor’s degree in Computer Science, Information Technology, or a related field
• 5+ years of experience in data warehouse design and development
• Experience with ETL processes and tools
• Experience with data modeling and data analysis
• Experience with SQL and database systems
• Experience with data security and privacy
Data Warehouse Job Knowledge
• Knowledge of data warehouse design and architecture
• Knowledge of ETL processes and tools
• Knowledge of data modeling and data analysis
• Knowledge of SQL and database systems
• Knowledge of data security and privacy
Data Warehouse Job Experience
• 5+ years of experience in data warehouse design and development
• Experience with ETL processes and tools
• Experience with data modeling and data analysis
• Experience with SQL and database systems
• Experience with data security and privacy
Data Warehouse Job Responsibilities
• Design and develop data models, ETL processes, and data warehouse architectures
• Ensure the accuracy and integrity of the data
• Optimize the performance of the data warehouse
• Integrate the data warehouse with other systems
• Troubleshoot and debug data warehouse systems
• Work with other IT professionals to ensure the data warehouse is integrated with other systems