Data Engineer

Summary

Join Kojo, a fast-growing construction technology company, as a Data Engineer for a 6-month remote contract based in India. You will play a key role in designing, maintaining, and optimizing the data pipeline architecture, implementing best practices for data warehouse design, and ensuring efficient ETL processes. This position requires expertise in data warehouse concepts, proficiency with PostgreSQL and Amazon Redshift, and experience with AWS Data Migration Service. You will work with ELT/ETL tools, Python, dbt, AWS Lambda, and Dagster. The role involves collaboration with the engineering team to maintain data quality and accessibility. Kojo offers a new hire equity grant and a full suite of perks and benefits for US-based full-time employees. The position is 100% remote, with work hours congruent to the local time zone.

Requirements

• Strong understanding of data warehouse concepts and dimensional modeling
• Proficiency with PostgreSQL and Amazon Redshift
• Experience with AWS Data Migration Service and Change Data Capture methodologies
• Hands-on experience with ELT/ETL tools, particularly Stitch
• Proficiency in Python programming for data transformation and pipeline development
• Experience with dbt for data transformations and testing
• Familiarity with workflow orchestration tools, specifically Dagster
• Knowledge of Apache Superset for data visualization
• Understanding of containerization concepts, Kubernetes, and AWS EKS
• Strong SQL skills for complex data manipulations and optimizations
• Ability to implement and maintain efficient data pipeline architectures

Responsibilities

• Manage ELT processes using Stitch, including configuration, monitoring, and troubleshooting
• Maintain and update AWS Data Migration Service (DMS) tasks for data replication from PostgreSQL to Redshift, with emphasis on Change Data Capture (CDC) implementations
• Design, implement, and optimize data models within our Redshift data warehouse following best practices
• Develop and maintain data transformation pipelines using Python, dbt, AWS Lambda, and Dagster
• Create and maintain data marts for various business domains
• Support containerized applications running on AWS EKS (Kubernetes)
• Collaborate with engineering team to ensure data quality and accessibility

Benefits

• This position is also eligible for a new hire equity grant and all US-based full time employees are eligible for our full suite of perks and benefits
• Kojo’s team members work from home 100% of the time across North and South America
• If applicable, we’ll identify the travel and/or location-specific requirements of a position in the text above
• Otherwise, team members can expect to work business hours congruent with their local time zone and remotely