Company Logo

Data Warehouse Engineer

Loker ini dikelola oleh

PF
PT FAN Integrasi Teknologi Fanintek

Persyaratan

Kerja di lokasi
3 - 5 tahun pengalaman
Minimal Sarjana (S1)

Skills

Tableau

My SQL

Data Modeling

ETL

Power BI

Data Modeling Concepts

Data Warehouse

Data Architecture

Apache Airflow

Benefit Kerja

Team-building events

Health Insurance

THR

Career Path

Deskripsi pekerjaan Data Warehouse Engineer PT Fan Integrasi Teknologi

Job Responsibilities:

  • Design, develop, and maintain Data Warehouse architecture.
  • Develop and manage ETL/ELT processes and data pipelines.
  • Perform data extraction, transformation, and loading from multiple data sources.
  • Design and implement data modeling, including Star Schema and Snowflake Schema.
  • Develop and optimize SQL queries, stored procedures, and database performance.
  • Ensure data accuracy, consistency, integrity, and quality.
  • Perform data integration from various databases, applications, and APIs.
  • Monitor, troubleshoot, and maintain ETL processes and data pipelines.
  • Collaborate with Data Analyst, Business Analyst, and IT teams to support business requirements.
  • Prepare technical documentation related to data architecture and data integration.

Requirements:

  • Minimum Bachelor's Degree (S1) in Computer Science, Information Technology, Information Systems, or related fields.
  • Minimum 3 years of experience in Data Warehouse, Data Engineering, or Database Development.
  • Strong knowledge of Advanced SQL and database management.
  • Hands-on experience in Data Warehouse development and implementation.
  • Familiar with ETL/ELT tools such as Apache Airflow, SSIS, Informatica, or similar tools.
  • Proficient in Python for data processing and automation.
  • Understand data modeling concepts, including Star Schema, Snowflake Schema, Fact and Dimension Tables.
  • Familiar with database platforms such as PostgreSQL, MySQL, SQL Server, or Oracle.
  • Experience with Cloud Platforms (AWS, Azure, or Google Cloud) is an advantage.
  • Familiar with BI tools such as Power BI or Tableau is a plus.
  • Strong analytical thinking, problem-solving, and communication skills.
  • Able to work independently and collaboratively within a team.

Proses Wawancara

Tentang Perusahaan
PT Fan Integrasi Teknologi
Management Consulting
51 - 200 karyawan

PT FAN Integrasi Teknologi berdiri atas dasar pengalaman dan perkembangan Teknologi Informasi. Bertujuan untuk memenuhi permintaan IT yang tidak dapat diberikan oleh perusahaan lain. Memiliki tiga bidang yang di naungi yaitu Aplikasi, Infrastruktur dan Manage Services.

Galeri Perusahaan

Tips Aman Cari Kerja

Pemberi kerja yang benar tidak akan meminta akun Telegram, top-ups atau pembayaran dalam bentuk apapun. Jangan berikan kontak pribadi, informasi bank, maupun kartu kredit kamu.

Pelajari Selengkapnya

Data Warehouse Engineer