Senior Data Engineer

Role & responsibilities

Design

1. Analyse relevant internally and externally sourced data (raw data) to generate BI and Advanced Analytics datasets based on your stakeholders requirements

2. Design data pipelines to curate sourced data into the inhouse data warehouse

3. Design data marts to facilitate dataset consumption out of the inhouse data warehouse by business and IT internal stakeholders

4. Design data model changes that align with the inhouse data warehouse standards

5. Define migration execution activities to move data from existing database solutions to the inhouse data warehouse

Engineer

1. Regular housekeeping of raw data and data stored in the inhouse data warehouse

2. Build and maintenance of data pipelines and data platforms

3. Build data solution prototypes

4. Explore ways to enhance data quality and reliability

5. Identify and realize opportunities to acquire better data (raw data)

6. Develop analytical tooling to better support BI and Advanced Data Analytics activities

7. Execute data migration from existing databases to the inhouse data warehouse

8. Promote and champion data engineering standards and best-in-class methodology

Preferred candidate profile

1. Bachelors or master’s degree in Computer Science, Information Technology, Engineering or related quantitative discipline from a top tier university.

2. Certified in AWS Data Engineer Specialty or AWS Solution Architect Associate

3. Snowflake SnowPro Core Certification mandatory and 5+ years of hands on experience working on snowflake projects.

4. 7+ years of experience in data engineering or relevant working experience in a similar role, preferably in the financial industry

5. Strong understanding or practical experience of at least one common Enterprise Agile Framework e.g. Kanban, SAFe, SCRUM, etc.

6. Strong understanding of ETL, data warehouse and BI(Qlik) and Advanced Data Analytics concepts

7. Deep knowledge of cloud-enabled technologies – AWS RDS and AWS Fargate, etc.

8. Experience with databases and data warehouses - Snowflake, PostgreSQL, MS SQL

9. Strong programming skills with advanced knowledge of Java and/or Python

10. Practical experience with ETL tools such as AWS Glue, etc.

11. Strong critical-thinking, analytical and problem-solving skills

12. Excellent communicator with team-oriented approach