SQL Server ETL & Data Warehouse Specialist

北京汉克时代科技有限公司; Kuala Lumpur; On-site; MYR 89,000 - 156,000; Full time

Benefits offered by this job

Insurance

Leave policy

Overtime compensation

Job summary

The SQL Server ETL & Data Warehouse Developer role focuses on designing, building, and tuning SQL Server databases to support data warehouse initiatives. You will develop ETL processes with SSIS, write complex SQL scripts, and optimize existing logic for performance and stability.

You will independently analyze data needs, design models, implement solutions, and support go-live, while communicating with business and overseas teams.

Qualifications

• 3+ years of SQL Server development experience.
• Full data warehouse or BI project experience preferred.
• Bachelor's degree or above in Computer Science, Software Engineering, IT, or related fields.

Responsibilities

• Design, develop, test, and tune SQL Server databases for performance.
• Develop and maintain ETL processes using SSIS for data extraction, transformation, and loading.
• Write efficient and maintainable complex SQL scripts, including stored procedures, functions, and triggers.
• Optimize existing SQL logic to improve query performance and system stability.
• Complete data requirement analysis, model design, development implementation, and go-live support independently.
• Communicate technically with business teams and overseas teams to ensure accurate requirement delivery.

Skills

SQL performance tuning

Communication

Teamwork

Education

Bachelor's degree in Computer Science or related

Tools

SQL Server

SSIS

Stored procedures

Functions

Triggers

Job description

The SQL Server ETL & Data Warehouse Developer role focuses on designing, building, and tuning SQL Server databases to support data warehouse initiatives. You will develop ETL processes with SSIS, write complex SQL scripts, and optimize existing logic for performance and stability.

You will independently analyze data needs, design models, implement solutions, and support go-live, while communicating with business and overseas teams.