Murex Datamart Reporting IS Engineer

A multinational investment group of companies with offices in the US, Europe, and the Middle East, is recruiting a Murex Datamart IS Engineer for its Athens headquarters.

Job purpose

• Support the Group’s reporting activity, design and develop business reports on IBM Cognos, Microsoft Power BI & Murex MX.3.
• Support the data warehouse & applications’ data marts, specifically Murex Datamart.
• Monitor and troubleshoot the reports intra-day & end of day processes.

Duties and responsibilities

• Support the production, test and development environments on Murex MX.3 & IBM Cognos Analytics.
• Develop and support the different reporting needs related to accounting, finance, operations, treasury, front office (Investments, Listed Equities) for all the offices.
• Develop and support the Murex MX.3 Datamart used for ETL and data transformations.
• Develop and support SQL stored procedures, functions, views, DB links, synonyms, etc.
• Deploy and maintain SQL Server DBA activities on DB instances and perform backup and restore operations.
• Develop and support BMC Control-M jobs related to reporting and EOD.
• Maintain the integrity of the Murex MX.3 Datamart and IBM Cognos and data warehouse enforcing the SDLC process before putting changes on production.
• Contribute to the design and build of the data warehouse and data marts.

Experience & Skills

• 5 years of experience in reporting with focus on Murex MX.3 global markets and investment activity.3
• Strong technical experience in Murex MX.3, especially on the reporting stream.
• Strong expertise in Murex MX.3 dynamic tables, feeders, extractions and Datamart processes.2
• Strong expertise in Oracle PL/SQL, SQL stored procedures and ETL processes.1
• Good experience on Murex MX.3 – Front to Back – is a plus.
• Good knowledge of data mart, data lakes and data warehouses concepts.
• Good knowledge of Power BI, Tableau or similar reporting tool is a plus.
• Knowledge of BMC Control-M scheduling tool is a plus.
• Knowledge of BI Cubes is a plus.
• Knowledge of financial instruments, treasury, global markets, finance & accounting.
• Knowledge of SQL Server DBA admin is a plus.
• Good understanding of SDLC processes: design, build, test and merge into Production.
• User support and training.
• Quality Assurance & testing (test scenarios) documentation.
• Business analysis skills and ability to translate business requirements into technical design documents.
• Good communication skills and team spirit, ability to work remotely and in a multi-cultural environment.