ETL Developer

Key requirement/What you bring

• 3-5 years of experience on data visualization and BI reporting tools e.g. MicroStrotegy, PowerBl

• 3-5 years of experience with PostGres or Oracle and SQL Programming

• Worked in Agile methodology

• Significant experience in one or more of the following categories;

• Data Warehousing

• ETL Development

• Dimensional Modelling

• Data Vault 2.0

• Data Science

• Experience working with subject matter and technical experts

• High communication and interpersonal skills

• Oral and written proficiency in English language

• Mentoring and coaching of other developers

• Demonstrates a curious mentality and willingness to learn

• Keeps skills up to date and transfers knowledge where possible

• Presentable and punctual; be a role model to other developers

Key responsibilities/What you do

• Design and develop MicroStrategy reports, dashboards, and visualizations that align with business requirements.

• Create and maintain MicroStrategy schema objects (attributes, facts, metrics, etc.) and application objects (reports, dashboards, documents, etc.).

• Proven experience in ETL development (Event and/or Batch driven)

• At least experience in two of the following technologies (SQL, Python, Oracle, Postgres, Code Generation, pyTest)

• Experience with Database design and modelling (multidimensional, 3NF, data vault)

• Experience with agile methodology and tools (Jiro, confluence)

• Developing SQL packages, procedures and functions

• DevOps skills: CI/CD in Jenkins, GitHub

• Troubleshooting, bug fixing, debugging experience

• Understanding of insurance business, ABS Knowledge (Desirable)

• Experience in use of containerized environments for development (Desirable)

• Kafka Knowledge (near real time data integration) (Desirable)