Data Engineer Lead

Overview

Design, implement, and optimize enterprise-grade data warehouse systems with a focus on Kimball dimensional modeling to support analytical and operational requirements.

Build business-friendly dimensional models (facts, dimensions, star schemas, snowflake schemas) to enable efficient reporting, self-service analytics, and scalable growth.

Lead the development, monitoring, and optimization of ETL / ELT pipelines, ensuring high-quality, accurate, and timely data ingestion.

Write, refine, and optimize SQL queries for performance and reliability across high-volume datasets.

Partner with Data Analysts, Data Scientists, and Business stakeholders to translate business needs into robust data solutions while ensuring data consistency, security, and governance.

Establish and maintain best practices, documentation, and standards for data modeling, pipelines, and workflows.

Guide and mentor junior engineers, fostering a culture of technical excellence and continuous learning within the team.

Responsibilities

• Design, implement, and optimize enterprise-grade data warehouse systems with a focus on Kimball dimensional modeling to support analytical and operational requirements.
• Build business-friendly dimensional models (facts, dimensions, star schemas, snowflake schemas) to enable efficient reporting, self-service analytics, and scalable growth.
• Lead the development, monitoring, and optimization of ETL / ELT pipelines, ensuring high-quality, accurate, and timely data ingestion.
• Write, refine, and optimize SQL queries for performance and reliability across high-volume datasets.
• Partner with Data Analysts, Data Scientists, and Business stakeholders to translate business needs into robust data solutions while ensuring data consistency, security, and governance.
• Establish and maintain best practices, documentation, and standards for data modeling, pipelines, and workflows.
• Guide and mentor junior engineers, fostering a culture of technical excellence and continuous learning within the team.

Requirements

Fungsi pekerjaan Teknologi Informasi

#J-18808-Ljbffr