Business Intelligence Developer / Data Management EngineerPrometeia is a global firm of quantitative experts and software engineers, dedicated to applying financial modelling, economic research and data science to solve complex business and regulatory challenges. Our mission is to combine academic excellence with industry experience, integrating macro-economic research, quantitative analysis, business consulting and software development. This distinctive mix of competences has made Prometeia a leading company in Risk, Asset and Wealth Management solutions across Europe, Africa and Middle East.As a leading provider of Risk Management solutions in the Egyptian market, Prometeia is looking to strengthen its Risk & Regulatory Analytics Team in Cairo, by hiring a Business Intelligence Developer / Data Management Engineer with proven experience in the fields of Bank and Financial Services Data Management, MIS and Regulatory Reporting.PROMETEIA OVERVIEWPrometeia creates value by integrating analytical models, customer data, market feeds and economic scenarios to support decision-making processes and regulatory compliance. Prometeia is structured in six areas of business: Enterprise Risk Management, Wealth Management & Financial Distribution, Data Science, Economic Research & Business Information, Financial Advisory for Institution Investors, Strategic Advisory & Corporate Finance.The Enterprise Risk Management (ERM) is the largest of Prometeia business areas and is the cornerstone of Prometeia’s reputation in the international market. The thematic areas covered by the ERM Area include Credit Risk, ALM, & Liquidity Risk, Risk & Performance Integration, Risk Governance, ESG Compliance, Credit Decision Management, Pricing & Financial Engineering.Placed within the ERM Area, the Credit Decision Management Line has been built with the aim of supporting primary banking groups within their digital transformation path.In the FS industry, projects are particularly focused on the definition of data strategy and implementation of Data Warehouse and Data Lakehouse, managing both structured and unstructured data. Our team create value by analyzing data and developing machine learning and artificial intelligence solutions.PROMETEIA EGYPTIAN BRANCHThe Cairo Office is being established with the aim of serving as central ‘hub’ for the delivery of Risk Management projects in Egypt and North Africa.Founded in 2018, the Egyptian Risk Team has the mission of consolidating the leadership of Prometeia in one of the key geographies in which our group has operated over the past decade.In the fields of Data Management, Prometeia already collaborates with primary banks in Egypt and GCC countries through a local team of 20+ resources.RESPONSIBILITIESThe successful candidate will collaborate with a specialized team of business consultants and IT resources, operating within different projects for financial intermediaries. Key responsibilities include:Understand customer requirements for data management processes, focused on Data Warehouse and Data Lakehouse.Make data-related decisions by analyzing, manipulating, tracking and reporting structured and unstructured data.Deliver functional and technical analysis for data and meta-data.Design, build, test and deploy ETL procedures, to feed Data Warehouse/Data Lakehouse and automate data loading processes.Analyze and investigate data issues.Manage the User Acceptance Testing (UAT) of data delivery.REQUIREMENTSExperienced professionals bring us the know-how to make lasting change for our clients and our company.Prometeia is not a typical management consulting company: we provide deep industry- and discipline-specific knowledge and expertise, which amplifies our impact and helps us shape the future for our clients.Our resources are experts in particular content areas and provide day-to-day leadership of complex client projects and commercial process, teaming with Partners and Senior Partners. They ensure on-time delivery that meets or exceeds expected goals, leveraging the unique selling proposition of Prometeia.The Prometeia culture is strongly oriented to business and technological innovation: in this sense, the mission of our resources is to bring the industry best practices, in particular the ones developed in collaboration with our top-tier clients in Europe, to the Egyptian and North African market.MANDATORY REQUIREMENTSDegree in IT, information studies, software engineering, or a related discipline.At least 3 years’ experience on delivering Data Management or BI solutions for banks, preferably in Egypt or the Middle East region.Advanced knowledge of:Design and implementation of Data Analysis Environments and Data Analytics.DWHs, Datamarts and DBMS structure and functionalities.Dashboard and automated reporting analysis and delivery.Oracle databases and Informatica Power CenterSQL, Python programming languageSQL Server databases, Reporting Services, Tabular databases and DAX query language will be considered as plus.Services for data visualization like Tableau and Power BI.Excellent algorithmic skills.PROJECT SKILLSExperience in Data Management and Data Modelling for banking and financial service institutions.Experience in analysis of business requirements for the implementation of input data interfaces.Experience with production of MIS and BI reports to support strategic decisions, risk and performance management.Experience with production of regulatory reporting for national and international supervisors (BCBS/CBE).Ability to create and follow work plans and monitor related project deadlines both with colleagues and clients (project managers and business experts).Ability to manage the interface with the client for first level debugging of anomalies / tickets (Help Desk Management).Ability to work independently on tasks.Be analytical and overly detailed oriented when dealing with functional/methodological support issues and projects.Be flexible and adaptable to changing priorities.SOFT SKILLSArabic native speakerFluency in English languages is mandatory (at least C1)Capable of working within a multi-language and multicultural environmentStrong attention to details and technicalitiesExcellent organizational and technical skillTeamwork attitude, flexibility, and proactivityProblem solving skills and good interpersonal skills.WHAT WE OFFERThe selected candidate will be offered a career path that will include projects abroad as well as the opportunity to work in a stimulating and dynamic environment, strongly oriented towards the enhancement of resources according to the objectives attained. LOCATIONCairo – EgyptApplications made without sending an updated cv in English won't be considered.The eligible candidates will be contacted for a preliminary call by the Corporate HR Representatives.Our company promotes and respects equal opportunities (L 903/77).Prometeia is committed to employing a diverse workforce.Qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, gender expression, veteran status, or disability. Our Group obtained the Top Job 2019/20 award, assigned by the German Institute of Quality and Finance to the 200 best companies to work in various European countries (2000 companies considered in the analysis).