Data Engineer (Klo Job No 140)

Job description

About the Role

We are looking for a highly skilled Data Engineer with deep expertise in Python programming and PostgreSQL database development. The ideal candidate will design, build, and optimize scalable data pipelines and work closely with analytics, engineering, and product teams to ensure reliable data availability across the organization.

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Python.
• Build and optimize PostgreSQL schemas, functions, indexes, stored procedures, and highperformance queries.
• Integrate data from multiple sources including APIs, internal systems, and external data platforms.
• Ensure data integrity, reliability, and quality across the pipeline lifecycle.
• Implement data validation, error handling, and monitoring frameworks.
• Work with crossfunctional teams (Data Science, BI, Engineering) to understand data requirements and deliver scalable solutions.
• Automate recurring data workflows and improve pipeline efficiency.
• Participate in performance tuning, database optimization, and capacity planning.
• Maintain clear technical documentation for data flows, models, and processes.

Required Skills & Qualifications

• 3+ years of experience in Data Engineering or related roles.
• Strong proficiency in Python (Pandas, NumPy, PySpark optional).
• Handson experience in PostgreSQL including:
  • advanced SQL
  • window functions
  • query optimization
  • indexing strategies
  • database design
• Experience building and maintaining ETL/ELT workflows.
• Understanding of data modeling concepts (Star schema, Snowflake, normalization).
• Familiarity with version control (Git) and CI/CD frameworks.
• Experience with cloud platforms (AWS / Azure / GCP) is a plus.
• Knowledge of Docker, Airflow, or similar workflow orchestration tools is an advantage.

Preferred Skills (Good to Have)

• Experience with data warehouses (Redshift, BigQuery, Snowflake).
• Exposure to API integrations (REST, GraphQL).
• Basic knowledge of ML pipelines is a plus.
• Familiarity with Unix/Linux environments.

Soft Skills

• Strong problemsolving and analytical mindset.
• Excellent communication skills and ability to collaborate with crossfunctional teams.
• Ability to work in a fastpaced and agile environment.Role & responsibilities