Senior Software Engineer (C#/SSRS, SSIS/SQL) - Banking

The Application Developer will mainly perform the development for the DataMart system and the corresponding reporting system using C#.NET, SQL Server and SSIS. You may be involved in the newly initiated BI or Data Platform projects.

Job Responsibilities

• Support system PIC to gather and analyze the business requirement for system enhancement, new system feature, fixes and new subject areas for data integration and reporting development.

• Perform impact analysis for upstream and downstream changes that affect DataMart and reporting systems.

• Design, develop and deploy programs, source codes, batch scripts, complex SQL stored procures, functions and triggers, SSIS packages or SSRS reports.

• Follow SDLC processes in delivering project or enhancement requests, create/update the SDLC documents including functional and non-functional specifications, technical design documents, test plan, test cases, release procedures, system operational documents, user manuals etc.

• Investigate and troubleshoot production issues and system problems escalated by IT Operation Team, identify the root cause, provide workaround to rectify the issue/problem, and work out the long-term solution to fix issues/problems permanently.

• Contribute to regular maintenance activities, e.g., yearly DR drill, quarterly support for server or platform software patching etc.

• Provide ad-hoc support for other IT service requests, e.g., data extraction, data alteration, extract system logic, answer to users’ inquiry about the data/logic in the system etc.

• Review vendor’s deliverable and provide constructive feedbacks for those projects engaging vendors.

Job Requirements

• Bachelor’s degree in Information Technology, Computer Science, Manage Information Science or other similar fields

• Working background in C#.NET development.

• Relevant work experience in SSIS, SSRS and SQL Server development.

• Familiar with Software Development Life Cycle (SDLC) process

• Proficient in SQL Server development, able to construct complex Stored Procedures, User-Defined Functions, Triggers etc.

• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.

• Familiar with SQL Server installation and configuration, able to analyze and fine-tune SQL Query performance.

• Experience on development using Qlik Sense, PowerBI or Tableau.

• Experience in implementing Azure Cloud.

• Excellent communication, interpersonal and presentation skills.

• Good problem-solving skill and able to multi-task in a challenging technical environment

• Good system knowledge relating to Data Warehousing, BI, and Regulatory Reporting.

• Experience in data management, data warehousing, data mart, data visualization, design and implementation.

We regret that only shortlisted candidates will be notified.

GMP Technologies (S) Pte Ltd | EA Licence: 11C3793 | Tang Lee Ling | Registration No: R1106845

This is in partnership with the Employment and Employability Institute Pte Ltd (“e2i”).

e2i is the empowering network for workers and employers seeking employment and employability solutions. e2i serves as a bridge between workers and employers, connecting with workers to offer job security through job-matching, career guidance and skills upgrading services, and partnering employers to address their manpower needs through recruitment, training, and job redesign solutions. e2i is a tripartite initiative of the National Trades Union Congress set up to support nation-wide manpower and skills upgrading initiatives.

By applying for this role, you consent to GMP Technologies (S) Pte Ltd’s PDPA and e2i’s PDPA.