Job Summary
Essential Skills/Basic Qualifications:
- Data modelling (definition of data schemata) and data analysis skills in a data warehouse type environment, including both star schema and third normal form. Using ER Studio or similar tool
- Strong SQL skills. Comfortable at the SQL command prompt
- Experience of working in Financial domain with understanding of key data entities in Investments and Client domain
- Understand types of data schema and when to use them (3NF, star, flat, etc); mapping/translation between these
- Express key structural points of complex data model in accessible terms
- Experience understanding source data models with limited documentation and access to experts
- Understanding of the principles of data quality and data governance
Desirable skills/Preferred Qualifications:
- Strong analytical skills
- Experience of inferring a data model and lineage from an existing database with limited documentation
- Python and Pandas for data manipulation
- Data warehouse background
- Experience of data science and machine learning principles and techniques
- ETL tools; ability to use and enhance new tooling
- Amazon Web Services (AWS) – AWS Glue, Athena, S3
- Data catalogue e.g. Alation
- Working in agile mode
- Graduate preferably with a technology based degree
Key Responsibilities
2. To conduct comprehensive code reviews, establish and oversee quality assurance processes, performance optimization , implementation of best practices and coding standards to ensure successful delivery of complex projects.
3. To ensure process compliance in the assigned module| and participate in technical discussions/review as a technical consultant for feasibility study (technical alternatives, best packages, supporting architecture best practices, technical risks, breakdown into components, estimations).
4. To collaborate with stakeholders to define project scope, objectives, deliverables and accordingly prepare and submit status reports for minimizing exposure & closure of escalations.