contract data engineer (MSSQL, SSIS) #IAC

Recruit Express Pte Ltd; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

Recruit Express Pte Ltd is seeking an experienced Database Engineer / Data Integration Specialist to design, develop, and maintain SQL Server databases and data solutions. You will develop, enhance and support SSIS packages for ETL, and build reliable processes across multiple systems.

The role requires strong SQL/T-SQL knowledge, expertise in ETL design, data quality controls, and production incident management.

Qualifications

• 7+ years of experience in database development or data integration.
• Hands-on experience with Microsoft SQL Server and SSIS.
• Strong SQL and T-SQL knowledge, including procedures, functions, views.
• Experience with ETL design, data quality, and data reconciliation.
• Experience in production environments and incident management.

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 scheduled jobs, interfaces and data-processing activities.
• Investigate and resolve data-quality, reconciliation and production issues.
• Ensure security, access-control and change-management standards.
• Provide technical guidance to junior team members.
• Support data migration, system integration and reporting initiatives.
• Maintain documentation and data mappings.
• Coordinate with application, infrastructure, security and vendor teams.

Skills

Microsoft SQL Server

SSIS

SQL / T-SQL

ETL design

Data integration

Query optimisation

Database performance tuning

Data quality controls

Root-cause analysis

Production incident management

Tools

SQL Server Agent

Job description

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.
• Any other ad-hoc duties as assigned by supervisor.

Required Skills and Qualifications:

• At least 7 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.