Data Engineer

Overview: IT Transversal & Functions is an IT framework encompassing Projects & Systems of Finance and RISK functions that brings together a community of 2.500 experts coming from Finance, RISK and IT backgrounds, with a strong focus on efficiency, proximity, agility and time-to-market. It is a new worldwide organizational model that contributes to tackle major challenges of Group’s transformation of today and tomorrow, building the best offer for Finance and RISK community through a progressive rotation towards new technologies and best practices. ITTF FRS is a unique organization, part of IT Group yet actively managed through an innovative partnership with Finance and RISK. Risk Dedicated Solutions department is in charge of delivering dedicated solutions for RISK reporting streams and supporting RISK missions and transformation. Risk Reporting & Analytics team aims to provide support services to its users in the creation, maintenance and evolution of BI solutions, enabling RISK teams to produce different dashboards for the Group’s credit & counterparty risk (e.g. risk profile steering, risk measures, etc.). The systems involved are: SAS Risk, a platform that allows RISK users to produce several analysis and reporting for credit analysts, top management and regulators; DARE (Data Analytics Risk Explorer), which automatize dashboards production from end to end; DARK (Data Analytics RisK), a platform that allows RISK GF GSA users to go further in their reporting by producing dashboards which are user-friendly, dynamic and configurable; DERIK DM (DEclic data for RisK efficiency Domestic Market), which provides users with an industrial BI platform to manage information coming from alerting systems. What will you do? Design high-performance data pipelines (ETL) to feed a DWH using state of the art data engineering techniques according to business specifications; Implement flow automation through CI / CD pipelines and end-to-end release of artifacts across environments; Design data models and schemas as well as providing architectural guidance and recommendations according to traditional BI best practices; Provide end-users with support on the handling of Dataiku and Tableau, with support on the implementation of best practices; Coach and guidance towards junior team members, as well as stakeholders. What are we looking for? Bachelor’s degree in Information Technology, Computer Science, Business Intelligence or other relevant area; Relevant professional experience as a data engineer is mandatory (5 - 7 years); Knowledge of ETL and / or ELT data integration processes (Alteryx or Talend, for example) is mandatory; Proficiency in SQL is mandatory; Proficiency in Python and / or PySpark is mandatory; Proficiency in Apache Nifi, Dataiku and / or Tableau is a plus; Previous banking experience is a plus; Knowledge of credit risk is a plus; Knowledge of Agile methodology and JIRA is a plus; Proficiency in Microsoft Office Suite (Outlook, Excel, PowerPoint, Word). English is mandatory French notions is needed Portuguese Teamwork Client focused Rigor and precision Excellent attention to details Strong analytical mind, problem solving, planning and organizational skills Strong interpersonal communication (spoken and written) and ability to report (simplify complex information in a clearly organized and visually interesting manner, adapting it to the different stakeholders) Pro-active attitude with ability to work in a fast changing and demanding environment At ease with multi-tasking. What can you expect from us? A permanent job contract for a long term project; Tech equipment + SIM Card + personal smartphone; Health and Life Insurance; Social events and team buildings; The commitment of letting you grow with us, and be rewarded accordingly; A dynamic and young team that will be always there to support you; Training in the latest technologies; Coffee, fruits, snacks and a warm welcoming when you pass by the office. #J-18808-Ljbffr Caixa Mágica Software