Business Intelligence Analyst

LEE YIN APPAREL INTERNATIONAL PTE. LTD.; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

LEE YIN APPAREL INTERNATIONAL PTE. LTD. seeks a Business Intelligence Analyst to design and automate cross-department reporting using AI tools like Claude, Power BI, and SQL. The role sits as a strategic analytics counterpart to the systems developer and reports to the Chief of Staff.

You will build self-refreshing dashboards, define metrics with department heads, and scale an analytics workflow that reduces manual querying while guiding factory strategy with data-driven insights.

Qualifications

• 0-4 years in a business analyst, data analyst, or BI-related role.
• Demonstrated hands-on use of AI tools (ChatGPT, Claude, Copilot, or similar).
• Working knowledge of Power BI or equivalent BI tool.
• Basic to intermediate SQL for querying relational data.
• Experience with Smartsheet & Smartsuite is a plus.
• Exposure to ERP systems (SAGE X3 or equivalent) as a data source is a plus.

Responsibilities

• Departmental reporting design & automation with metrics driving decisions.
• Build automated, self-refreshing dashboards and reports using Power BI or Smartsheet.
• Prioritize leading indicators over lagging ones where possible.
• Use Claude and similar tools to query factory data in natural language.
• Translate queries into structured reports and scalable workflows.
• Act as the analytics layer translating factory strategy into a reporting roadmap.
• Educate users and coordinate with HQ IT on reporting pipelines.

Skills

Power BI

SQL

AI tools

Data analysis

Education

Bachelor's degree in related field

Tools

Smartsheet

Smartsuite

SAGE X3

Claude

Job description

Role Description：

This role as a Business Intelligence Analyst builds and automates reporting across departments using AI tools (Claude, Power BI, SQL). Positioned as an analytical/strategic counterpart to the existing systems developer. Reports directly to the Chief of Staff, reflecting that this is a strategic analytics function.

Responsibilities：

• Departmental reporting design & automation
  • Work with department heads to define the metrics that actually drive decisions, not just metrics that are easy to pull
  • Build automated, self-refreshing dashboards and reports (Power BI, Smartsheet, or equivalent) that reduce manual data compilation
  • Prioritize leading indicators over lagging ones where possible
• AI-assisted analytics
  • Use Claude and similar tools to query factory data (Marvel, SAGE, SJOnline, Power BI) in natural language and translate that into structured reports
  • Build repeatable prompt/workflow patterns so reporting isn't dependent on one person's manual query-writing
  • Pilot and scale "ask a question, get an answer" style analytics for non-technical department heads
• Systems literacy, not systems ownership
  • Enough SQL/data-model understanding of SAGE X3, Marvel (MES), and SJ
  • Online to know where a number actually comes from, without being the ERP administrator
  • Flag data quality and definitional issues at the source rather than patching them downstream in reports
• Strategic analytics layer
  • Act as the thinking layer above the existing systems developer - translating factory strategy and department needs into a reporting roadmap, rather than building point-solutions on request
  • Bring structure to what's currently ad hoc: which reports exist, which are used, which should be retired or consolidated
• Continuous improvement & standards
  • Evaluate existing reports and dashboards for redundancy, ambiguity, or low usage
  • Establish lightweight standards for how new report requests are scoped, built, and handed over
• Cross-functional coordination
  • Educate department users on how to read and use dashboards, not just how to request them
  • Coordinate with HQ IT and the systems developer on changes affecting reporting pipelines

Requirements：

• 0-4 years in a business analyst, data analyst, or BI-related role. Fresh graduates are welcome to apply.
• Demonstrated hands-on use of AI tools (ChatGPT, Claude, Copilot, or similar) for analytical or reporting work
• Working knowledge of Power BI or equivalent BI tool.
• Basic to intermediate SQL - enough to understand and query relational data structures.
• Experience with Smartsheet & Smartsuite is a plus.
• Exposure to ERP systems (SAGE X3 or equivalent) as a data source is a plus.