Data Engineer, Contract

Remote: 
Full Remote
Contract: 
Work from: 

Offer summary

Qualifications:

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., Proficiency in Python programming for data transformation and pipeline development..

Key responsabilities:

  • Manage ELT processes using Stitch, including configuration, monitoring, and troubleshooting.
  • Maintain and update AWS Data Migration Service tasks for data replication from PostgreSQL to Redshift.
  • Design, implement, and optimize data models within our Redshift data warehouse.
  • Collaborate with the engineering team to ensure data quality and accessibility.

Kojo logo
Kojo Scaleup www.usekojo.com
51 - 200 Employees
See all jobs

Job description

About Kojo

It's time to build. Whether it's creating more housing, upgrading our infrastructure, or adapting to climate change, one thing is clear: the construction industry is at the center of solving our biggest problems. We’re making buildings cheaper and easier to build by transforming the way commercial construction companies buy their materials. Join us.

Founded in 2018, Kojo is now one of the fastest-growing construction technology companies in the world. Construction accounts for $10 trillion in global spend annually and we can’t live without its output - our roads, schools, hospitals, and offices. Despite this, there’s been very little innovation over the past 70 years in how materials - which constitute up to 40% of project costs - are bought and sold. This is our opportunity.

We’re looking for a talented Data Engineer to join our team on a 6-month remote contract based in India. In this role, you’ll play a critical part in designing, maintaining, and optimizing our data pipeline architecture. You’ll implement best practices for data warehouse design and ensure our ETL processes run efficiently and reliably as we scale.

Key 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

Required Skills & Experience

  • 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

Working at Kojo

Salary: Your salary will be dependent upon many factors, including your experience level, skillset, market dynamics and balancing internal equity relative to other Kojo employees. The compensation and benefits information that we provide is based on Kojo’s good-faith estimate as of the date of the job posting and may be modified in the future.

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. For more information about our perks and benefits, check out https://www.usekojo.com/careers.

Location: 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.

Inclusive Workplace: Kojo values diverse perspectives and is committed to building an inclusive workplace. We are proud to be an equal opportunity workplace and do not discriminate on the basis of sex, race, color, age, sexual orientation, gender identity, religion, national origin, citizenship, marital status, veteran status, or disability status. Pursuant to the San Francisco Fair Chance Ordinance, we consider for employment qualified applicants with arrest and conviction records. We strongly encourage people from underrepresented groups to apply.



Scam Notice: Please be aware that there are individuals and organizations that may attempt to scam job seekers by offering fraudulent employment opportunities in the name of Kojo. These scams may involve fake job postings, unsolicited emails, or messages claiming to be from our recruiters or hiring managers. Kojo will never ask for any personal account information, such credit card details or bank account numbers, during the recruitment process.

Required profile

Experience

Industry :
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Data Engineer Related jobs