Data Engineer

Techstreet Malaysia; Kuala Lumpur; On-site; MYR 90,000 - 140,000; Full time

Job summary

Techstreet Malaysia is seeking a Data Engineer to design, develop, and support enterprise reporting using SSRS and SQL Server technologies. The role includes ETL development with SSIS, report automation, and data integration to deliver accurate, timely reports for operations, management, and regulatory needs.

You will work closely with business users and application teams to ensure data accuracy, report performance, and system reliability, while managing multiple reporting requests efficiently.

Qualifications

• Bachelor’s degree in CS/IT/SE or related field.
• 3–5 years of experience with Microsoft SQL Server technologies.
• Experience supporting production reporting environments.
• Advanced T-SQL and stored procedures knowledge.
• Experience with SSIS.
• Strong analytical and troubleshooting skills.
• Excellent stakeholder engagement and requirement gathering abilities.

Responsibilities

• Design, develop, deploy, and maintain SSRS reports.
• Translate business requirements into functional and 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.
• Collaborate with stakeholders to gather reporting requirements.
• Ensure report accuracy, consistency, and timely delivery.
• Develop and maintain SQL Server database objects including stored procedures, functions, views, and triggers.
• Create and optimise T-SQL scripts to support reporting and integration.
• Develop and maintain ETL processes using SSIS.

Skills

SSRS

SQL Server

ETL

T-SQL

SSIS

Stored Procedures

Views & Triggers

Data analysis

Reporting

Education

Bachelor's degree in CS/IT/SE/Data Eng

Tools

SSRS

SQL Server

SSIS

Job description

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.

Key responsibilities

• 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.
• Develop and maintain Microsoft SQL Server database objects including Stored Procedures, Functions, Views, and Triggers.
• Create and optimise T-SQL scripts to support reporting and integration requirements.
• Develop and maintain ETL processes using SQL Server Integration Services (SSIS).

About you

• 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.
• Advanced T-SQL and Stored Procedures knowledge.
• Experience with SQL Server Integration Services (SSIS).
• Strong analytical and troubleshooting skills.
• Excellent stakeholder engagement and requirement gathering skills.
• Strong report-writing and documentation capabilities.
• Ability to manage multiple reporting requests and priorities.