SSRS Report Developer / Data Engineer (MSSQL, SSIS)
Job Description
Location: Kuala Lumpur
Experience: 3–5 Years
Qualification: Bachelor’s degree in Computer Science, Information Technology, Software Engineering, Data Engineering or a related discipline
Salary: RM 4,000 – RM 6,000
Job Description
We are hiring a reporting-focused Data Engineer in Kuala Lumpur. You should have strong SSRS development experience, solid MSSQL and SSIS skills, and practical exposure to system integration, PowerShell automation, SFTP file transfers and PGP/GPG encryption. You will support both project delivery and production operations in a banking or enterprise environment.
Roles and Responsibilities
- Develop and maintain SSRS reports, including paginated and parameterised reports
- Set up report subscriptions and scheduling
- Manage datasets and data sources
- Optimise report performance and troubleshoot reporting issues
- Analyse user requirements and design reports
- Write advanced T-SQL, stored procedures, functions, views and triggers
- Tune and optimise queries
- Support SQL Server Agent jobs
- Build, deploy and troubleshoot SSIS ETL packages, including data migration and transformation
- Support interface development, data mapping and reconciliation
- Support file-based integration and batch processing
- Automate tasks using PowerShell and Python scripts
- Handle file transfers over SSH/SFTP, and PGP/GPG encryption and decryption
- Support production reporting environments and resolve incidents efficiently
Qualifications and Requirements
Education
- Bachelor’s degree in Computer Science, Information Technology, Software Engineering, Data Engineering or a related discipline
Experience
- Minimum 3 to 5 years of experience in Microsoft SQL Server technologies
- Strong hands-on experience in SSRS report development
- Experience supporting production reporting environments
- Banking or financial services experience is an advantage
Technical skills
- MSSQL scripting (T-SQL) and stored procedures
- SSIS
- SQL Server Agent
- PowerShell
- SSH / SFTP file transfer
- PGP/GPG encryption and decryption
- MSSQL administration
- Python scripting
Technical Competencies
- SQL Server Reporting Services (SSRS), intermediate (primary skill): report development and maintenance, paginated and parameterised reports, subscriptions and scheduling, dataset and data source management, performance optimisation, troubleshooting, requirement analysis and report design
- Microsoft SQL Server (MSSQL), intermediate: advanced T-SQL, stored procedures, functions, views and triggers, query optimisation and tuning, SQL Server Agent job support
- SQL Server Integration Services (SSIS), intermediate: ETL package development, data migration and transformation, package deployment and troubleshooting, scheduling and automation
- System integration, intermediate: interface development and support, data mapping and reconciliation, file-based integration, batch processing 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 report accuracy and data integrity
- Improved report performance and user satisfaction
- Stable ETL and integration processes
- Efficient incident resolution and production support
Important Notes for Applicants
- Local Malaysians only.
Key Skills
SSRS, MSSQL, T-SQL, Stored Procedures, SSIS, ETL, SQL Server Agent, PowerShell, Python, SFTP, PGP/GPG Encryption, System Integration, Report Development, Query Optimisation, Production Support, Banking Reporting
Key Skills
10 SkillsRole Specifications
Similar Jobs
Business Development / Project Sales Executive (Electrical Products)
(Active Hiring!) Customer Service Specialist- Taiwanese (Native)
*Full Stack Developer KL RM 11000 Java Spring Angular 4+ Yrs
Banking Project Manager - Financial Services - RM 8K | Malaysia
Technical / Enterprise Sales Executive – Datacenter Solutions
Gratitude Inc is a global company with presence across APAC, Africa, and USA. We are known for our people, innovation and customer focused approach.
Interview Tips
Curated for this roleGet the Best Jobs
Right on your fingertips with instant alerts