Data Engineer

Key Responsibilities:

• Design , build and manage data warehouse / data lake.

• Design, build, and maintain data pipelines from multiple companies/business units into a centralized data warehouse.

• Develop and manage ETL/ELT processes to ensure data is accurate, clean, and available for reporting.

• Build and maintain data warehouse, data marts, and structured datasets for business intelligence needs.

• Integrate data from various sources such as accounting systems, internal systems, databases, APIs, Excel, and Google Sheets.

• Perform data cleaning, transformation, validation, and standardization across business units.

• Monitor pipeline performance, data freshness, data quality, and system reliability.

• Collaborate with BI Engineer and business stakeholders to prepare data for dashboards and management reports.

• Implement data security, access control, backup, and documentation for data architecture and pipelines.

• Troubleshoot data issues and ensure consistency between source systems and the data warehouse.

Qualifications:

• Bachelor’s degree (S1) in Computer Science, Information Systems, Data Engineering, Statistics, Mathematics, Engineering, or related fields.

• Minimum 2 years of experience as Data Engineer, ETL Developer, Database Engineer, or similar role.

• Strong proficiency in SQL and relational databases such as PostgreSQL, MySQL, SQL Server, BigQuery, Snowflake, or Redshift.

• Experience in ETL/ELT processes, data warehouse design, and data modeling.

• Proficiency in Python for data processing and automation.

• Experience with API integration, data ingestion, and workflow orchestration tools such as Airflow, Prefect, Dagster, or similar.

• Familiarity with cloud platforms.

• Strong understanding of data quality, data governance, and database performance optimization.

• Strong analytical thinking, problem-solving skills, and attention to detail.

• Able to work with cross-functional teams and understand business data needs.