IT Support Specialist

Kotra Pharma (M) Sdn Bhd (Sales & Marketing Office); Kuala Lumpur; On-site; MYR 78,000 - 134,000; Full time

Job summary

Kotra Pharma (M) Sdn. Bhd. (KPM) is seeking a pivotal IT member to own sales data, turning raw data into actionable insights and ensuring the reliability of our sales database systems.

Your work will empower the sales team with accurate, timely reports and dashboards. In this role, you will design and maintain daily and monthly sales reports using Power Query, SSRS, or Excel; perform SQL Server maintenance; and automate report generation.

Qualifications

• Design, develop, and maintain daily and monthly sales reports, dashboards, and KPIs.
• Extract, transform, and analyse sales data from CRM, ERP, and other systems.
• Validate data accuracy and automate report distribution to stakeholders.
• Maintain SQL Server databases and optimize queries for reporting.

Responsibilities

• Design, develop, and maintain daily and monthly sales reports, dashboards, and KPIs using SSRS, Power Query, or Excel.
• Extract, transform, and analyse sales data from CRM, ERP, and other systems.
• Automate report generation and distribution to stakeholders.
• Perform SQL Server maintenance, backups, indexing, and performance tuning.
• Develop and optimize complex SQL queries and procedures for reporting.

Skills

SQL

Communication

Analytical thinking

Troubleshooting

Adaptability

Teamwork

Education

Bachelor's degree in Computer Science / IS

Tools

SSRS

Power BI

Tableau

SQL Server

MySQL

Oracle

Salesforce

Job description

As a pivotal member of our IT team, you will be the primary owner of all sales data, responsible for transforming raw data into actionable insights and ensuring the reliability of our sales database systems. Your work will directly empower the sales team with accurate, timely reports and dashboards, while your DBA skills will maintain the integrity and performance of our critical data infrastructure.

Job Responsibilities:

Design, develop, and maintaindaily and monthlysales reports, dashboards, and KPIs using tools such as Power Query, SSRS, or Excel.

Extract, transform, and analyse sales data from CRM, ERP, and other business systems.

Implement and manage rigorous validation processes to ensure data accuracy, consistency, and integrity across all reports.

Automate report generation and distribution to stakeholders.

Database Administration (Intermediate DBA)

Perform SQL Server database maintenance, including backups, indexing, and performance tuning.

Develop and optimize complex SQL queries, stored procedures, and functions for reporting and data extraction.

Proactively monitor, troubleshoot, and resolve database-related issues.

Process Improvement & Automation

Identify opportunities to streamline sales reporting and data processes.

Develop scripts or workflows to automate repetitive tasks.

Adapt quickly to fast changes in the business and sales force structureto ensure reporting remains accurate and relevant.

Work with sales operations to enhance data collection and reporting efficiency.

Provide technical support and troubleshooting for sales applications (e.g., CRM, CPQ).

Assist in user access management, basic configuration, and data integration between systems.

Job Requirements:

Technical Skills:

Strong proficiency in SQL (complex queries, stored procedures, performance tuning).

Proven experience withSSRS (SQL Server Reporting Services). Experience withPower BI or Tableau is a strong plus.

Hands‑on experience withSQL Server database administrationtasks: backups, restores, index management, and performance monitoring. Experience with other RDBMS (e.g., MySQL, Oracle) is beneficial.

Knowledge of ETL processes and data integration.

Familiarity with CRM systems (Salesforce preferred).

Basic scripting skills (Python, PowerShell, VBA) are advantages.

Soft Skills & Experience:

Excellent communication and collaboration skills, with the ability to partner effectively with both technical teams and non-technical business stakeholders (the sales team).

Stronganalytical and problem-solving abilities.

Proven ability totroubleshoot issues, identify the root cause, and provide long-term solutions.

Must be specific and diligent about sales data accuracy and integrity.

• Ability to adapt quickly to a dynamic, fast-changing sales environment.
• A proactive, challenge-seeking team player who can manage multiple priorities effectively.

Preferred Qualifications:

3+ years in a combined role involving data/reporting and database management.

Experience supporting sales applications and CRM systems.

Knowledge of cloud databases (Azure SQL, AWS RDS) is a plus.

Education & Certifications:

Bachelor’s degree in Computer Science, Information Systems, or a related field.

Certifications in SQL, Power BI, Tableau, or database administration are desirable.

*Only shortlisted candidates will be notified.

Kotra Pharma (M) Sdn. Bhd. (KPM) is a wholly owned subsidiary of Kotra Industries Berhad, a company listed on the Kuala Lumpur Stock Exchange. KPM is one of Malaysia's leading pharmaceutical manufacturers.

At Kotra Pharma, we believe that everyone deserves a healthier tomorrow. It's every individual's right to live a healthy life to the fullest, and thus, we are committed to bring top-notch health products to the world. By humanising healthcare, we see beyond instruments and medicines for the general well-being of everyone.

Kotra Pharma (M) Sdn. Bhd. (KPM) is a wholly owned subsidiary of Kotra Industries Berhad, a company listed on the Kuala Lumpur Stock Exchange. KPM is one of Malaysia's leading pharmaceutical manufacturers.

At Kotra Pharma, we believe that everyone deserves a healthier tomorrow. It's every individual's right to live a healthy life to the fullest, and thus, we are committed to bring top-notch health products to the world. By humanising healthcare, we see beyond instruments and medicines for the general well-being of everyone.