Data Engineer - MS SQL, SSIS

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

Required Skills and Qualifications

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

Interested applicants, please email your resume to Lisa (Lisha) Zhang

Email: [email protected]

CEI Reg No: R25157448

EA Licence No: 99C4599

Recruit Express Pte Ltd