Skill needed: Team Leadership, SQL, Python.
Employer: SEMrush
Semrush is a brand visibility platform, empowering marketers to command their online presence and create measurable impact. We unify SEO authority and AI visibility, so brands are found, cited, and chosen everywhere search happens. That’s how Semrush gained the trust of over 28 million users—from scaling startups to Fortune 500 companies.Here, you own the way you work, but we move as one unbeatable team.We don’t just lead the market, we’re busy creating the world where Semrush is an unfair advantage for every marketer.We move fast in ways to help you grow. Here, you have room to experiment, keep what works, and learn quickly from what doesn’t.Ready to share our ambition and make an impact? Then, this role may be for you.About the roleOwn and lead a stream of complex analytical projects, from problem definition and scoping through implementation and business adoptionCollaborate closely with cross-functional stakeholders to ensure solutions are aligned with business needs and successfully integrated into workflowsDesign, build, and maintain scalable analytical data pipelines, data models, and data productsDevelop and maintain high-quality, reliable, and well-documented data assets for company-wide useCreate dashboards, reports, and visualizations to communicate insights effectivelyTranslate analytical findings into clear, actionable recommendations for both technical and non-technical audiencesPresent complex insights and solutions to senior leadership in a concise and compelling wayDrive knowledge sharing within the analytics community through demos, documentation, and internal enablement initiativesSupport team members with task decomposition and technical problem-solvingMentor and guide Analytics Engineers, fostering a collaborative and growth-oriented environmentContribute to improving development standards, data quality, and engineering best practicesAbout youMove together. Raise the bar. Learn fast—grow faster. That’s the default. And here’s what else is needed to succeed in this role: Strong foundation in mathematics and statistics6+ years of experience in analytics engineering, data engineering, data science, or a related fieldStrong SQL skills and deep understanding of relational databasesProficiency in Python for data processing and analysisBachelor’s degree in a quantitative field such as STEM, Economics, or Business Analysis (advanced degree is a plus)Hands-on experience with modern data stack tools, including:Airflowdbt (including Jinja)GitCloud platforms (e.g., GCP)Strong knowledge of data modeling techniques (e.g., star/snowflake schemas, SCDs, modular modeling in dbt)Experience building and maintaining complex, multi-step data pipelines (ETL/ELT)Experience working with conceptual and logical data models and designing scalable data schemasFamiliarity with BI and data visualization tools (e.g., Tableau) is a plusExperience with Bash or scripting is a plusProven ability to mentor and support junior and mid-level team membersStrong analytical thinking and problem-solving skillsExcellent communication and stakeholder management skillsAbility to balance technical execution with business context and prioritiesCuriosity to stay current with emerging tools, technologies, and best practices in analytics engineeringAbout the perksUnlimited PTOHobby & team building budget allowanceEmployee Support ProgramLoss of family member financial aidEmployee Resource GroupsA little more about usSemrush is the leading brand visibility platform, empowering marketers to command their online presence and create measurable impact.Built on the industry’s most expansive proprietary dataset, Semrush delivers AI-driven insights across GEO, SEO, Agentic Search Optimization, content marketing, paid media, and social strategy. The company was founded in 2008 and is headquartered in Boston, MA with a global presence across North America, Europe and Asia.We’ve built something people are proud to be part of. And the awards agree: Great Place to Work, DEI Workplace, Diversity Champion Award, International Inclusion Award, Most Women Friendly Employers, Best Place for Working Parents. All thanks to 1700+ employees who build the company every day. About our Diversity, Equity, and Inclusion commitments Semrush is an equal opportunity employer. Building a better future for marketers around the world unites people from all backgrounds. Even if you feel that you don’t 100% match all requirements, don’t be discouraged to apply! We are committed to ensure that everyone feels a sense of belonging in the workplace.We do not discriminate based upon 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. Ready to be a part of this mission? Join us!