Senior Data Engineer (Wind Team)

About our company

Semrush is a unified online platform that allows marketing professionals to create campaigns on all available channels, manage them, measure results, and improve the online visibility of their products and services. We’ve been developing our product for 13 years, and in that time, we’ve won many different awards: Top 100 Software Products from G2, Global and US Search Awards 2021, Great Place to Work Certification, and Deloitte Technology Fast 500.

In March 2021, Semrush went public, and we listed our stock on the New York Stock Exchange (NYSE) under the SEMR ticker.

We now have 10,000,000+ customers in America, Europe, Asia, and Australia, and more than 1,000 people around the world are working on our service.

Get yourself found, our new colleague! We are waiting for you!

About our team

The name Product & Development (P&D) is self-explanatory. More than 40 teams are involved in creation and development of Semrush products.

Interesting fact: almost every P&D team is associated with a specific colour – yellow, blue, red, black, orange, etc. Instead of mundanity, we strive to enjoy bright and exciting daily routines. The spirit of creativity is everywhere at Semrush.

In every location, the team set-up looks something like this: Product Owner responsible for the tool development strategy; Backend, Frontend or Fullstack developers; and QA Engineer.

However, there are frequent exceptions. For example, some teams may include a Data Scientist or a DevOps Engineer, other teams a Scrum Master, and some teams may consist entirely of product analysts.

The P&D team has bases in various countries: Spain, Germany, the Netherlands, Czech Republic, Cyprus, Serbia, Armenia and Poland. Our P&D colleagues work on sprints, attend Product demos on Fridays, joke about the fact that a bug is a feature and wholeheartedly love their work.

Key responsibilities

• Making architectural decisions when designing a data storage and processing system. We are not limited in our decision-making and can improve the system as we see fit.
• Integration and collection of data from different internal and external sources into a single Data Warehouse (ETL procedures). Automation of data analysis processes.
• Secure organization of sending data to internal and external products.
• Transition to an event-based model of working with information flows of company data to ensure their functioning in over-realtime mode.
• Writing API.
• Creating monitoring systems: main services, data quality, infrastructure.

Experience and competencies

• One or more years of experience in Data Engineering.
• Proficiency in Python and SQL.
• Experience collecting, processing, and transforming data.
• The ability to intelligently build data flows.
• Understanding of Data Quality approaches.
• Experience with different column and row-based DBMSs. Knowledge of their advantages and disadvantages, in what situation it is better to use one or another system.
• Willingness and ability to automate routine processes.
• Experience with GitLab CI, Docker, Google Cloud Platform.

They say there are no perfect candidates, but it might well be you, if you have:

• Experience with microservices architecture.
• Team development experience.
• Experience working with highly loaded MPP DBMS.
• Data modelling experience.
• Experience with streaming processing.

We offer

• We will try to create all possible conditions for you to work and rest comfortably.
• Work format REMOTE: This offer stands for the remote work format. Digital nomadism, #wfh — call it what you like.
• Flexible working day start that would suit a night owl and an early bird alike. You can start between 9:00 am and 12:00 pm.
• Private health insurance program. Life insurance.
• Stock Purchase Program (ESPP).
• Agile approach to work (we’ll gladly teach you).
• Online English classes.
• Training / online courses and workshops / conferences / books to improve your hard and soft skills.
• Financial compensation for sports and hobbies (gym / dancing / languages / horseback riding / painting / wakeboard and many more. It’s really up to you).
• Corporate psychologist consultations. Mental health is as important as physical well-being.
• Awesome parties, team building, and corporate events in different formats — both online and offline, depending on the current global situation. We can have fun in any case.
• Development teams meet regularly at technical and product demos. We’re all for sharing knowledge.

Interview

At Semrush, we take a serious and comprehensive approach to hiring new people. We only welcome those who are professionals in their field and passionate about their work to join our team.

A “five-minute interview” or “get a job in three clicks” approach is not the way we work.

During the interview, we ask candidates to talk about themselves and their background in detail. We try to discover the most important aspects about the way someone works and their personality before a job offer is made.

Semrush is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based on race, religion, creed, color, national origin, sex, pregnancy, sexual orientation, gender identity, gender expression, age, ancestry, physical or mental disability, or medical condition, including medical characteristics, genetic identity, marital status, military service, or any other classification protected by applicable local, state or federal laws. All employment decisions are based on business needs, job requirements, merit, and individual qualifications.