Microsoft Specialist

R Systems; Kuala Lumpur; On-site; MYR 60,000 - 120,000; Full time

Job summary

R Systems in Kuala Lumpur, Malaysia, is seeking an experienced SSRS Developer to design, develop, maintain, and enhance enterprise reports using SSRS. The successful candidate will work closely with business users, application teams, and database teams to understand reporting requirements, develop reliable reporting solutions, troubleshoot issues, and support existing reports in a production environment.

Experience with SQL Server, T-SQL, and Report Builder/Visual Studio is essential, as is the

Qualifications

• Strong hands-on experience with SSRS / SQL Server Reporting Services.
• Strong Microsoft SQL Server and T-SQL skills.
• Experience developing complex SQL queries and stored procedures.
• Experience with SSRS Report Builder and/or Visual Studio/SSDT.
• Good understanding of relational databases and data structures.
• Experience with report development, testing, deployment, and production support.
• Good analytical and troubleshooting skills.

Responsibilities

• Design, develop, and maintain SSRS reports based on business and functional requirements.
• Develop complex SQL queries, stored procedures, views, and functions using T-SQL.
• Build reports with parameters, filters, grouping, sorting, drill-downs, subreports, and calculated fields.
• Develop reports using SSRS, Report Builder, and/or Visual Studio/SSDT.
• Connect SSRS reports to SQL Server databases and other data sources.
• Perform report testing, data validation, and troubleshooting to ensure accuracy and reliability.
• Analyse and resolve reporting, SQL, and data-related issues.
• Optimise SQL queries and report performance where required.
• Deploy and maintain reports in the SSRS Report Server environment.
• Support scheduled report generation and report distribution.
• Collaborate with business users to clarify requirements and translate them into reporting solutions.
• Maintain technical documentation for reports, queries, data sources, and reporting processes.

Skills

SSRS

SQL Server

T-SQL

Complex SQL queries

SSRS / Report Builder

Education

Bachelor's degree in Computer Science / IT

Tools

Visual Studio/SSDT

SSRS Report Builder

Power BI

SSIS

Job description

We are looking for an experienced SSRS Developer to design, develop, maintain, and enhance business and operational reports using Microsoft SQL Server Reporting Services (SSRS).

The successful candidate will work closely with business users, application teams, and database teams to understand reporting requirements, develop reliable reporting solutions, troubleshoot issues, and support existing reports in a production environment.

Key Responsibilities

• Design, develop, and maintain SSRS reports based on business and functional requirements.
• Develop complex SQL queries, stored procedures, views, and functions using T-SQL.
• Build reports with parameters, filters, grouping, sorting, drill-downs, subreports, and calculated fields.
• Develop reports using SQL Server Reporting Services (SSRS), Report Builder, and/or Visual Studio/SSDT.
• Connect SSRS reports to SQL Server databases and other data sources.
• Perform report testing, data validation, and troubleshooting to ensure accuracy and reliability.
• Analyse and resolve reporting, SQL, and data-related issues.
• Optimise SQL queries and report performance where required.
• Deploy and maintain reports in the SSRS Report Server environment.
• Support scheduled report generation and report distribution.
• Work with business users to clarify requirements and translate them into reporting solutions.
• Maintain technical documentation for reports, queries, data sources, and reporting processes.
• Provide production support and enhancements for existing reports.
• Collaborate with developers, database administrators, business analysts, and other technical teams.

Mandatory Skills

• Strong hands-on experience with SSRS / SQL Server Reporting Services.
• Strong Microsoft SQL Server and T-SQL skills.
• Experience developing complex SQL queries and stored procedures.
• Experience with SSRS Report Builder and/or Visual Studio/SSDT.
• Good understanding of relational databases and data structures.
• Experience with report development, testing, deployment, and production support.
• Good analytical and troubleshooting skills.

Good to Have

• Experience with Power BI.
• Knowledge of SSIS / ETL.
• Knowledge of SQL Server performance tuning.
• Experience working with large datasets and complex reporting requirements.
• Experience in enterprise or financial/insurance/banking environments.

Education

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

What We're Looking For

We are looking for someone who is hands-on with SSRS and SQL Server, understands how data flows from databases into reports, and can independently troubleshoot and enhance reporting solutions in an enterprise environment.