Junior Data Engineer

About StickEarn

StickEarn is an advertising technology company on a mission to transform Out-of-Home (OOH) advertising through technology, data, and creativity. We empower brands, agencies, and media owners to create impactful advertising experiences across Indonesia.

We are looking for a Data Engineer who will play a critical role in building and maintaining scalable, reliable data infrastructure that powers audience measurement, inventory optimization, and campaign performance analytics across our OOH advertising platform.

🌟 What You’ll Do

• Design & Build Data Pipelines: Design, develop, and maintain scalable batch and streaming data pipelines to support media planning, targeting, and campaign analytics.
• Data Warehousing & Modeling: Build and manage data models in cloud data warehouses to ensure high-quality, analytics-ready data.
• Data Reliability & Quality: Implement data quality checks, monitoring, and governance to ensure data accuracy, consistency, and reliability across systems.
• Platform & Infrastructure: Work closely with cloud infrastructure to manage data storage, processing, and performance optimization.
• Collaboration: Partner with Product, BI, Data Science, Campaign, and Engineering teams to translate business requirements into robust data solutions.
• Optimization & Troubleshooting: Analyze pipeline performance, debug data issues, and continuously improve system efficiency, scalability, and cost effectiveness.

• Bachelor’s degree in IT, Computer Science, or other relevant majors.
• Strong understanding of data warehousing concepts (fact & dimension tables, star schema) and ETL/ELT architectures.
• Advanced SQL skills (CTEs, window functions, query optimization)
• Experience using Python for data processing and automation.
• Hands-on experience with Apache Airflow for workflow orchestration
• Familiarity with cloud data platforms, particularly Google Cloud Platform (BigQuery, Pub/Sub, etc.).
• Experience designing batch and streaming data pipelines.
• Knowledge of API integration, data ingestion, Linux, and basic shell scripting.
• Exposure to modern data tooling such as ClickHouse, Kafka, dbt, Docker, and CI/CD practices
• Interest or experience in advanced data use cases, including LLM integration (RAG pipelines, vector databases, embeddings), building data APIs, and using BI tools like Metabase, Looker, or Tableau
• Strong analytical thinking, debugging, and problem-solving skills.
• Professional working proficiency in English (written & spoken).

• Flexibility with our hybrid working setup
• Private insurance to keep you covered
• Training budget & laptop ownership program to boost your productivity & growth
• Competitive compensation package with performance bonus.
• Flexible & anniversary leaves to support work-life balance and celebrate milestones

• Only shortlisted candidates will be contacted.