Data Engineer

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 providing Digital technology & Cloud transformation services, Application & Infrastructure Management Services, Unified Communications, and Insurance implementation services to its customers in the Americas, Europe, Middle East, and Asia-Pacific. Smart IMS, a Microsoft Gold Certified Partner, Oracle Platinum Partner, AWS MSP Partner is a trusted technology and business partner delivering technology-enabled solutions to help companies grow their businesses and compete globally.

JOB DESCRIPTION

We are looking for an experienced and hands-on Senior Data Engineer with strong expertise in Microsoft SQL Server and SQL Server Integration Services (SSIS).

You will be responsible for designing, developing and supporting data integration solutions, databases, ETL processes and management reporting platforms. The role requires strong technical skills, problem-solving ability and experience working with business and technology stakeholders.

Key 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.

Required Skills and Qualifications:

• At least 6 years of relevant experience in database development, data engineering or data integration.
• Strong hands-on experience with Microsoft SQL Server.
• Strong hands-on experience developing and supporting SSIS packages.
• Advanced knowledge of SQL and T-SQL.
• Experience with stored procedures, functions, views, triggers and SQL Server Agent jobs.
• Strong understanding of ETL design and data-integration principles.
• Experience with query optimisation, indexing and database performance tuning.
• Experience handling large data volumes and complex data transformations.
• Experience troubleshooting failed jobs, data issues and production incidents.Good understanding of data quality, reconciliation and validation controls.
• Experience working across development, testing and production environments.
• Strong analytical and problem-solving skills.
• Good written and verbal communication skills.
• Ability to work independently and manage multiple priorities