Job Description
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.
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.
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.
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.
Governance, Security & Compliance
Adhere to enterprise data governance, security, and privacy policies.
Ensure solutions meet data quality, auditability, and lineage requirements.
Requirements
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.
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
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.
Effective communication skills with the ability to explain technical concepts to non-technical audiences.
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
Firm's Certified Qualifications Sponsorship for career development
Annual company trip inside or outside Vietnam
Working in one of the largest digital transformation agencies in Asia - Professional English environment