Main responsibilities
1. Collaborate with Finance analysts and subject matter experts to implement new data interfaces to feed models or finance systems.
2. Plan, develop, test and support ETL/ELT processes including associated data storage structures.
3. Perform processing reviews, analyse execution plans, re-factor inefficient processing’s, review bottlenecks.
4. Build and execute test cases to ensure data integrity, accuracy, and consistency.
5. Member of on-duty rotations team to ensure production continuity.
Skills and experience
6. Excellent knowledge of Datawarehouse / Datalakehouse designs best practices (star schemas, data vault, data mesh, data products)
7. Excellent knowledge of SQL Server language and storage engine behaviour, execution plan review is your natural query performance tool.
8. Good knowledge of SSAS Tabular and multidimensional platform and languages (DAX, MDX) or strong appetite to become a reference.
9. Experience in designing and developing PowerBi datasets and reports,
10. Good knowledge of PowerShell,
11. Good knowledge of banking data, positions, and transactions typologies
12. Knowledge of T24 banking system is a plus.
13. Experience with Python, Spark, Kafka, .NET is a plus.
14. Azure Data Engineer certification or commitment to become certified during the 1st year.
15. Willingness to learn a wider range of technologies, including legacy one.
Personal Skills
16. 5+ years of experience in similar roles
17. Passionate about data processing and technology in general
18. Enjoy reading and learning about technology for your personal interest.
19. Curious and focused, you always ensure to get your questions addressed, you enjoy novelty
20. Fluent English and French (spoken and written)