Data Engineer in Aberdeen

Data Engineer in Aberdeen

Aberdeen Full-Time 40000 - 60000 £ / year (est.) Home office (partial)
Go Premium
K

At a Glance

  • Tasks: Design and develop scalable databases, optimise SQL queries, and build full-stack applications.
  • Company: Join Kolayo, a cutting-edge analytics company in a vibrant WeWork space by Tower Bridge.
  • Benefits: Competitive salary, hybrid work model, barista coffee, and after-work drinks.
  • Other info: Dynamic team environment with opportunities for professional growth and learning.
  • Why this job: Make an impact on innovative data-driven projects while collaborating with passionate co-founders.
  • Qualifications: 2+ years as a data engineer with strong SQL and Python skills.

The predicted salary is between 40000 - 60000 £ per year.

Location: Hybrid (London, Tower Hill 3 days a week)

Salary: £40k - £60k depending on experience

Employment Type: Full-time

About Us:

At Kolayo, we make advanced, plug-and-play analytics accessible to leaders in Software, Cybersecurity and IT Managed Service Providers. At the centre of our approach is the Kolayo Cube - a modular analytics model designed around the core performance drivers shared by businesses of our core sectors, while still adapting to the logic that makes yours unique. We specialise in developing cutting-edge technologies, and are looking for a highly motivated Data Engineer with expertise in SQL, Python and Database management.

Our offices are based in a WeWork space by Tower Bridge, overlooking St Katharine’s docks. It offers barista coffee all day, after work drinks and lots of working space on top of our office.

Role Overview:

We are looking for a Data Engineer who has a strong foundation in developing scalable and efficient database systems and applications. In this role, you'll mostly work on the backend of our models and applications, focusing on database architecture, client integration, and data processing. 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:

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

Required Skills & Experience:

  • 2+ years’ experience as a data engineer.
  • Extensive experience with SQL databases (PostgreSQL, MySQL, or similar), including query optimisation, schema design, and data modelling.
  • Attention to detail.
  • Proficiency with Python for backend services, data processing, and integration tasks.
  • Experience building and consuming RESTful APIs to connect front-end and back-end components.
  • Strong understanding of database architecture, indexing, and query performance optimization.
  • Ability to work with large datasets, complex queries, and ensure data consistency across the system.
  • Familiarity with version control systems, particularly Git.
  • Strong analytical and troubleshooting skills, with the ability to resolve complex data-related issues.

Nice to Have:

  • Familiarity with Azure cloud platform, DBT, Snowflake and Dagster.
  • Familiarity with Linux and Docker.
  • Experience working with companies in the Tech & Telecom industry.
  • Knowledge of data pipeline technologies (ETL, Apache Kafka, etc.).

Data Engineer in Aberdeen employer: Kolayo

At Kolayo, we pride ourselves on fostering a dynamic and inclusive work culture that encourages innovation and collaboration. Our hybrid work model allows you to enjoy the vibrant atmosphere of our Tower Hill office while also providing flexibility, ensuring a healthy work-life balance. With opportunities for professional growth and development in cutting-edge technologies, joining our team as a Data Engineer means being part of a forward-thinking company that values your contributions and invests in your future.
K

Contact Detail:

Kolayo Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Data Engineer in Aberdeen

✨Tip Number 1

Network like a pro! Reach out to people in the industry, attend meetups, and connect with potential colleagues on LinkedIn. You never know who might have the inside scoop on job openings or can refer you directly.

✨Tip Number 2

Show off your skills! Create a portfolio showcasing your projects, especially those involving SQL and Python. This gives you a chance to demonstrate your expertise and makes you stand out from the crowd.

✨Tip Number 3

Prepare for interviews by brushing up on common data engineering questions and practical tasks. Practice coding challenges and be ready to discuss your past projects in detail. Confidence is key!

✨Tip Number 4

Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining our team at Kolayo.

We think you need these skills to ace Data Engineer in Aberdeen

SQL
Python
Database Management
Data Processing
ETL
RESTful APIs
Database Architecture
Query Optimisation
Data Modelling
Attention to Detail
Analytical Skills
Troubleshooting Skills
Version Control (Git)
Familiarity with Azure Cloud Platform
Familiarity with Linux and Docker

Some tips for your application 🫡

Tailor Your CV: Make sure your CV is tailored to the Data Engineer role. Highlight your experience with SQL, Python, and database management. We want to see how your skills match what we're looking for!

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how you can contribute to our team at Kolayo. Keep it engaging and relevant to the job description.

Showcase Your Projects: If you've worked on any relevant projects, make sure to mention them! Whether it's a personal project or something from a previous job, we love seeing practical examples of your skills in action.

Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get the best chance to showcase your talents directly to us!

How to prepare for a job interview at Kolayo

✨Know Your Tech Inside Out

Make sure you brush up on your SQL and Python skills before the interview. Be ready to discuss specific projects where you've used these technologies, and prepare to solve a few technical problems on the spot. This will show that you not only know the theory but can also apply it practically.

✨Understand the Company’s Products

Take some time to research Kolayo and their modular analytics model, the Kolayo Cube. Understanding how their technology works and the sectors they serve will help you tailor your answers and demonstrate your genuine interest in the role and the company.

✨Prepare for Behavioural Questions

Expect questions about teamwork and problem-solving, especially since you'll be collaborating closely with co-founders. Think of examples from your past experiences that highlight your analytical skills and ability to troubleshoot complex data issues.

✨Ask Insightful Questions

At the end of the interview, don’t forget to ask questions! Inquire about the team dynamics, the types of projects you’ll be working on, or how they implement data security best practices. This shows that you're engaged and thinking critically about how you can contribute.

Data Engineer in Aberdeen
Kolayo
Location: Aberdeen
Go Premium

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>