Senior Data Engineer - SSIS/SQL ETL Specialist

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

Job summary

Smart IMS Inc. in Singapore seeks an experienced Senior Data Engineer with strong expertise in Microsoft SQL Server and SSIS to design, develop and support data integration solutions.

You will work with business and technology stakeholders to build ETL processes, optimize performance, and ensure data quality and integrity across systems. The role demands hands-on delivery, documentation, and collaboration with cross-functional teams.

Qualifications

• 7+ years of experience in database development, data engineering or data integration.
• Hands-on experience with Microsoft SQL Server and SSIS.
• Strong knowledge of SQL, T-SQL, stored procedures, functions and views.
• Experience with ETL design, data quality, reconciliation and data integrity controls.
• Ability to coordinate with multiple teams and manage priorities.

Responsibilities

• Design, develop and maintain SQL Server databases and data solutions.
• Develop, enhance and support SSIS packages for data extraction, transformation and loading.
• Build reliable ETL processes across multiple source and target systems.
• Write and optimise complex SQL queries, stored procedures, functions and views.
• Analyse and improve database and ETL performance.
• Monitor scheduled jobs, interfaces and data-processing activities.
• Investigate and resolve data-quality, reconciliation and production issues.
• Develop controls for data completeness, accuracy and integrity.
• Support data migration, system integration and reporting initiatives.
• Maintain technical documentation, data mappings and operational procedures.
• Work closely with business users to understand data and reporting requirements.
• Coordinate with application, infrastructure, security and vendor teams.
• Support production releases, incident management and root-cause analysis.
• Ensure solutions follow security, access-control and change-management standards.
• Provide technical guidance and support to junior team members.

Skills

SQL Server

SSIS

ETL design

T-SQL

Query optimisation

Data quality

Data integration

Performance tuning

Problem solving

Stored procedures

Tools

SQL Server Agent

Job description

Smart IMS Inc. in Singapore seeks an experienced Senior Data Engineer with strong expertise in Microsoft SQL Server and SSIS to design, develop and support data integration solutions.

You will work with business and technology stakeholders to build ETL processes, optimize performance, and ensure data quality and integrity across systems. The role demands hands-on delivery, documentation, and collaboration with cross-functional teams.