Senior Data Engineer (Regulatory Reports | MSSQL)

Responsibilities:

1. Design, develop and deploy the programs, shell batch scripts, complex MSSQL and T-SQL scripts (packages, stored procedures, functions, and triggers).
2. Perform impact analysis for upstream and downstream changes that affect the systems.
3. Utilize programming methodologies and languages and adhere to coding standards, procedures, and technologies while contributing to the technical code documentation.
4. 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.
5. Investigate and troubleshoot the production issues and system problems escalated by the 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.
6. Involve in regular maintenance activities, e.g., yearly DR drill, quarterly support for server or platform software patching, etc.
7. Provide ad-hoc support for other IT service requests, e.g., data extraction, data alteration, extract system logic, answer to users' inquiries about the data/logic in the system, etc.
8. Highlight or escalate risks and issues to relevant parties in a timely manner.
9. Coordinate production release preparation, provide on-call support, and after-hours/weekend support as needed to cover change deployment.

Requirements:

1. Masters or Bachelor's Degree in Information Technology, Computer Science, Management Information Science, Banking and Finance, or equivalent.
2. Minimum 2 years of experience in MS SQL Server development (SSIS packages, stored procedures, functions, triggers).
3. In-depth understanding of database management systems.
4. Familiar with Software Development Life Cycle (SDLC) process.
5. Possess problem-solving ability and work well in a challenging technical environment, with capability to multi-task whilst delivering high-quality solutions.
6. Strong communication and influencing skills.