Full Stack Data Engineer

About Us
At Kolayo, we're dedicated to building innovative, data-driven solutions that empower businesses and organisations to make smarter, faster decisions. We specialise in developing cutting-edge technologies, and having recently secured funding to accelerate growth, we are looking for a highly skilled Full Stack Database Developer with expertise in SQL, Python, and React to help us deliver exceptional, data-centric applications. Join us in making an impact while growing your career in a fast-paced and collaborative environment.

Role Overview
We are looking for a Full Stack Database Developer who has a strong foundation in developing scalable and efficient database systems and web applications. In this role, you'll work on both the backend and front-end of our applications, focusing on database architecture, integration, and data processing, while also ensuring seamless user experiences via a dynamic React interface.

As part of our growing team, you'll have the opportunity to work on complex data-driven projects, building solutions that involve SQL database management, Python scripting, and modern web technologies, collaborating closely with both co-founders.

Key Responsibilities

1. Design, develop, and maintain efficient, scalable databases (SQL), ensuring data integrity and performance optimization.
2. Build and maintain full-stack web applications, including both front-end (React) and back-end (Python) components.
3. Write and optimize SQL queries for data retrieval, reporting, and transformation.
4. Develop robust Python scripts and services to handle data processing, ETL tasks, and database interactions.
5. Collaborate with co-founders to define database schema and data pipelines, ensuring seamless integration with the application.
6. Implement data security and performance best practices to ensure the integrity and speed of both the application and databases.
7. Create RESTful APIs and ensure smooth communication between the database and front-end.

Requirements

Required Skills & Experience

1. Experience as a Full Stack Developer with a focus on databases (SQL), back-end (Python), and front-end (React).
2. Extensive experience with SQL databases (PostgreSQL, MySQL, or similar), including query optimization, schema design, and data modeling.
3. Proficiency with Python for backend services, data processing, and integration tasks.
4. Proficiency of React.js and JavaScript for building responsive, user-friendly interfaces.
5. Experience building and consuming RESTful APIs to connect front-end and back-end components.
6. Strong understanding of database architecture, indexing, and query performance optimization.
7. Ability to work with large datasets, complex queries, and ensure data consistency across the system.
8. Familiarity with version control systems, particularly Git.
9. Strong analytical and troubleshooting skills, with the ability to resolve complex data-related issues.

Nice to Have

1. Familiarity with cloud platforms (AWS, GCP, Azure) and cloud-based database services (Snowflake).
2. Knowledge of data warehousing and data pipeline technologies (ETL, Apache Kafka, etc.).
3. Experience with DBT for orchestration.

Benefits

Fast paced, entrepreneurial work environment

£35k - £50k annual salary depending on experience