People Matter

Software Engineer, Data



Software Engineering
New York, NY, USA
Posted on Monday, March 25, 2024

Our mission is to inspire entrepreneurs and shoppers to find something new. We buy great brands built on Shopify, unlocking liquidity for small business entrepreneurs looking to start new adventures. We manage nearly 50 brands with over 100,000 products across apparel, beauty, home goods, and electronics.

Our team of e-commerce experts and engineers uses our proprietary technology and tooling, and advantages from our size, to grow our brands at scale.

Two million people have purchased OpenStore products, and soon, we’ll launch a consumer shopping app, helping people discover products in an all-new way. OpenStore was started in 2021 by top investor and operator, Keith Rabois, a former executive at PayPal, LinkedIn, and Square, and a co-founder of Opendoor. We are backed with $150M+ from world-class investors such as Atomic, Khosla Ventures, Founders Fund, General Catalyst, and Lux Capital.

At the heart of OpenStore's mission lies the commitment to deliver an enriching and delightful online shopping journey. Achieving this vision hinges upon a cutting-edge, adaptable, and trustworthy data system that underpins every facet of the business. This system ensures that all business operations can rely on it with utmost confidence, enabling the creation of serendipitous and enjoyable experiences for customers.

OpenStore employs a distinctive approach, acquiring and managing numerous direct-to-consumer Shopify brands. Data lies at the heart of OpenStore's strategy. We meticulously gather Shopify sales data, product attributes, customer demographics, financial records, advertising placements, website traffic, and other pertinent information to create a comprehensive understanding of a diverse range of digital merchants and their customer bases. This encompasses various analyses such as sales funnel evaluation, ad effectiveness assessment, conversion enhancement strategies, and operational cost efficiency measures, among others.

At OpenStore, our data engineering team empowers data scientists, analysts, and business units to unlock invaluable insights that redefine the ecommerce landscape. We're actively seeking talented Senior Data Engineers to join our dynamic team. Our ideal candidate is a sharp, innovative problem solver who thrives on collaboration and excels in identifying impactful opportunities. In this role, you'll spearhead the design, development, and upkeep of scalable data pipelines and infrastructure. Working closely with cross-functional teams, you'll translate data needs into robust solutions that fuel business innovation and drive actionable insights. Join us in shaping the future of ecommerce through cutting-edge data engineering!

What You’ll Do:

  • Design, build, and optimize end-to-end data pipelines to collect, process, and store large volumes of structured and unstructured data from various sources

  • Design and implement scalable data models and architectures to support data warehousing, analytics, and reporting needs. Ensure data integrity, consistency, reliability and performance

  • Integrate data from multiple sources, both internal and external, ensuring compatibility and reliability. Implement ETL processes and tools for efficient data extraction, transformation, and loading

  • Manage and optimize AWS cloud-based data infrastructure including storage, compute, and networking resources. Implement best practices for security, scalability, and performance

  • Identify and resolve performance bottlenecks in data pipelines and systems. Implement monitoring, logging, and alerting mechanisms to ensure high availability and reliability of data infrastructure

  • Collaborate with cross-functional teams including data scientists, analysts, software engineers, and business stakeholders to understand data requirements and deliver solutions that meet business objectives

  • Communicate effectively with technical and non-technical stakeholders

  • Provide guidance and mentorship to other team members. Lead by example in adopting best practices, promoting continuous learning, and fostering a culture of innovation and collaboration

Who You Are:

  • You like to build and ship. You have strong opinions grounded in logic and can drive forward to delivery. You think strategically about prioritization

  • You care about tangible results. You will break through walls in order to deliver impact with high agency

  • You are curious. You like to independently research the current ecosystem of methods and algorithms in order to bring new ideas to the table

  • You thrive in fast-paced environments. You will iterate with engineers, scientists, analysts, and business teams to focus on high impact work and deliver quickly

  • You are analytically rigorous. You have a deep bias towards using data and analyses to drive decisions

  • You’ve done it before. You’ve worked with at scale data systems, engineered well designed and cost efficient data solutions, and swiftly responded to identified issues to mitigate them in a timely manner

What You Have:

  • Bachelor's or Master's degree in Computer Science, Engineering, or related field

  • 4+ years of experience in data engineering, with a focus on building and maintaining scalable data pipelines and infrastructure

  • Proficiency in programming languages such as Python, Java, SQL, or Scala

  • Strong understanding of data processing technologies and distributed computing frameworks (e.g. Hadoop, Hive, Airflow, Spark, DBT, Kafka, Flink)

  • Experience with cloud platforms such as AWS, Azure, or GCP, and related services (e.g. S3, Snowflake, BigQuery)

  • Hands-on experience with database systems (e.g. SQL, NoSQL, vector, search) and data warehousing solutions (e.g. Snowflake, Redshift, BigQuery)

  • Familiarity with containerization and orchestration technologies (e.g. Docker, Kubernetes) is a plus

  • Excellent problem-solving skills and attention to detail

  • Strong communication and interpersonal skills, with the ability to work effectively in a collaborative team environment

  • Comfort working as both a data analyst and an backend engineer when needed

  • Experience in an engineering-rich environment

  • Ambitious, eager, adaptable, and scrappy approach to creating value

  • Nice to have: ML ops experience

OpenStore is a proud Equal Opportunity Employer where we welcome and celebrate differences. We are committed to providing a workspace that is safe and inclusive, where everyone feels supported, connected, and inspired to do their best work. If you require any accommodations to participate in our recruitment process, please inform us of your needs when we contact you to schedule an interview.