Data Engineer

Technology

Jakarta

About the job

The purpose of this role is to maintain, improve, clean and manipulate data in the business’s operational and analytics databases. The Data Engineer works with the business’s software engineers, data analytics teams, data scientists and data warehouse engineers in order to understand and aid in the implementation of database requirements, analyse performance, and troubleshoot any existent issues. We have a bunch of clients that their data sit on BigQuery as the core data warehouse from various datasets via streaming or batching, from online to offline data from on-prem. Your daily workloads are related to making the ‘fast dashboard’ in data visualization of the choice (Data Studio, PowerBI, or Tableau). You speak complex SQL a lot with a great sense of query performance in your toolbox. You care about lowest latency data query to provide granular access to large datasets in BigQuery.

About the Role
We are looking for a Data Engineer to join our diverse and inclusive team, responsible for maintaining, improving, cleaning, and manipulating data across the business’s operational and analytics databases. In this role, you’ll collaborate with software engineers, data analytics teams, data scientists, and data warehouse engineers to implement database requirements, improve performance, and troubleshoot any issues. You’ll work primarily with BigQuery as the core data warehouse, handling large datasets across online and offline sources. Additionally, you will be creating ‘fast dashboards’ for data visualization using tools like Data Studio, Power BI, or Tableau, while ensuring the lowest latency in data queries.

Key Responsibilities

  • Data Pipeline Creation & Maintenance: Develop and maintain efficient, scalable data pipelines to process large and complex datasets to meet business needs.
  • Database Optimization: Focus on query performance optimization and ensure timely data delivery through low-latency queries for large datasets in BigQuery.
  • Process Improvements: Identify, design, and implement internal process improvements, including automating manual processes and optimizing data delivery.
  • Analytics Tool Development: Build analytics tools that leverage data pipelines to provide actionable insights into key business performance metrics such as customer acquisition and operational efficiency.
  • Collaboration with Teams: Work closely with stakeholders across the Executive, Product, Data, and Design teams to assist with data-related technical issues and support their data infrastructure needs.
  • Data Security: Ensure data is kept separate and secure, with a strong understanding of data governance, lineage, and security practices in the cloud environment.
  • Data Visualization: Create fast, dynamic dashboards using tools like Data Studio, Power BI, or Tableau to help business teams make data-driven decisions.
  • Cross-functional Collaboration: Support and collaborate with the analytics and data science teams to help optimize products and solutions using data insights.

A bit about you

  • Bachelor’s degree in Computer Science, a related technical field, or practical experience in a data engineering role.
  • At least of 2 years of experience in data engineering, data management, and working with large datasets.
  • Technical Expertise:
    • Strong experience with Marketing Technology Platforms and Data Analytics.
    • Proficient in building and optimizing SQL-based query processing engines.
    • Experience with OLTP/OLAP systems, data lakes, data warehouses, and data marts.
    • Familiarity with query performance, data processing engines, and systems.
    • Knowledge in designing high-availability data architectures and scalable systems.
  • Understanding of data security, governance, and lineage, particularly in cloud environments.
  • A collaborative mindset and the ability to work hands-on with cross-functional teams to provide solutions.
  • Proactive in identifying query performance issues and resolving challenges in complex, large datasets.

Dentsu Values

Will live the dentsu 8 Ways at all times: We Dream Loud, We Inspire Change, We Team Without Limits, We All Lead, We Make It Real, We Climb High, We Choose Excitement, We Are A Force For Good

Inclusion and Diversity


We’re proud to be different and that starts with our people. We believe in equal opportunities for everyone. We won’t define people by their race, gender, sexual-orientation, age or disability. Individuality is what makes us great, we want everyone to bring their full self to work and create something amazing. That’s what we care about.

So, whether you’re joining us, or looking to move to a different part of the business, we work hard to make sure we create equal opportunities for everyone.

Keeping connected

Please visit our website to find out more and connect with us on social.

www.dentsu.com
 

*Please include an updated CV in your application.

**We regret that only short-listed candidates will be notified.

#LI-LE1 
#LI-HYBRID

Beware of Job Scams

We are aware of several scams targeting job seekers and candidates. Please be vigilant. All communication throughout the recruitment process will be from an official member of the dentsu recruitment team, using corporate email addresses (e.g., @dentsu.com or @merkle.com). We will never ask you to send money or vouchers to secure employment. If you suspect you have been a victim of a scam, please report the incident to your bank, local police, or fraud protection authority immediately. Additionally, you can report the scam to us at jobfraud@dentsu.com so we can take appropriate action to request the website is taken down. Please note that Merkle and dentsu are not responsible for any losses incurred as a result of these scams. We advise all individuals to exercise caution and verify the authenticity of any job offers or communications received.