Data Engineer - Zurich Asuransi Indonesia

Zurich Insurance; Jakarta Timur; Hybrid; IDR 700,280,112 - 1,050,420,168; Full time

Job summary

Zurich Insurance is looking for a Data Engineer to transform raw data into usable formats for analysis. This role emphasizes designing ETL pipelines using Spark SQL and Python within Databricks while optimizing engineering workflows for performance.

The ideal candidate should have over 5 years of experience with SparkSQL and Python, alongside a strong proficiency in dimensional modeling. A hybrid working environment is offered to balance work and life.

Qualifications

• At least 5+ years’ experience with SparkSQL, Python and PySpark for data engineering workflow.
• Strong proficiency in dimensional modeling and star schema design for analytical workloads.
• Demonstrated ability to optimize engineering workflow jobs for performance and cost efficiency.

Responsibilities

• Design and implement ETL/ELT pipelines using Spark SQL and Python within Databricks Medallion architecture.
• Develop dimensional data models following star schema methodology.
• Optimize Spark SQL and DataFrame operations to maximize performance.

Skills

SparkSQL

Python

PySpark

Dimensional modeling

Automated testing

CI/CD pipelines

GitHub operations

Cloud data services

Visual Studio Code

Databricks platform

Job description

Job Summary

The data wranglers of the business world. They transform raw data into a usable format for analysis, building the infrastructure that empowers data scientists and analysts to unlock valuable insights. By identifying trends and developing strategies, they bridge the gap between data and actionable decisions, ultimately driving organizational efficiency and performance.

Job Qualifications

• At least 5+ years’ experience with SparkSQL, Python and PySpark for data engineering workflow
• Strong proficiency in dimensional modeling and star schema design for analytical workloads
• Experience implementing automated testing and CI/CD pipelines for data workflows
• Familiarity with GitHub operations and collaborative development practices
• Demonstrated ability to optimize engineering workflow jobs for performance and cost efficiency
• Experience with cloud data services and infrastructure (AWS, Azure, or GCP)
• Proficiency with IDE tools such as Visual Studio Code for efficient development
• Experience with Databricks platform will be a plus

Job Accountabilities

• Design and implement ETL/ELT pipelines using Spark SQL and Python within Databricks Medallion architecture
• Develop dimensional data models following star schema methodology with proper fact and dimension table design, SCD implementation, and optimization for analytical workloads
• Optimize Spark SQL and DataFrame operations through appropriate partitioning strategies, clustering and join optimizations to maximize performance and minimize costs
• Build comprehensive data quality frameworks with automated validation checks, statistical profiling, exception handling, and data reconciliation processes
• Establish CI/CD pipelines incorporating version control, automated testing including but not limited to unit test, integration test, smoke test, etc.
• Implement data governance standards including row-level and column-level security policies for access controls and compliance requirements
• Create and maintain technical documentation including ERDs, schema specifications, data lineage diagrams, and metadata repositories

Why Zurich

At Zurich, we like to think outside the box and challenge the status quo. We take an optimistic approach by focusing on the positives and constantly asking What can go right?

We are an equal opportunity employer who knows that each employee is unique – that’s what makes our team so great!

Join us as we constantly explore new ways to protect our customers and the planet.

Job Details

• Location(s): ID - Head Office - MT Haryono
• Remote working: Hybrid
• Schedule: Full Time
• Recruiter name: Ayu Candra Sekar Rurisa
• Closing date: