contract data engineer (MSSQL, SSIS) #IAC
Posted Updated
Summary
A contract data engineer in Singapore who designs and maintains Microsoft SQL Server databases, builds and supports SSIS ETL packages, optimizes queries and data pipelines, and monitors/troubleshoots production data jobs while documenting solutions and mentoring juniors.
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.
Interested applicants, please email your resume to Andre Chua Jing Ming
Email: andrechua@recruitexpress.com.sg
CEI Reg No: R1989053
EA Licence No: 99C4599
Recruit Express Pte Ltd