• Assist in transforming raw data into structured, high-quality datasets ready for analysis. • Focus on low to moderately complex business problems while receiving coaching from data leadership. • Combine technical skills of a data engineer, analytical mindset of a data analyst, and business acumen to ensure efficient data collection and storage. • Be responsible for end-to-end data workflow including data ingestion, transformation, modeling, and validation. • Enable data-driven decision-making across the organization. • Understand data engineering, business processes, and analytics principles.

• Develop and maintain data pipelines, tooling, and visualizations that make member insights widely available across the company • Identify, compute, and validate the appropriate data sources and metrics to measure success in a product area • Partner with data engineers to design and implement a data architecture that bridges across experimentation, analytics, and operational reporting • Partner with product managers and engineering to conduct forensic investigations into logging, including real-time monitoring of new features the team is launching to support live events • Proactively explore trends in member engagement to surface future opportunities • Cultivate strong partnerships with cross-functional stakeholders • Coach partners to self-serve with existing tools, and evangelize for scaled approaches to expand data access and insights beyond our team

This description is a summary of our understanding of the job description. Click on 'Apply' button to find out more. Role Description As an Analytics Engineer on the Offsite Search Optimization team, you will improve the e-commerce experience for hundreds of millions of users across the world by making it faster and more personalized. The team’s mission is to bridge the gap between onsite product discovery and external discovery platforms, ensuring that Constructor-powered websites can be found, understood, and correctly represented by both Google and Generative engines. - Build measurable foundations to track visibility, traffic sources, and performance across SEO and GEO. - Build the architecture to run technical checkups on customer websites, assess their optimisation level, and provide clear recommendations on what needs to be fixed. - Partner with Product teams to adapt enriched content for SEO/GEO and package it toward external discoverability needs. - Define an SEO/GEO enablement layer with tools, playbooks, and frameworks to scale best practices across teams and customers. Qualifications - Strong SQL and Python (requests, pandas, numpy, etc) - Experience building data integrations between products - Experience with APIs & auth (OAuth2, GA4 and Google Search Analytics API) - Understanding of ETL/ELT workflows on PySpark - Building logic of data extraction from non-structured data (referrers, canonical URLs, page types) Requirements - Experience with BigQuery or similar - JS execution basics (how SSR/CSR affects crawlers) - Knowledge of SEO fundamentals - Experience with BI systems (Looker/Metabase/Superset) - Experience with logs or event handling systems Benefits - Work with smart and empathetic people who will help you grow and make a meaningful impact. - Regular team offsite events to connect and collaborate. - Fully remote team - choose where you live. - Unlimited vacation time - we strongly encourage all of our employees take at least 3 weeks per year. - Work from home stipend! We want you to have the resources you need to set up your home office. - Apple laptops provided for new employees. - Training and development budget for every employee, refreshed each year. - Maternity & Paternity leave for qualified employees. - Base salary: $80k–$120K USD, depending on knowledge, skills, experience, and interview results. - Stock options - offered in addition to the base salary. Company Description Constructor is the next-generation platform for search and discovery in ecommerce, built to explicitly optimize for metrics like revenue, conversion rate, and profit. Our search engine is entirely invented in-house utilizing transformers and generative LLMs, and we use its core and personalization capabilities to power everything from search itself to recommendations to shopping agents. - Founded in 2019 by Eli Finkelshteyn and Dan McCormick. - Our engine powers over 1 billion queries every day across 150 languages and roughly 100 countries. - Used by some of the biggest ecommerce companies in the world like Sephora, Under Armour, and Petco. - We value empathy, openness, curiosity, continuous improvement, and are excited by metrics that matter.

• Design, build, and iterate on dashboards and analytical reports using enterprise BI and analytics platforms (e.g., Power BI, Tableau, Looker, Sisense) • Develop calculations and analytical logic within BI tools to ensure accuracy, consistency, and performance • Conduct exploratory and ad hoc analyses using SQL and Python to answer new or ambiguous business questions • Work alongside Data Engineers to review and influence warehouse models so they effectively support downstream reporting needs • Translate stakeholder questions into structured analyses and well-designed reporting solutions • Work with structured warehouse data and existing data models to create clear, performant, and maintainable analytical outputs • Maintain and organize BI environments, documentation, and reporting standards • Move quickly to meet evolving business needs while maintaining high standards of precision and data integrity • Perform ad hoc requests as needed, working with stakeholders to merge frequent requests into the analytics domain • Apply new technologies, including AI, to meet the analysis and decision support needs of the organization