Software Engineer, Data Warehouse - US App

Introduction

Our Mission

Mercari has sought to expand overseas from the outset. This led us to enter the US market in 2014, the year after Mercari’s founding. The US is home to people of diverse backgrounds, of many different races, nationalities, and religions. Laws and culture also differ from state to state. Growing our US service requires grappling with complex problems and issues. This is exactly why we think of the US as a microcosm for our future global expansion. It’s an extremely important country for us, where we cannot afford to fail. While this makes it much more difficult than our Japan-side operations, our US business contributes greatly to achieving Mercari’s mission, and we will continue to face the challenges of the US market going forward.

Our Culture

To achieve our mission at Mercari, our organization and each of our employees share the same values and perspectives. Our individual guidelines for action are defined by our three values: Go Bold, All for One, and Be a Pro. Our organization is also shaped by our four foundations: Sustainability, Diversity & Inclusion, Trust & Openness, and Well-being for Performance. Regardless of how big Mercari gets, the culture will remain essential to achieving our mission and something we want to preserve throughout our organization.

We invite you to read the “Mercari Culture Doc,” which summarizes the behaviors and mindset shared by Mercari and its employees. We continue to build an environment where all of our members of diverse backgrounds are accepted and recognized, and where they can thrive while holding dear Mercari’s culture.

Position Overview

What You'll Do

• Design, build and operate ETL pipelines at scale that are developed with quality, reliability, and availability as goals

• Review existing data warehouse usage and design and implement data products based on best practices in data warehousing to ensure quality, performance and reliability of data in the enterprise data warehouse

• Produce clear, well-documented code for product features

• Collaborate with internal teams to fix and improve data products and evaluate and implement new cloud technologies

• Automate tasks through appropriate tools and scripting

Unique Challenges

• You will work with a talented team based in Tokyo, and also collaborate with many teammates across the US. Working globally with a diverse team, we’re all-in to help people in the US buy and sell on Mercari, while getting ready for whatever comes next.

• You will participate in defining and leading the development of Mercari US’s data warehouse from the ground up

Minimum Requirements

• Shared understanding and belief in Mercari Group mission and values

• At least 8+ years of experience in building data pipelines on cloud data warehouses

• Industry experience building and productionalizing data pipelines

• Advanced knowledge of databases, real-time and batch data pipelines, SQL and data analysis

• Expert experience with RDBMS and SQL, Data Warehousing methodologies

• Prior experience with Google Cloud Platform or AWS or related cloud services specifically around ETL (DataProc (ApacheSpark), DataFlow (Apache Beam), Airflow and DBT or DataForm)

• Experience with Kafka or other streaming pipelines

• Ability and desire to take full ownership of projects, driving them forward to completion
  
  

Preferred Requirements

• Exposure to BI tools desired, but not required (eg. Looker preferred, Metabase & Tableau)

• Familiarity with Python/Java and willingness to learn to gain proficiency

• Experience with Apache Airflow or related workflow scheduling products

• Prior experience with Data Observability Tools (eg. Monte Carlo)

Screening Criteria

• Please provide your resume in English.

• We will conduct interviews in English.

• Hiring Process Overview (subject to change)

• 　1. Doc Screening
  　2. Interviews (3-4 rounds. There are some cases you will meet a few members in 1 round)
  　3. Background check
  　4. Offer
  　5. Hire

Language Requirements

• English: Independent (CEFR-B2)

• Japanese: Basic (CEFR-A2) optional * For details about CEFR, see here