Urgent Search Data Engineer, Contract

About KojoIt 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 Were 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 cant live without its output - our roads schools hospitals and offices Despite this theres 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 Were looking for a talented Data Engineer to join our team on a 6-month remote contract based in India In this role youll play a critical part in designing maintaining and optimizing our data pipeline architecture Youll 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 troubleshootingMaintain and update AWS Data Migration Service DMS tasks for data replication from PostgreSQL to Redshift with emphasis on Change Data Capture CDC implementationsDesign implement and optimize data models within our Redshift data warehouse following best practicesDevelop and maintain data transformation pipelines using Python dbt AWS Lambda and DagsterCreate and maintain data marts for various business domainsSupport containerized applications running on AWS EKS Kubernetes Collaborate with engineering team to ensure data quality and accessibilityRequired Skills ExperienceStrong understanding of data warehouse concepts and dimensional modelingProficiency with PostgreSQL and Amazon RedshiftExperience with AWS Data Migration Service and Change Data Capture methodologiesHands-on experience with ELT ETL tools particularly StitchProficiency in Python programming for data transformation and pipeline developmentExperience with dbt for data transformations and testingFamiliarity with workflow orchestration tools specifically DagsterKnowledge of Apache Superset for data visualizationUnderstanding of containerization concepts Kubernetes and AWS EKSStrong SQL skills for complex data manipulations and optimizationsAbility to implement and maintain efficient data pipeline architecturesWorking at KojoSalary 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 Kojos 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 Location Kojos team members work from home 100 of the time across North and South America If applicable well 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