Senior Data Engineer, Business Intelligence (SCM Autonomation)

About Coupang

We exist to wow our customers. We know we’re doing the right thing when we hear our customers say, “How did we ever live without Coupang?” Born out of an obsession to make shopping, eating, and living easier than ever, we are collectively disrupting the multi-billion-dollar commerce industry from the ground up and establishing an unparalleled reputation for being leading and reliable force in South Korean commerce.

We are proud to have the best of both worlds — a startup culture with the resources of a large global public company. This fuels us to continue our growth and launch new services at the speed we have been at since our inception. We are all entrepreneurial surrounded by opportunities to drive new initiatives and innovations. At our core, we are bold and ambitious people that like to get our hands dirty and make a hands-on impact. At Coupang, you will see yourself, your colleagues, your team, and the company grow every day.

Our mission to build the future of commerce is real. We push the boundaries of what’s possible to solve problems and break traditional tradeoffs. Join Coupang now to create an epic experience in this always-on, high-tech, and hyper-connected world.

Role Overview

Our team is seeking an experienced Senior Data Engineer who specializes in engineering the data backbone for analytics. This role is for a technical expert who excels at performance-tuning complex queries and building efficient, reliable data models. You will apply software engineering principles to the analytics space, ensuring the data that powers our company's insights is accurate, timely, and delivered with maximum efficiency. 

Key Responsibilities

• Engineer and Optimize Data Models: Your primary focus will be on engineering the data transformation layer. You will architect and build the SQL and Python logic that converts raw fact tables into optimized, analysis-ready models for our reporting platforms. 

• Masterful Query Performance: Write, debug, and optimize complex SQL queries in Redshift and Hive (Presto). You are expected to be an expert in query performance, using techniques like data chunking and execution plan analysis to ensure fast and cost-effective data retrieval. 

• Data Engineering with Python: Utilize Python and its libraries (e.g., Pandas) for sophisticated data manipulation, validation, and preparation tasks where SQL is not sufficient. 

• Orchestrate Data Workflows: Implement and maintain robust Airflow DAGs to orchestrate complex data workflows. You will be responsible for the scheduling, execution, and monitoring of these critical jobs. 

• Uphold Data Integrity: Apply engineering rigor to data quality. You will proactively monitor, identify, and resolve issues in the data pipelines, treating data accuracy as a top-priority feature. 

• Enable Business Intelligence: Partner with stakeholders to understand reporting needs and provide the clean, well-structured backend data required by BI platforms like Superset, Tableau, and Power BI. 

Qualifications

• Experience: 4+ years in a data engineering, BI engineering, or a similar role with a strong focus on data modeling and query optimization. Experience in an e-commerce or a related high-volume transactional data environment is a strong plus. 

• Expert-Level SQL: This is the most critical skill for the role. You must have demonstrated mastery of SQL and a deep understanding of how to write high-performance queries in a cloud data warehouse (Redshift) and data lake (Presto/Hive) context. 

• Data-Focused Python Skills: Strong proficiency in Python for data engineering tasks, including advanced data manipulation with libraries like Pandas and scripting for workflow automation. 

• Workflow Orchestration: Hands-on experience with an orchestration system like Airflow, including authoring, scheduling, and monitoring complex DAGs. 

• Performance-Oriented Mindset: You are driven to find the most efficient solution to a problem. You naturally analyze performance and cost and are always looking for ways to optimize. 

• BI Systems Knowledge: A solid understanding of how BI tools work and how to best engineer backend tables to support their functionality. 

Preferred Qualifications

• Professional English & Korean proficiency
• Excellent communicator with great listening skills, growth mindset and can-do attitude

Recruitment Process 

• Application Review - Phone Interview - Virtual Onsite Interview – Offer 
• The exact nature of the recruitment process may vary according to the specific job and may be changed due to scheduling or other circumstances. 
• Interview schedules and the results will be informed to the applicant via the e-mail address submitted at the application stage. 

Details to Consider 

• This job posting may be closed prior to the stated end date for application if all openings are filled.    
• Coupang has the right to rescind an offer of employment if a candidate is found to have submitted false information as part of the application process.    
• Those eligible for employment protection (recipients of veteran’s benefits, the disabled, etc.) may receive preferential treatment for employment in accordance with applicable laws.
• Job titles and responsibilities may be subject to change depending on the candidate’s overall experience, etc. This will be communicated to the candidate at the appropriate time before the offer.

Privacy Notice 

• Your personal information will be collected and managed by Coupang as stated in the Application Privacy Notice located below. 

        https://www.coupang.jobs/en/privacy-policy/

Document Return Policy

• This notification is given pursuant to Article 11 (6) of the Fair Hiring Procedure Act.
• A job applicant, who has applied but not been finally selected for a position at Coupang (the “Company”), may request the Company to return his/her hiring documents submitted pursuant to the Fair Hiring Procedure Act.  However, this will not apply where the hiring documents were submitted via the website of the Company or e-mail, or where the job applicant submitted those documents voluntarily without a request from the Company.  In addition, if the hiring documents were destroyed due to a natural disaster or any other reasons not attributable to the Company, such documents will be deemed to have been returned to the job applicant. 
• A job applicant who wishes to request the return of his/her hiring documents pursuant to the main sentence of paragraph 2 above should fill out a “Request for Return of Hiring Documents” [Annex Form No. 3 in the Enforcement Rule of the Fair Hiring Procedure Act] and submit the request to the Company (Coupang Recruiting Team, Tower 730, 570 Songpa-daero, Songpa-gu, Seoul). In such case, within fourteen (14) days from the date of identifying the receipt of the request, the Company will send the hiring documents to the job applicant’s designated address via registered mail.  Please be informed that the job applicant is required to pay the postage on the registered mail. 
• In preparation for a job applicant’s request for the return of hiring documents pursuant to the main sentence of paragraph 2 above, the Company shall retain the original hiring documents submitted by the job applicant for 180 days from the completion of the recruiting process.  If no request is made until the end of this period, all of his/her hiring documents will be destroyed immediately in accordance with the Personal Information Protection Act. 
• Hiring may be restricted in case the legal qualifications required for hiring and work performance are not met.