Senior Data Engineer - SQL Server & SSIS ETL Expert

Smart IMS Inc.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

Smart IMS Inc is seeking a Senior Data Engineer in Singapore to design, develop and maintain SQL Server databases and ETL pipelines. You will build and optimise SSIS packages, manage data integration across multiple source and target systems, and collaborate with business users to fulfill reporting requirements.

The role requires strong SQL/T-SQL skills, experience with data quality controls, and the ability to work with stakeholders across development, testing and production environments.

Qualifications

• 6+ years in database development, data engineering or data integration.
• Strong hands-on experience with Microsoft SQL Server and SSIS.
• Experience with advanced SQL, stored procedures, functions, views and triggers.

Responsibilities

• Design, develop and maintain SQL Server databases and data solutions.
• Develop, enhance and support SSIS packages for ETL.
• Build reliable ETL processes across multiple source and target systems.
• Write and optimise complex SQL queries, stored procedures, functions and views.
• Monitor data-processing activities and troubleshoot data issues.
• Coordinate with cross-functional teams to ensure data quality and reporting needs.

Skills

Analytical skills

Problem solving

Communication skills

Independent worker

Tools

Microsoft SQL Server

SSIS

T-SQL

SQL Server Agent

Data modeling

Job description

Smart IMS Inc is seeking a Senior Data Engineer in Singapore to design, develop and maintain SQL Server databases and ETL pipelines. You will build and optimise SSIS packages, manage data integration across multiple source and target systems, and collaborate with business users to fulfill reporting requirements.

The role requires strong SQL/T-SQL skills, experience with data quality controls, and the ability to work with stakeholders across development, testing and production environments.