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.


