• Design, build, and maintain analytics-ready datasets and data models to support reporting, dashboards, and advanced analytics. • Develop and optimize data transformation logic to ensure performant and reliable analytical outputs. • Support the creation of curated analytics layers that enable consistent and reusable insights across teams. • Troubleshoot and resolve data quality, performance, and pipeline issues impacting analytics delivery. • Partner with business and technical stakeholders to translate analytical requirements into datasets, metrics, and visualizations. • Enable downstream consumption of analytics outputs through reporting tools and dashboards. • Support ad-hoc analysis and exploratory data needs as required. • Enable and support analytics-driven solutions built using Power BI, Power Apps, and Power Automate. • Design and maintain data integrations that allow Power Platform solutions to consume analytics datasets efficiently. • Collaborate with Power Platform developers to ensure analytics outputs are structured and optimized for application and automation use cases. • Assist in troubleshooting data-related issues impacting Power Platform apps, flows, and reports. • Work closely with cross-functional teams to improve analytics workflows and delivery processes. • Contribute to continuous improvement of analytics practices, performance, and usability. • Document analytics solutions, datasets, and integration patterns to support maintainability and knowledge sharing. • Write and maintain SQL-based data transformations and automated data quality tests to ensure data integrity. • Mentor junior team members and contribute to team knowledge development and technical growth.

• 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.