SQL data server reporting and data engineer
Job Description
Job Title: SQL Server Reporting & Data Engineer
Location: Kuala Lumpur, Malaysia
Salary Range: RM 4,000 – RM 6,000 per month
Eligibility: Local Malaysians Only
Experience: 3–5 Years
Education: Bachelor's Degree in Computer Science, Information Technology, Software Engineering, Data Engineering, or a related field.
Job Description
We are looking for an experienced SQL Server Reporting & Data Engineer with strong expertise in Microsoft SQL Server technologies, particularly SQL Server Reporting Services (SSRS). The ideal candidate will be responsible for developing, maintaining, and optimising reports, supporting production reporting environments, managing ETL processes, and ensuring reliable system integration and data delivery.
The candidate should have hands-on experience with MSSQL, in SSRS, SSIS, PowerShell automation, SFTP file transfers, and PGP/GPG encryption and decryption. Banking or financial services experience is an advantage.
Key Responsibilities
- Develop, maintain, and enhance SSRS reports, including paginated and parameterised reports.
- Manage report subscriptions, scheduling, datasets, and data sources.
- Optimise report performance and troubleshoot reporting issues.
- Analyse business requirements and translate them into reporting solutions.
- Develop and maintain advanced T-SQL scripts, stored procedures, functions, views, and triggers.
- Perform SQL query optimisation and tuning.
- Support SQL Server Agent jobs and database administration activities.
- Develop, deploy, schedule, and troubleshoot SSIS ETL packages.
- Handle data migration, transformation, and reconciliation.
- Support system integration, file-based interfaces, and batch processing.
- Automate operational tasks using PowerShell and Python scripting.
- Manage SSH/SFTP file transfers and PGP/GPG encryption and decryption.
- Provide production support and resolve reporting and integration incidents.
- Ensure timely delivery, accuracy, and integrity of business and regulatory reports.
Required Qualifications
- Bachelor's Degree in Computer Science, Information Technology, Software Engineering, Data Engineering, or a related discipline.
- Minimum of 3–5 years of experience working with 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
- Microsoft SQL Server (MSSQL)
- T-SQL Scripting
- Stored Procedures
- SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- SQL Server Agent
- PowerShell Scripting
- Python Scripting
- SSH/SFTP File Transfers
- PGP/GPG Encryption and Decryption
- MSSQL Administration
Technical Competencies
1. SQL Server Reporting Services (SSRS) – Intermediate (Primary Skill)
- Report development and maintenance.
- Paginated and parameterised reports.
- Report subscriptions and scheduling.
- Dataset and data source management.
- Report performance optimisation.
- Troubleshooting and report design.
2. Microsoft SQL Server (MSSQL) – Intermediate
- Advanced T-SQL.
- Stored procedures, functions, views, and triggers.
- Query optimisation and tuning.
- SQL Server Agent job support.
3. SQL Server Integration Services (SSIS) – Intermediate
- ETL package development.
- Data migration and transformation.
- Package deployment and troubleshooting.
- Scheduling and automation.
4. 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 system integration processes.
- Efficient incident resolution and production support.
Ideal Candidate Profile
A reporting-focused Data Engineer with strong SSRS development experience, solid MSSQL and SSIS capabilities, and practical exposure to system integration, PowerShell automation, SFTP file transfers, and PGP/GPG encryption. The ideal candidate must be capable of supporting both project delivery and production operations within a banking or enterprise environment.
Job Location: Kuala Lumpur, Malaysia
Monthly Salary: RM 4,000 – RM 6,000
Important: This opportunity is open to local Malaysian candidates only.
Key Skills
3 SkillsRole Specifications
Similar Jobs
Customer Service Specialist
Customer Service Specialist - Taiwanese (Native)
Business Development / Project Sales Executive (Electrical Products)
Software Developer (Full Stack) – Java & Angular
Data Engineer
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