Sql jobs in United Kingdom

Constructor is the next-generation platform for search and discovery in e-commerce, 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. Engineering is by far our largest department, and we’ve built our proprietary engine to be the best on the market, having never lost an A/B test to a competitive technology. We’re passionate about maintaining this and work on the bleeding edge of AI to do so.

Out of necessity, our engine is built for extreme scale and powers over 1 billion queries every day across 150 languages and roughly 100 countries. It is used by some of the biggest e-commerce companies in the world like Sephora, Under Armour, and Petco.

We’re a passionate team who love solving problems and want to make our customers’ and coworkers’ lives better. We value empathy, openness, curiosity, continuous improvement, and are excited by metrics that matter. We believe that empowering everyone in a company to do what they do best can lead to great things.

Constructor is a U.S. based company that has been in the market since 2019. It was founded by Eli Finkelshteyn and Dan McCormick who still lead the company today.

An important part of our product is the customer dashboard that helps merchandizers to analyze shopping behavior and manually adjust algorithmic results. The goal of the Merchant Intelligence team is to:

• Help merchandizers achieve their e-commerce goals, increasing satisfaction with their sites and retention of customers.
• Provide insights to merchants they can't get anywhere else.
• Become a critical point of merchant planning, decision making, and analysis so we become a sticky part of their organization.

• Enhance the dashboard experience for merchandizers by building analytics that provide actionable insights to improve e-commerce KPIs.
• Perform data exploration and research user behavior.
• Implement end-to-end data pipelines to support real-time analytics for essential business metrics.
• Take part in product research and development, iterate with prototypes and customer product interviews.

• You are proficient in BI tools (both data analysis and building dashboards for engineers and non-technical folks).

• You are keen to not just prepare more data, but to think critically about how that data can deliver valuable insights and drive impactful decisions for non-technical end users.
• You are an excellent communicator with the ability to translate business requests into technical language and vice versa.
• You are excited to leverage massive amounts of data to drive product innovation and deliver business value.
• You are proficient at SQL (any variant) and well-versed in exploratory data analysis with Python (pandas & numpy, data visualization libraries)
• Practical familiarity with the big data stack (Spark, Hive, Databricks).
• You are adept at fast prototyping and providing analytical support for initiatives in the e-commerce space by identifying and focusing on relevant features and metrics.
• You are willing to develop and maintain effective communication tools to report business performance and inform decision-making at a cross-functional level.
• You get excited to hear feedback from customers and figure out potential solutions.
• You're familiar with math statistics.
• Stack: python, SQL, pyspark, clickhouse, cubejs, docker, git

• ️ Unlimited vacation time - we strongly encourage all of our employees take at least 3 weeks per year
• Fully remote team - choose where you live
• ️ 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
• Work with smart people who will help you grow and make a meaningful impact
• This position has a base salary range between $80k and $120k USD. The offer varies on many factors including job related knowledge, skills, experience, and interview results.
• Regular team offsites to connect and collaborate

At Constructor.io we are committed to cultivating a work environment that is diverse, equitable, and inclusive. As an equal opportunity employer, we welcome individuals of all backgrounds and provide equal opportunities to all applicants regardless of their education, diversity of opinion, race, color, religion, gender, gender expression, sexual orientation, national origin, genetics, disability, age, veteran status or affiliation in any other protected group.