Data Engineer (MSSQL, SSRS)

amIT Global Solutions; Kuala Lumpur; On-site; MYR 90,000 - 130,000; Full time

Job summary

amIT Global Solutions is seeking a Data Engineer to design, develop, and support enterprise reporting solutions using SSRS and SQL Server technologies. You will enhance ETL processes, system integrations, and secure file transfer solutions while delivering accurate, timely reports.

You will collaborate with business users and application teams to ensure data quality, report performance, and reliability across operational, management, regulatory, and analytical reporting needs.

Qualifications

• Bachelor's Degree in Computer Science, Information Technology, Software Engineering, Data Engineering, or related disciplines.
• 3–5 years of experience in Microsoft SQL Server technologies.
• Experience supporting production reporting environments.
• Banking or financial services experience is an advantage.

Responsibilities

• Design, develop, deploy, and maintain SSRS reports.
• Convert business requirements into functional user-friendly reports.
• Develop and optimise report datasets, parameters, subscriptions, and scheduling.
• Produce operational, management, financial, regulatory, and ad-hoc reports.
• Troubleshoot report performance and optimise data retrieval efficiency.
• Gather and analyse reporting requirements with stakeholders.
• Develop and maintain SQL Server database objects (Stored Procedures, Functions, Views, Triggers).
• Develop and maintain ETL processes using SSIS.
• Support data extraction, transformation, and loading activities.
• Develop and maintain system interfaces and integration processes.
• Perform data validation and reconciliation across source and target systems.
• Support automated file transfers and encryption processes.

Skills

SSRS

SSIS

T-SQL

SQL Server

ETL

Data Validation

Reporting

Education

Bachelor's Degree in CS/IT/SE/Data Engineering

Tools

SQL Server

PowerShell

Data Integration

Job description

Jora Malaysia will close on 9th September 2026. Thank you for being with us, we are cheering you on as you continue your career journey.

The Data Engineer is primarily responsible for the design, development, enhancement, and support of enterprise reporting solutions using SQL Server Reporting Services (SSRS).

The role will also support Microsoft SQL Server database development, ETL processes, system integrations, reporting automation, and secure file transfer solutions.

The successful candidate will work closely with business users and application teams to deliver operational, management, regulatory, and analytical reports while ensuring data accuracy, report performance, and system reliability.

Qualifications:

• Bachelor's Degree in Computer Science, Information Technology, Software Engineering, Data Engineering, or related disciplines.
• Minimum 3 to 5 years of experience in Microsoft SQL Server technologies.
• Experience supporting production reporting environments.
• Banking or financial services experience is an advantage.

Key Responsibilities

• Reporting Solutions Development (Primary Responsibility)
• Design, develop, deploy, and maintain reports using SQL Server Reporting Services (SSRS).
• Convert business requirements into functional and user-friendly reports.
• Develop and optimise report datasets, parameters, subscriptions, and report scheduling.
• Produce operational, management, financial, regulatory, and ad-hoc reports.
• Troubleshoot report performance and optimise data retrieval efficiency.
• Work directly with stakeholders to gather and analyse reporting requirements.
• Ensure report accuracy, consistency, and timely delivery. Database Development & Support

Develop and maintain Microsoft SQL Server database objects including:

• Stored Procedures
• Functions
• Views
• Triggers
• Create and optimise T-SQL scripts to support reporting and integration requirements.
• Perform query analysis and performance tuning.
Support production database troubleshooting and issue resolution.
• Monitor and support SQL Server Agent jobs.
• ETL & Data Integration
• Develop and maintain ETL processes using SQL Server Integration Services (SSIS).
• Support data extraction, transformation, and loading activities.
• Develop and maintain system interfaces and integration processes.
• Perform data validation and reconciliation across source and target systems.
• Troubleshoot integration and data transfer issues. Automation, Secure File Transfer & Encryption
• Develop operational and monitoring scripts using PowerShell.
• Support automated file transfers via SSH/SFTP.
• Support data encryption and decryption processes using PGP/GPG.
• Automate reporting and file processing activities.
• Monitor and support batch processing activities.

Production Support

• Provide Level 2 and Level 3 support for reporting, database, and integration-related incidents.
• Perform root cause analysis and implement permanent fixes.
• Support deployment, change management, and disaster recovery activities.
• Ensure adherence to service level agreements (SLAs).