Senior Data Engineer, Business Intelligence (SCM Autonomation)

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

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

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

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

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

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

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

쿠팡