Data Engineer

We are looking for a highly skilled Data Engineer with strong expertise in PostgreSQL and hands-on experience in building data warehouses and data lakes.

In this role, you will design and implement a scalable PostgreSQL-based data warehouse and manage a data lake on AWS infrastructure, leveraging primarily open-source technologies.

The ideal candidate has a strong foundation in SQL engineering, cloud data architectures, and modern data pipelines.

Experience with hosted data warehouse platforms such as DBT, Snowflake, or Databricks is a plus.

Key Responsibilities :

Data Engineering & Architecture :

• Design, build, and maintain a PostgreSQL-based data warehouse for scalable analytics and reporting.
• Develop and manage data pipelines (batch and streaming) for ingestion, transformation, and storage.
• Architect and maintain a data lake on AWS infrastructure (e.g., S3, Glue, Athena, Redshift Spectrum).
• Optimize queries, indexing, and schema design for performance and scalability in PostgreSQL.
• Ensure solutions align with modern open-source data engineering best practices.

Collaboration & Delivery :

Required Qualifications :

Preferred Qualifications :

(ref : hirist.tech)