Scicom MSC Berhad

Data Analyst

Scicom MSC Berhad Kuala Lumpur, Kuala Lumpur, Malaysia · MYR 84K–MYR 180K/yr

Outsourcing and Offshoring Consulting · 1,001-5,000 employees

7 h ago
data-analyst Mid (2-5 yrs) Full-time Malaysia
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The role involves designing, developing, and maintaining SQL Server databases and ETL processes using SSIS. You will also be responsible for optimizing SQL logic, performing data modeling, and supporting system deployment activities.

What they look for

SQL Server SSIS ETL Data modeling Stored procedures Database design Performance tuning Data analysis Troubleshooting Problem-solving Data warehouse BI Technical communication

Requirements

Candidates must hold a bachelor's degree or higher in a relevant field and possess at least 3 years of SQL Server development experience. Strong proficiency in SSIS, ETL development, and complex SQL scripting is required.

Benefits

Performance related bonus Annual leave Medical leave Medical and hospitalization coverage

Full description

Job Responsibilities

  • Responsible for SQL Server database design, development, testing and performance tuning.
  • Develop and maintain ETL processes using SSIS for data extraction, transformation and loading.
  • Develop complex SQL scripts, including stored procedures, functions and triggers.
  • Optimize existing SQL logic to improve query performance and system stability.
  • Conduct data requirement analysis and translate business requirements into technical solutions.
  • Perform data modelling, development and implementation.
  • Support system deployment and go-live activities.
  • Communicate with business teams and overseas teams to ensure accurate delivery of technical requirements.
  • Participate in data warehouse and BI-related projects where required.

Qualifications

  • Bachelor’s Degree or above in Computer Science, Software Engineering, Information Technology or a related field.
  • Minimum 3 years of SQL Server development experience.
  • Strong proficiency in Microsoft SQL Server.
  • Hands-on experience with SSIS and ETL development.
  • Strong ability to write and optimize complex SQL logic.
  • Experience with stored procedures, functions and triggers.
  • Experience in data warehouse or BI projects is preferred.
  • Experience participating in at least 2 complete data-related projects.
  • Strong data analysis, troubleshooting and problem-solving skills.
  • Good written and spoken communication skills in Chinese and English.
  • Able to conduct basic technical communication in English.
  • Strong sense of responsibility with good teamwork and communication skills.

 

The Package: 

  • Attractive Salary (RM7,000 – RM15,000).
  • Performance related bonus for confirmed staff.
  • Annual Leave 15 days.
  • Medical Leave 14 days.
  • Medical and hospitalization coverage.

Similar roles