Data Engineer

About Semrush

Semrush is a global Tech company and a leading online visibility management SaaS platform. We empower businesses worldwide to manage SEO, PPC, content, social media, and competitive research campaigns. With over 17 years in product development, Semrush has earned accolades like G2's Top 100 Software Products and a Great Place to Work Certification. Publicly traded on the NYSE (SEMR) since March 2021, we serve 10,000,000+ users globally with a team of over 1,700 dedicated professionals.

The Opportunity: Data Engineer

Are you ready to be a part of Semrush's innovative journey? We are seeking a Data Engineer to join our team and significantly contribute to the development of a scalable and reliable data platform. In this pivotal role, you will be instrumental in designing and maintaining robust data architecture and pipelines. Your work will transform raw data into high-quality datasets essential for reporting, advanced analytics, and critical business decision-making.

You will collaborate closely with the Data Engineering team, data analysts, and key stakeholders across the organization, ensuring that data is consistently accessible, accurate, and well-governed.

Key Responsibilities

• Data Pipeline Development: Design, build, and maintain robust ELT/ETL pipelines. Champion the adoption of reproducible, version-controlled pipeline development practices.
• Data Modeling & Transformation: Develop and optimize data warehouse models, ensuring performance, scalability, and usability for diverse analytics use cases.
• Data Quality & Observability: Implement automated testing, comprehensive monitoring, and stringent data quality controls to proactively identify and efficiently resolve data issues.
• Performance Optimization: Enhance storage efficiency and optimize query performance, supporting scalability and effective cloud cost management (FinOps).
• Collaboration & Stakeholder Partnership: Partner with data analysts and business stakeholders to deeply understand requirements and ensure timely, reliable data availability for reporting, analytics, and machine learning initiatives.

Who We Are Looking For

We are seeking candidates who possess:

• Bachelor’s degree in Computer Science, Engineering, Data Science, or a closely related field (or equivalent practical experience).
• Proven experience working with SQL and Python in a data engineering or analytics environment.
• Familiarity with data warehousing concepts and a strong understanding of ETL/ELT processes.
• Solid understanding of databases, data modeling, and schema design principles.
• Demonstrated ability to collaborate effectively with both technical and non-technical stakeholders.
• A strong learning mindset, eager to continuously develop technical and professional skills.
• Excellent problem-solving skills, capable of connecting technical solutions directly to business needs.

Not Required But a Plus

• Experience with big data and data infrastructure tools such as Spark, Airflow, ClickHouse, and Trino.
• Familiarity with cloud platforms such as AWS or GCP.
• Understanding of machine learning concepts and/or exposure to MLOps practices.

What We Offer

Semrush is committed to creating an environment where you can work and thrive comfortably, offering:

• Unlimited PTO and flexible working hours.
• Inter Polska Health Insurance and Life Insurance co-financing.
• Worksmile Cafeteria Program (available after 2 months of employment), including co-financing for the Multisport card.
• Mental health support including private therapy sessions (in Polish and English).
• Option for a B2B contract.
• Employee Referral Program and Buddy Program.
• Corporate events, teambuilding activities.
• Opportunities for training, courses, and conference attendance.

Key skills/competency

• Data Engineering
• SQL
• Python
• ETL/ELT
• Data Warehousing
• Data Modeling
• Data Quality
• Cloud Platforms (AWS/GCP)
• Apache Spark
• Apache Airflow