Program Analyst – SQL & Reporting

Advanced Manufacturing Corp (Penang); Seberang Perai; On-site; MYR 60,000 - 85,000; Full time

Job summary

A leading manufacturing company in Seberang Perai, Malaysia is seeking a Reporting Analyst to develop and optimize reports for SAP ERP and in-house software. The successful candidate will have expert-level SQL skills and 5–7 years of relevant experience in reporting and data analysis. Responsibilities include designing SQL queries, providing support for SAP modules, and collaborating with business users to translate reporting needs into technical solutions.

Qualifications

• 5–7 years of experience in reporting, data analysis, or ERP support.
• Expert-level SQL skills for writing, debugging, and optimizing complex queries.
• Strong experience with reporting tools like SSRS or similar.

Responsibilities

• Develop, maintain, and optimize reports for SAP ERP and in-house software.
• Design SQL queries to meet business requirements.
• Provide functional support for SAP ERP and related systems.

Skills

SQL skills

Reporting tools (SSRS, Crystal Reports)

Data analysis with Excel

Analytical skills

Problem-solving skills

Education

Bachelor's Degree in Computer Science or related field

Tools

SAP ERP

SQL Server

Excel

Job description

Responsibilities

• Develop, maintain, and optimize reports for both SAP ERP and in-house software solutions.
• Design and implement SQL Server queries, stored procedures, and reports (T-SQL, SSRS, SSMS) to meet business and user requirements.
• Provide functional support and troubleshooting for SAP ERP (MM/PP modules) and related business systems.
• Extract, analyze, and validate data using SQL and Excel to support decision-making across departments.
• Collaborate with business users to translate reporting needs into efficient technical solutions.
• Support data migration and integration activities between SAP and in-house systems.
• Create ad-hoc reports and dashboards, ensuring accuracy, timeliness, and usability.

Requirements

• Bachelor's Degree in Computer Science, Information Systems, or related field.
• 5–7 years of professional experience in reporting, data analysis, or ERP support.
• Expert-level SQL skills: proven ability to write, debug, and optimize complex queries and stored procedures in Microsoft SQL Server.
• Strong experience with reporting tools such as SSRS, Crystal Reports, or similar.
• Solid understanding of Excel for data analysis (pivot tables, formulas, charts, Power Query).
• Working knowledge of SAP MM and PP modules, including Master Data (Material Master, BOM, Routing).
• Familiarity with logical and physical data modeling concepts.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to work independently while collaborating effectively with IT teams and business stakeholders.