Data Model Engineer (PostgreSQL)

What do we do?

For the past 10 years, we’ve been developing Mendel — an on-premise solution that protects organizations from cyber threats through network traffic analysis. Unlike typical SaaS services, we do not have access to customer data. Mendel runs directly within the customer’s infrastructure and processes data autonomously.

We don’t build reports on top of someone else’s data. We develop the core of the system itself — software that, in real time, creates a digital model of a network, defines relationships between objects, and detects anomalies or unusual behavior.

Technologically, everything is built on PostgreSQL. In our team, we design and evolve the data model and decision rules that allow Mendel to operate independently and protect customers.

What will you do?

• Analyze the performance of complex SQL transformations
• Break down and optimize analytical queries
• Work with execution plans, statistics, and PostgreSQL internals
• Identify bottlenecks and propose concrete solutions
• Develop and maintain data pipelines processing large-scale datasets (tens of TB, billions of rows)

Over time, you’ll move towards designing and optimizing new parts of the data model, contributing to detection methods, or even developing PostgreSQL extensions.

What should you know?

• Be able to write SQL queries (a few SELECTs with JOINs is enough to start)
• Understand database fundamentals (indexes, normalization, transactions, optimization)
• Experience with PostgreSQL or large-scale datasets is a plus

How do we imagine you?

• Complexity doesn’t intimidate you — it motivates you to go deeper
• When something doesn’t make sense, you don’t let it go until it does
• You’re curious about how data is generated and what it truly reveals about network communication

We’re not looking for a finished expert. We’re looking for someone with solid fundamentals and the drive to grow deeper. Your future Team Leader, Michal, built Mendel’s data model from the ground up and will gradually guide you through it. Strong basics are enough — we’ll teach you the rest.

What you can look forward to

• 5 weeks of vacation + 4 sick days – when you’re not feeling great, no guilt trips.
• Flexible working hours and remote work options
• Annual bonus – we reward each other based on company performance.
• Education budget – courses, books, conferences that matter to you.
• Multisport card contribution – to stretch your back after sitting all day.
• Meal allowance, company laptop, and phone plan.
• English lessons – tailored to your level, individually or in groups.
• Team events – sometimes board games, sometimes BBQ, sometimes just a beer trip.