Database Backend Engineer

Does ingesting millions of rows per minute sound appealing? Are you the kind of person who squeezes EVERY drop of performance out of your database? This may be the job for you. Centric Market Intelligence™ (formerly StyleSage), is an AI driven competitive assortment benchmarking and market trend insights solution for fashion, beauty and home goods brands and retailers.

We are a key innovation partner for iconic and emerging brands across the world.

Our platform is able to analyze the info of more than 1.000 retailers, processing data from more than 600.000 brands, tracking 100’s of millions of products!

You will be part of the Backend Team, where you will develop the processes and tools to keep that pipeline of data in excellent shape, fresh and available.

To do that, you will use the latest and best open-source technologies out there. Our massive amount of data lives in PostgreSQL databases, and we know how to take good care and make the most of them. We code in Python (and we love it, you may want to come to the PyCon Spain conference with us!). We are a cloud-native company, so our code runs in AWS, and we provision that infrastructure with Terraform and Ansible code. We keep an eye on all this using observability tools like Grafana, Timestream and Telegraf.

If you do not know a lot about some of those technologies, worry not, our engineers will be happy to support you while you are on your journey to becoming an expert in them.

What You'll Do:

• ·Contribute to the maintenance and design of highly scalable and resilient future-proof stateful systems that can handle large volumes of data and support critical applications.
• Build and maintain robust data pipelines to ensure seamless data flow within the organization.
• Backend application development focused on supporting databases for mission-critical applications. · Conduct performance analysis and tuning.
• Automate processes and document procedures to enhance efficiency.
• Communicate with other teams to coordinate joint initiatives.
• Mentor and support more junior members of the team and organization.
• Divide big tasks into smaller ones and prioritize their execution.

Your Skills: 

• 5+ years of experience working as a software engineer, preferably with a proven track record of leading database initiatives within complex, large-scale environments.
• You have a degree in software engineering or equivalent knowledge and experience.
• You can communicate in English proficiently with both technical and non-technical peers.
• You have good knowledge of Python.
• You understand OLTP and OLAP systems and can design databases to support both.
• Advanced SQL skills, including experience in stored procedures, query optimization, and complex data modeling.
• You have experience designing, implementing, and scaling cloud-native database systems on providers like AWS.
• You know how to analyze engineering trade-offs and then be pragmatic and roll up your sleeves to get things done, one small step at a time.

Tools for the job:

• SQL, PostgreSQL at an advanced level
• Python
• Spark
• Linux shell command line and scripting
• AWS services (Mainly RDS, EC2, ECS and EMR)

Additionally, it would be nice if you are familiar with:

• Docker
• Celery
• Django
• RabbitMQ, SQS
• Exasol
• Grafana, Influxdb, Timestream · Citus (PostgreSQL)

Soft Skills:

• Your work will require communicating and aligning with other peers. Effective communication skills are necessary.
• Ability to work autonomously. We will be there to unblock you and help you in all your tasks at any time, but we expect you to do the heavy lifting by yourself.

What we offer:

• 100% remote work
• Training and conference budget
• Health insurance
• Life insurance
• Private pension plan