Senior Data Engineer - Business Intelligence/Data Warehousing

Description :

Design :

- 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

You will have the following qualifications :

- Bachelors or masters 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 mandatory and 5+ years of hands on experience working on snowflake projects.

- 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