Data Engineer

Job Description:

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

Location:

Jakarta

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent