Data Engineer – SSRS / MSSQL

• Develop, maintain, and enhance SSRS reports, including paginated and parameterised reports.

• Manage report subscriptions, scheduling, datasets, and data sources.

• Troubleshoot reporting issues and optimise report performance.

• Develop and maintain advanced T-SQL scripts, stored procedures, functions, views, and triggers.

• Support SQL Server Agent jobs, database operations, and query performance tuning.

• Develop, deploy, and troubleshoot SSIS packages for ETL, data migration, and transformation.

• Support system integrations, data mapping, reconciliation, file-based interfaces, and batch processing.

• Automate operational tasks using PowerShell and Python scripting.

• Manage secure file transfers using SSH/SFTP and perform PGP/GPG encryption and decryption.

• Provide production support and resolve reporting and integration incidents within agreed timelines.

• Collaborate with business stakeholders to understand reporting requirements and deliver accurate business and regulatory reports.

• Maintain data integrity, reporting reliability, and operational efficiency.

Educational Qualifications

• Bachelor's degree in Computer Science, Information Technology, Software Engineering, Data Engineering, or a related discipline.

Required Experience

• 3–5 years of experience working with Microsoft SQL Server technologies.

• Strong hands-on experience in SSRS report development and maintenance.

• Practical experience supporting production reporting environments.

• Experience with MSSQL scripting, stored procedures, SSIS, and SQL Server Agent.

• Familiarity with PowerShell, Python scripting, SSH/SFTP file transfers, and PGP/GPG encryption and decryption.

• Banking or financial services experience is preferred.

Technical Skills

• SQL Server Reporting Services (SSRS)

• Microsoft SQL Server (MSSQL) and Advanced T-SQL

• Stored Procedures, Functions, Views, and Triggers

• SQL Server Integration Services (SSIS)

• SQL Server Agent and ETL processes

• PowerShell and Python scripting

• SSH/SFTP file transfer

• PGP/GPG encryption and decryption

• MSSQL administration and query optimisation

• System integration and production support

Preferred Skills

• Power BI

• Data Warehouse (DWH) concepts

• Azure Data Factory

• Azure SQL Database

• Banking and financial reporting systems

Key Success Indicators

• Timely delivery of business and regulatory reports.

• High reporting accuracy and data integrity.

• Improved report performance and user satisfaction.

• Stable ETL workflows and system integration processes.

• Efficient incident resolution and reliable production operations.

Ideal Candidate Profile

The ideal candidate is a technically strong Data Engineer with intermediate-level SSRS, MSSQL, and SSIS expertise, along with practical experience in system integration, automation, secure file transfers, and production support. The candidate should be comfortable working in an enterprise environment, with banking or financial services exposure considered an advantage.

Important: This position is open to local Malaysian candidates only.