Senior Data Engineer

Company Description

SmartDev is an AI-powered software development company headquartered in Vietnam, part of the Verysell Group. We help global businesses deliver faster and build smarter — combining AI-driven development practices with deep expertise across fintech, healthcare, retail, and enterprise technology. Our team of engineers, architects, and AI specialists works across the full stack: from custom software and cloud solutions to generative AI, MLOps, and intelligent automation.

The company is at a pivotal point in our journey: transitioning from a pure IT outsourcing provider to an AI-enabled solutions partner.

We have over 200 talented employees working both on-site and remote/hybrid at locations:

• Danang: 81 Quang Trung, Hai Chau 1 ward, Hai Chau District, Danang
• Hanoi: Zodiac building, 19 Duy Tan Street, Dich Vong Hau ward, Cau Giay District, Hanoi

About the Role

We are looking for a Senior Data Engineer to support a data platform initiative, with a strong focus on data discovery, profiling, validation, business reporting alignment, business analysis, and downstream data engineering enablement in a business environment related to pharmaceutical distribution, medication sales, inventory control, and regulated product data.

This senior role requires someone who can bridge business stakeholders and technical teams, clarify reporting and data requirements, validate data quality, document data assets, and contribute to the design of scalable ETL/ELT pipelines and data warehouse structures that support trusted BI and decision-making.

Responsibilities

Data Discovery, Profiling & Business Understanding

• Explore and analyze data from key systems (Magento, PK Software, Microsoft Business Central) and build a clear understanding of the data landscape
• Profile datasets and tables by reviewing row counts, null rates, value distributions, key relationships, and data anomalies
• Identify data sources, data owners, refresh frequency, business context, entities, relationships, and reporting gaps
• Work with stakeholders to understand business processes, reporting pain points, and decision-making needs
• Understand domain-specific data flows related to pharmaceutical sales, product master data, batch and expiry tracking, inventory movement, and compliance-sensitive reporting

Data Catalog, Metadata & Business Definition

• Build and maintain structured documentation for data assets, including tables, fields, data types, relationships, and lineage where applicable
• Document field meanings, business definitions, and glossary terms in language accessible to both technical and non-technical audiences
• Keep metadata and business documentation up to date as the data model and reporting needs evolve
• Gather, analyze, and document business requirements, data requirements, and reporting expectations

Data Quality & Validation

• Define and execute data validation and reconciliation rules
• Identify inconsistencies, duplicates, missing data
• Ensure alignment with trusted data sources

Data Integration, ETL / ELT & DWH Support

• Validate data mapping, transformation logic, and target-model alignment for ETL / ELT pipelines
• Support the design, testing, and validation of reusable pipelines, incremental loads, and reliable data integration patterns
• Support creation of reusable reporting datasets and Data Warehouse (DWH) -ready structures that enable scalable BI and analytics

Reporting, KPI Validation & BI Layer Support

• Validate PowerBI dashboards and reports
• Ensure KPI accuracy (revenue, margin, inventory, etc.)
• Support UAT and business validation sessions
• Support semantic layer, dataset, and reporting-model readiness in collaboration with BI and business stakeholders
• Lead requirement clarification sessions, support gap analysis, and translate business needs into actionable data/reporting specifications

Data Governance Support

• Support definition of data ownership and usage rules
• Contribute to improving data transparency and governance

Requirements

• 5+ years of experience in Data Analyst, Senior Data Analyst, Data Engineer, Data QA, or Data Validation roles
• English proficiency at C1 level, with the ability to lead meetings, workshops, requirement sessions, and written documentation confidently
• Strong SQL skills, including complex querying, data validation, analysis, and performance-aware data investigation
• Experience working with multiple data sources, relational databases such as PostgreSQL, SQL Server, or MySQL, and cross-system data integration contexts
• Familiarity with ETL / ELT pipeline development or validation using Python, SQL-based tooling, low-code platforms, or Apache NiFi
• Strong Business Analyst skills, including requirement elicitation, process understanding, stakeholder communication, and documentation
• Experience validating reports and supporting BI solutions, preferably with Power BI, including data model and KPI verification
• Understanding of data structures and reporting logic
• Strong analytical and problem-solving skills
• Experience with data catalog, metadata, or governance tools (Purview, OpenMetadata, dbt docs, or similar)
• Agile/Scrum experience
• Domain knowledge in pharmaceutical retail/distribution, medication sales, inventory, regulated product data, or healthcare-related reporting is a plus point

Benefits

• International working environment with AI-driven strategic direction
• 20 days of annual leave – Hybrid working mode
• Premium healthcare package with PVI and comprehensive annual health check-ups
• Competitive salary & 13th salary bonus
• Lunch allowance to fuel your productivity
• Engaging company culture with fun activities
• Global collaboration – Work with both Vietnamese and international colleagues