Data Analyst – Business Intelligence & Audit Automation
Join us as Data Analyst to build Power BI insights and automate audit testing, helping strengthen controls and support smarter decisions across our global teams.
GENERAL JOB DESCRIPTION
ECOM Agroindustrial Corp. (ECOM) is a leading global commodity merchant and sustainable supply chain management company, headquartered in Switzerland.
The Data Analyst will be part of ECOM’s Audit and Advisory Services Department (AASD) and will provide technical and analytical support to the Internal Audit team conducting audits throughout the Group. The position will be based in ECOM’s Vietnam office (Atlantic Commodities Vietnam Ltd.). This role focuses on:
• Developing Power BI dashboards and data visualization solutions to support audit reporting, monitoring and decision-making.
• Transforming and analyzing data from multiple systems to identify trends, anomalies, risk indicators and potential control weaknesses.
• Leveraging AI tools and automation technologies to design and implement repeatable automated audit tests and Computer-Assisted Audit Techniques (CAATs).
KEY RESPONSIBILITIES
Power BI Reporting & Data Visualization
• Design, develop and maintain Power BI dashboards and reports for audit performance monitoring, management reporting and data-driven insights.
• Develop and optimize data models, relationships, DAX measures and visualizations to present complex information clearly and accurately.
• Ensure the accuracy, integrity, consistency and timely refresh of dashboard in audit reporting.
• Improve report accuracy, performance and ease of use.
Data Extraction, Transformation & Analysis
• Extract, consolidate, clean, transform and validate data from ERP systems, databases, Excel files and other business applications.
• Perform data completeness and integrity checks, including record count, missing data identification, duplicate detection to ensure data accuracy and completeness.
• Develop and maintain data transformation workflows using Power Query (M), SQL and other appropriate tools.
• Prepare reusable datasets and analytical procedures to support recurring audit engagements and broader audit coverage.
AI-enabled Audit Automation & CAATs
• Translate audit objectives, risks and control requirements into automated testing rules, scripts and analytical procedures.
• Develop and maintain automated audit tests using suitable technologies such as Python, SQL, Power Automate and AI-assisted tools.
• Explore AI-enabled solutions to support anomaly detection, transaction analysis, document review and other audit activities.
Collaboration & Continuous Improvement
• Document testing logic, assumptions, exceptions and limitations to ensure automated procedures are transparent, traceable and repeatable.
• Maintain technical documentation and provide user guidance & training materials to audit team members on Power BI, data analytics and automated testing solutions.
• Work closely with internal auditors to understand business processes and identify opportunities to apply data analytics and automation.
• Perform data validation and User Acceptance Testing (UAT).
WORK EXPERIENCE REQUIREMENTS AND QUALIFICATIONS
• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Business Analytics or a related field.
• Typically 2–5 years of experience in data analytics, business intelligence, data transformation or automation roles.
• Strong hands-on proficiency in Power BI, including dashboard development, data modelling, DAX and Power Query (M).
• Good SQL skills and experience extracting, transforming, validating and analyzing data from multiple sources.
• Practical experience with Python, workflow automation or AI tools (e.g. Microsoft Copilot or similar) is preferred.
• Experience in internal audit, accounting, finance, risk management or working with ERP systems is an advantage.
• Good oral and written English required. Additional language skills are a plus.
• Strong analytical and critical-thinking skills, attention to detail and problem-solving ability. A proactive, can-do attitude, willingness to learn and ability to explain technical concepts to non-technical stakeholders.
- Department
- Internal Audit
- Location
- Ho Chi Minh City, Vietnam