Lead Engineer

Competencies and Skills "• University degree Bachelor’s Degree or Professional Qualification Computer Science / Information Technology or it’s equivalent. • Minimum 5+ years of experience in data engineering, cloud migration projects, or ETL processes, preferably within banks, or financial institutions. • Solid working experience with clear understanding of support functions and technology trends of Risk, Compliance, HR and Finance. • Experience working in a collaborative multi-disciplinary and regional environment • Must have 5+ years of strong experience with SAS and AWS services (Glue, Athena, Redshift). • Hands-on experience in data analysis, database design, data modelling concept and the development of data pipelines. • Experience with the AWS ecosystem, including services such as Glue, Athena, and Redshift, and familiarity with data integration best practices." Key Responsibilities Project/System Enhancement • 1. Assessment of Existing Scripts: Analyze current SAS programs to understand their logic, data sources, and dependencies, identifying potential challenges during migration. • 2. Mapping and Documentation: Create comprehensive mapping documents to outline how SAS scripts translate into AWS services, ensuring clarity for all stakeholders. Maintain thorough documentation of processes, configurations, and best practices for future reference. • 3. Design and Implementation: Collaborate in system design to optimize operational efficiency and oversee implementation, including deployment with AWS services. • 4. ETL Development: Develop and implement ETL jobs in AWS Glue, translating the logic of SAS scripts into optimized SQL for use in cloud environment. • 5. Testing and Validation: Conduct unit and integration testing of migrated scripts, collaborating with stakeholders to validate results and resolve discrepancies. • 6. Performance Optimization: Optimize Glue and/or data flow jobs for performance and cost-efficiency, ensuring scalability with data volume. • 7. Collaboration and Knowledge Sharing: Work closely with cross-functional teams to gather requirements, provide regular updates on progress and share knowledge about new workflows and tools. • 8. Participating on Project Delivery: Carry out end-to-end project delivery encompassing project scoping and planning, risk management, quality control, project execution, deployment and handover to post-deployment stabilisation and BAU mode. Ensure projects adhere to established project and delivery management methodology, processes and standards and in compliance with applicable regulatory requirements, auditors, CIMB Group’s Enterprise Architecture and IT governance and standards, and Disaster Recovery/Business Continuity Planning framework. • 9. Assessment of new Request: Facilitate cross-functional collaboration with units and technical team to manage the impacts, interfaces and inter-dependencies of new request. • 10. Post-deployment and BAU support: Manage and provide support to relevant teams in IT incidents/issues resolutions and Level 2/3 support to Application Support team for production systems in BAU as needed. Regulatory Compliance • Ensures compliance with local/regional regulatory requirements (eg. BNM, MAS, etc.) and internal/external auditors." Job Specification "• Technical/Functional Skills • Strong technical, analytical, and communication skills, with the ability to manage expectations and convey complex technical details related to cloud migration and data integration processes. • Strong understanding of the banking and financial services domain, particularly regarding regulatory requirements and data management practices. • Proficiency in programming and scripting languages relevant to data engineering, particularly in SAS, SQL for AWS services (Athena, Redshift) and experience with ETL tools like AWS Glue. • Mandatory Skills: • o SQL - Advanced query writing, ETL development.and experience with data pipeline development. • o Familiarity with AWS services and tools (e.g., S3, Glue, Athena, Redshift). • Mandatory Tools: • o Hands-on experience with data modelling and relational database design. • o Knowledge of data pipeline orchestration tools and monitoring solutions. • Value Added • AWS certification (e.g., AWS Certified Data Analytics – Specialty. • Proven ability to think creatively and develop innovative solutions for data migration and integration challenges. • Strong understanding of banking products, financial data, and relevant regulatory requirements. • Familiarity with data warehousing concepts, credit risk model and reporting tools is a plus. • Understanding of data governance and security best practices. • Personal Skills (Soft Competencies) • Excellent logical and analytical skills. • Strong troubleshooting and problem-solving abilities. • Accountable and committed to meeting challenging delivery timelines. • Independent and resilient under pressure. • Strong communication skills for effective collaboration with stakeholders. • Ability to work independently and as part of a team in a collaborative multi-disciplinary and regional environment."