Data Analyst & BI Automation Specialist

DQP SERVICE PTE. LTD.; Singapore; Hybrid; SGD 60,000 - 80,000; Full time

Job summary

An international trading company in the automotive spare parts sector seeks a Data Analyst & BI Automation Specialist. The role involves transforming data into insights, managing automation, and building Power BI dashboards to support decision-making. Candidates should have 2-3 years of experience, strong Excel skills, and familiarity with automation tools. The position offers a hybrid work option and exposure to international operations.

Benefits

Hybrid work option

Flexible schedule

Supportive multicultural environment

Qualifications

• 2-3 years of experience in data analysis, reporting, or BI automation.
• Strong command of Microsoft Excel (Power Query, Pivot Tables, VBA).
• Experience with Power BI (DAX, visuals, data modeling).
• Familiarity with automation tools (Power Automate, Python, Google Apps Script).
• Analytical mindset with attention to detail.
• Good communication skills for non-technical users.

Responsibilities

• Collect, organize, and consolidate data from ERP, CRM, and Excel.
• Build and maintain Power BI dashboards and automated reports.
• Support management with data insights and analyses.
• Automate repetitive data tasks using various tools.
• Ensure data accuracy and consistency across systems.
• Provide clear data visualizations for teams.
• Identify improvements and implement automation solutions.

Skills

Data analysis

Automation

Power BI

Excel (Power Query, Pivot Tables, VBA)

Communication skills

Attention to detail

Tools

Power BI

Power Automate

Python

SQL

Job description

Job Description

We are an international trading company in the automotive spare parts sector, looking for a Data Analyst & BI Automation Specialist to help us transform data into smart business insights.
The role involves managing, automating, and visualizing data from different company sources to support our Commercial Director and management team in faster and more informed decision-making.

If you are passionate about data analysis, automation, and dashboards — and want to make a real impact in a growing international environment — this role is for you.

Key Responsibilities

• Collect, organize, and consolidate business data from ERP, CRM, and Excel sources
• Build and maintain Power BI dashboards and automated reports
• Support the Commercial Director with data insights, cross-checks, and performance analyses
• Automate repetitive data tasks (Excel macros, Power Automate, Python scripts, etc.)
• Ensure data accuracy and consistency across multiple systems
• Provide clear data visualizations for management and sales teams
• Identify process improvements and implement data-driven automation solutions

Requirements

• Minimum 2–3 years of experience in data analysis, reporting, or BI automation
• Strong command of Microsoft Excel (Power Query, Pivot Tables, VBA)
• Hands‑on experience with Power BI (DAX, visuals, data modeling)
• Familiarity with automation tools (Power Automate, Python, or Google Apps Script)
• Analytical mindset with attention to detail and accuracy
• Good communication skills; able to present insights clearly to non‑technical users
• Knowledge of SQL or ETL processes is an advantage
• Singaporean / permanent residency card

What We Offer

• Opportunity to design and implement the company’s data automation ecosystem
• Direct collaboration with management on commercial and strategic decisions
• Exposure to international trading operations and business analytics
• Hybrid work option and flexible schedule
• Supportive, multicultural environment