12 months renewable contract
Location: Changi Business Park
Developer (DataMart & Reporting Systems)
1. Purpose of the Position
The required developer will mainly perform development and L2/L3 support activities for the
DataMart system
and the corresponding reporting system using C#.NET, SQL Server, SSIS, and SSRS
2. Job Responsibilities
- Support system PIC to gather and analyze business requirements for system enhancements, new features, fixes, and new subject areas for data integration and reporting development.
- Perform impact analysis for upstream and downstream changes affecting DataMart and reporting systems.
- Design, develop, and deploy programs, source code, batch scripts, complex SQL stored procedures, functions, triggers, SSIS packages, and SSRS reports.
- Follow organizational SDLC processes to deliver projects or enhancement requests, including creating/updating SDLC documents such as: Functional and non-functional specifications, Technical design documents, Test plans and test cases, Release procedures System operational documents, User manuals
- Investigate and troubleshoot production issues and system problems escalated by the IT operations team: Identify root causes, Provide workarounds, Develop long-term solutions for permanent fixes
- Participate in regular maintenance activities (e.g., yearly DR drills, quarterly support for server or platform software patching).
- Provide ad-hoc support for other IT service requests (e.g., data extraction, data alteration, extracting system logic, responding to user inquiries about data/logic).
3. Requirements
- Recognized university degree or Master's in Information Technology, Computer Science, Management Information Science, Banking and Finance, or equivalent.
- 2+ years of working experience in SSIS, SSRS, and SQL Server development.
- 1+ year of experience in C#.NET development.
- Familiarity with Software Development Life Cycle (SDLC) processes.
- Experience in business requirement gathering, functional review, and feasibility studies.
- Strong problem-solving ability and ability to work well in a challenging technical environment with multi-tasking capability.
- Excellent communication skills.
- Proficiency in SQL Server development, including constructing complex stored procedures, user-defined functions, triggers, etc.
- In-depth understanding of: Database management systems, Online Analytical Processing (OLAP)ETL (Extract, Transform, Load) frameworks
- Familiarity with SQL Server installation and configuration, with ability to analyze and fine-tune SQL query performance.
- Strong influencing skills on technical solutions and software design.
- Strong ownership and proactive working attitude.
- Positive attitude and disposition.
- Ability to function independently or as a team player.
- Technical aptitude.
- Organized, systematic, and logical approach.
- Attention to detail.
- Willingness to learn.
