Job Description:
We are seeking a highly skilled professional to collaborate with our finance team and subject matter experts in implementing new data interfaces to feed models or finance systems. This involves planning, developing, testing, and supporting ETL/ELT processes, including associated data storage structures.
The ideal candidate will have excellent knowledge of data warehouse and data lake house design best practices, as well as experience in designing and developing Power BI datasets and reports. Additionally, they should be proficient in SQL Server language and storage engine behavior, SSAS Tabular and multidimensional platform, and languages such as DAX and MDX.
Key Responsibilities:
* Collaborate with finance analysts and subject matter experts to implement new data interfaces.
* Plan, develop, test, and support ETL/ELT processes, including associated data storage structures.
* Perform processing reviews, analyze execution plans, refactor inefficient processes, and review bottlenecks.
* Build and execute test cases to ensure data integrity, accuracy, and consistency.
* Participate in on-duty rotations to ensure production continuity.
Required Skills and Experience:
* Excellent knowledge of data warehouse/data lake house design best practices (star schemas, data vault, data mesh, data products).
* Excellent knowledge of SQL Server language and storage engine behavior.
* Good knowledge of SSAS Tabular and multidimensional platform and languages (DAX, MDX).
* Experience in designing and developing Power BI datasets and reports.
* Good knowledge of PowerShell.
* Good knowledge of banking data, positions, and transactions typologies.
* Azure Data Engineer certification or commitment to become certified within the first year.
* Willingness to learn a wider range of technologies, including legacy ones.
Personal Qualities:
* 5+ years of experience in similar roles.
* Passionate about data processing and technology.
* Enjoy reading and learning about technology for personal interest.
* Curious and focused, with a willingness to address questions and seek novelty.
* Fluent in English and French (spoken and written).