Senior Data Analyst - Toa Payoh

Role: Senior Data Analyst

Key Skills:

• Data Engineering & Analytics: Data modeling, data transformation, quality assurance
• Programming & Scripting: SQL, Hive, Shell scripting, Python
• Big Data & Cloud: Hadoop-based Data Lake, AWS
• Automation & Workflow Optimization: Process automation, scripting
• Testing & Quality Assurance: Data validation, compliance adherence
• Stakeholder Management: Business engagement, audit, and risk functions
• Project Management: Agile execution, multi-tasking, problem-solving

Regulatory & Compliance: Financial services audit and risk management

Key Responsibilities:

• Design, develop, and implement data processing pipelines to process large volumes of structured and unstructured data
• Should have good knowledge and working experience in Database and Hadoop (Hive)
• Should have good knowledge and working experience in scripting using (Shell script, awk programming, quick automation to integrating any third party tools), BMC monitoring tools
• Good understanding and knowledge in Data Modelling area using industry standard data model like (FSLDM)
• Collaborate with data engineers, data scientists, and other stakeholders to understand requirements and translate them into technical specifications and solutions
• It will be good to have experience in working with No SQL as well as virtualized Database Environment
• Develop and maintain scalable and fault-tolerant Spark applications, adhering to industry best practices and coding standards
• Prior experience in developing banking application using ETL, Hadoop is mandatory. In depth knowledge of technology stack at global banks is mandatory.
• Flexibility to stretch and take challenges
• Communication & Interpersonal skills
• Attitude to learn and execute.
• Implantation of Enterprise wide Data Governance.
• Developed Enterprise level LDM for public banking and wealth management.
• Analyzing various inputs to come up with Enterprise level Conceptual Data Model.
• Building the Enterprise-wide Physical Data model using Erwin tool.

Key Requirements:

• Experience in developing Hadoop
• Experience in data lake (integration of different data sources into the data lake)
• SQL Stored Procedures/Queries/Functions
• Unix Scripting
• Experience with distributed computing, parallel processing, and working with large datasets
• Familiarity with big data technologies such as Hadoop, Hive,
• Job Scheduling in Control-M
• Strong problem-solving and analytical skills with the ability to debug and resolve complex issues
• Familiarity with version control systems (e.g., Git) and collaborative development workflows
• Excellent communication and teamwork skills with the ability to work effectively in cross-functional teams