main content

Data Architecture

Senior Data Engineer

Jakarta

Job Description

  • Create and maintain optimal data pipeline architecture
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure to greater scalability, etc.
  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and cloud based data processing technologies.
  • Work with stakeholders including Business User, BI Development team, and Analytics team to assist with data-related technical issues and support their data infrastructure needs. 

Qualification

  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. 
  • Experience building and optimizing data pipelines (ETL/ELT), architectures and data sets.
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
  • Build processes supporting data transformation, data structures, metadata, dependency and workload management.
  • They should also have experience using the following software/tools:
  1. Must have experience in operating RDBMS and working with relational SQL (Postgres/Oracle/MS SQL/MySQL)
  2. Must have experience in operating Data Warehouse-scale RDBMS (Terradata/Netezza/Exadata)
  3. Must have experience in working with ETL tools such as Pentaho/Talend/DataStage/Ab-initio
  4. Must have experience in working with BI tools such as Cognos/BusinessObjects/Tableau/Microstrategy
  5. Must have experience in operating linux based system (Ubuntu/Red Hat/CentOS)
  6. Preferably have experience in working with NoSQL databases, including Postgres and Cassandra.
  7. Preferably have experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc.
  8. Preferably have experience with cloud services such as AWS, Google Cloud Platform, Microsoft Azure.
  9. Preferably have experience with stream-processing systems: Storm, Spark-Streaming, etc.
  10. Preferably experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc 

 

Min. Experience: 3 years