Data Engineer (Japanese)

Job Description

1. Data Engineering & Integration

– Design, develop, test, and maintain scalable ETL/ELT pipelines across multiple enterprise systems and data platforms.

– Build and support data integration solutions for customer, account, product, and reference master data domains.

– Develop and optimize data ingestion, transformation, and orchestration processes for batch and near-real-time workloads.

– Implement robust error handling, monitoring, and recovery processes to ensure reliable data delivery.

– Troubleshoot and resolve data integration, transformation, and performance issues.

– Extend existing pipelines, matching, and reconciliation to bring new scope into the Foundational Account Master, including Retail, while maintaining current SMDD Local and SMDD/CVS loads.

2. Data Quality & Master Data

– Develop and maintain data cleansing, standardization, validation, and enrichment processes.

– Implement data matching, reconciliation, and survivorship logic to support golden record creation and master data management initiatives.

– Build and maintain data quality controls, exception reporting, and remediation workflows based on business requirements and governance standards.

– Partner with Business Systems Analysts and Data Stewards to implement business rules, data definitions, and quality requirements.

– Support ongoing data quality improvement initiatives through root-cause analysis and corrective actions.

3. Cloud Data Platform & Data Warehousing

– Develop and support solutions on Azure-based data platforms and Snowflake data environments.

– Extend data models, implement transformation logic, and produce curated datasets that support analytics and reporting needs.

– Monitor, maintain, and improve performance, scalability, reliability, and cost efficiency of data workloads.

– Handover of deliverables to support and operations support teams.

4. Collaboration & Delivery

– Collaborate with Business Systems Analysts, Product Owners, Data Architects, Data Stewards, and business stakeholders to translate requirements into technical solutions.

– Support the delivery of data products and reporting solutions across customer, commercial, supply chain, finance, and other business domains.

5. Governance, Security & Compliance

– Adhere to enterprise data governance, security, and privacy policies.

– Ensure solutions meet data quality, auditability, and lineage requirements.

Requirements

1. Experience
– 3~5+ years of experience in Data Engineering, Data Warehousing, Analytics Engineering, or a related field.
– Good Japanese speaking skill (N2+)
– Hands-on experience designing, developing, and supporting enterprise ETL/ELT pipelines.
– Experience integrating data from multiple source systems, including databases, files, APIs, and enterprise applications.
– Experience implementing data transformation, cleansing, validation, and reconciliation processes.
– Experience working with cloud-based data platforms and modern data architectures.
– Experience supporting data quality, master data, or data governance initiatives in a business environment.

2. Technical Skills

Required
– Advanced SQL development and query optimization
– Python for data engineering and automation
– Azure Data Factory (ADF) or equivalent orchestration platform
– Snowflake or comparable cloud data warehouse technologies
– Data modeling and data transformation design
– Git-based source control and version management
– CI/CD concepts and deployment practices
– Experience developing and troubleshooting ETL/ELT processes
– Experience working with structured and semi-structured data formats (CSV, JSON, XML, Parquet, etc.)

Preferred
– REST API integration and data ingestion
– Master Data Management and reference data management
– Data matching, survivorship, and reconciliation techniques
– Data quality frameworks, monitoring, and exception reporting
– Experience with Dynamics 365, Salesforce, SAP, or other enterprise business applications
– Experience working with Agile delivery teams

3. Knowledge & Skills
– Strong analytical and problem-solving skills.
– Ability to understand business requirements and translate them into technical solutions.
– Strong attention to detail and commitment to data quality.
– Ability to work effectively in cross-functional teams with Business Systems Analysts, Data Stewards, Architects, and business stakeholders.

Benefits

At SmartOSC, we offer the best to your values:

– Attractive salary package 

– Salary review twice a year

– Flexible working hours (between 7:30am – 7:30pm on staff’s preference)

– Premium health care 

– Working in one of the largest digital transformation agencies in Asia – Professional English environment

– Firm’s Certified Qualifications Sponsorship for career development

– Annual company trip inside or outside Vietnam

Personal Data Consent Notice

By submitting your resume for this position, you acknowledge and consent that the Company may collect, use, store, disclose (where necessary), and otherwise process your personal data for recruitment-related purposes, including evaluating your application, communicating with you, and making hiring decisions. Your personal data may be shared with relevant third parties involved in the recruitment process on a need-to-know basis. You acknowledge and consent that the Company shall retain your personal data for as long as necessary to fulfil the above purposes or to comply with applicable legal obligations. Where permitted by applicable law, you may submit a written request for the deletion of your personal data.