Data Engineer

• Analyse relevant internally and externally sourced data (raw data) to generate BI and Advanced
• Analytics datasets based on your stakeholders’ requirements
• Design data pipelines to curate sourced data into the inhouse data warehouse
• Design data marts to facilitate dataset consumption out of the inhouse data warehouse by business and IT internal stakeholders
• Design data model changes that align with the inhouse data warehouse standards
• Define migration execution activities to move data from existing database solutions to the inhouse data warehouse Engineer
• Regular housekeeping of raw data and data stored in the inhouse data warehouse
• Build and maintenance of data pipelines and data platforms
• Build data solution prototypes
• Explore ways to enhance data quality and reliability
• Identify and realize opportunities to acquire better data (raw data)
• Develop analytical tooling to better support BI and Advanced Data Analytics activities
• Execute data migration from existing databases to the inhouse data warehouse
• Promote and champion data engineering standards and best-in-class methodology

Required Skills:

• Bachelor’s or master’s degree in Computer Science, Information Technology, Engineering or related quantitative discipline from a top tier university.
• Certified in AWS Data Engineer Specialty or AWS Solution Architect Associate
• Snowflake SnowPro Core Certification
• 7+ years of experience in data engineering or relevant working experience in a similar role, preferably in the financial industry
• Strong understanding or practical experience of at least one common Enterprise Agile Framework e.g., Kanban, SAFe, SCRUM, etc.
• Strong understanding of ETL, data warehouse and BI(Qlik) and Advanced Data Analytics concepts
• Deep knowledge of cloud-enabled technologies – AWS RDS and AWS Fargate, etc.
• Experience with databases and data warehouses - Snowflake, PostgreSQL, MS SQL
• Strong programming skills with advanced knowledge of Java and/or Python
• Practical experience with ETL tools such as AWS Glue, etc.
• Strong critical-thinking, analytical and problem-solving skills
• Excellent communicator with team-oriented approach