AVP, Senior Data Engineer - Regulatory Reports (JRI-4090)

The Japan Research Institute (JRI) Limited is a subsidiary of Sumitomo Mitsui Banking Corporation (SMBC) Group. SMBC Group is a Tokyo-based bank holding company that is ranked among the largest 25 banks globally by assets under management. JRI provides comprehensive, highly value-added information services through the coordinated application of its 3 functions i.e. information systems, consulting and think-tank. As a system integrator, JRI offers services in IT strategy planning, implementation and outsourcing to a broad range of industries and activities. JRI Singapore currently supports the overall IT functions of Sumitomo Mitsui Banking Corporation (SMBC) in the Asia Pacific region.

Job Responsibilities

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

• Utilize programming methodologies and languages and adhere to coding standards, procedures and technologies while contributing to the technical code documentations.

• Design, develop and deploy the programs, shell batch scripts, complex MSSQL and T-SQL scripts (packages, stored procures, functions, and triggers).

• Follow the organizational SDLC processes to deliver the 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.

• Participate in design reviews and provide input to the design recommendations; incorporate security requirements into design; and provide input to information/data flow; participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications.

• Investigate and troubleshoot the 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.

• Involve in regularly 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.

• Manage, maintain, and support applications and the corresponding operating environments, focusing on stability, quality, and functionality against service level expectation.

• Evaluate the current system state, identify aspects which could be improved and recommend changes to achieve the improvement.

• Coordinate production release preparation, provide on-call support and afterhours/weekend support as needed to cover change deployment.

• Highlight or escalate risk and issues to relevant parties in a timely manner.

Job Requirements

• Masters or bachelor’s degree in Information Technology, Computer Science, Manage Information Science, Banking and Finance or equivalent.

• Min. 2 years’ experience on MS SQL Server development (SSIS packages, stored procedures, functions, triggers).

• Familiar with Software Development Life Cycle (SDLC) process.

• Possess problem-solving ability and work well in a challenging technical environment, with capability to multi-task whilst delivering high quality solutions.

• In-depth understanding of database management systems.

• Strong communication and influencing skills.