Senior Data Architect / Data Warehouse Architect (m/f) - Banking Industry

Workplace: Warsaw

Technologies We Use

Required

• DWH
• dimensional modeling
• 3NF
• ETL
• ELT
• SQL
• Oracle
• MS SQL

Nice to have

• Ab Initio
• IBM DataStage
• Control-M
• Kafka
• Spark
• Data Lakehouse
• Azure
• AWS
• Data Governance
• TOGAF
• ArchiMate

About the Project

At Ideamotive, we are looking for an experienced Senior Data Architect. You will join us to carry out long-term data warehousing projects for large banks and institutions in the regulated sector. We provide full Ideamotive support at every stage of the cooperation. Our recruitment process is short and to the point: it consists of an initial interview, a substantive meeting, and a quick decision.

Your Responsibilities

• Designing data warehouse architecture and modeling.
• Setting information flow standards.
• Creating dimensional models and 3NF models.
• Providing technical support to ETL and analytical teams in making key design decisions.
• Ensuring the consistency of proposed solutions with the stringent requirements of the banking sector.

Our Requirements

• Many years of experience in data warehouse (DWH) architecture design.
• Practical ability in data modeling in dimensional and 3NF approaches.
• Good knowledge of ETL and ELT processes.
• Very high competence in SQL.
• Experience working with Oracle or MS SQL databases in a complex production environment.
• Previous experience in banking or another highly regulated sector.

Nice to have

• Familiarity with tools such as Ab Initio, IBM DataStage, or Control-M.
• Experience with Kafka, Spark technologies, and the Data Lakehouse concept.
• Practical knowledge of cloud solutions (Azure, AWS).
• Knowledge in the field of Data Governance.
• Familiarity with the TOGAF standard and ArchiMate notation.

Benefits

• remote work option
• flexible working hours
• integration meetings

• If after reading this announcement you feel that this is a role where you can build something real – it is very likely that we are looking for you.

Ideamotive

What is Ideamotive?

An Agile company providing IT tech team extension services for corporate clients (mainly in Poland).

Our company has been recognized by Forbes for 3 consecutive years as one of the fastest-growing IT organizations in Poland and was listed in the Financial Times 1000.

The delivery team consists of 60 people, the business core has 12 people, and we are aiming for growth, so a "can do" approach and a focus on action are essential here.

We have a very cohesive, engaged team, and we enjoy what we do.

Read about our values: https://www.ideamotive.co/about

If such an atmosphere aligns with your expectations, apply! Let's see what story we can write together.

INFORMATION OBLIGATION OF IDEAMOTIVE SP. Z O.O. (for candidates for collaborators, i.e., individuals applying for cooperation with the Company based on a civil law contract, e.g., a mandate contract, b2b)This document contains, among other things, information regarding the purposes of processing your personal data by Ideamotive Sp. z o.o. (hereinafter: the "Controller"), the period of their processing by the Controller, your rights, possible recipients of your personal data, and contact details for matters concerning the processing of your data by the Controller.The following information is provided in connection with the obligations arising from Regulation (EU) 2016/679 of the European Parliament and of the Council of 27 April 2016 on the protection of natural persons with regard to the processing of personal data and on the free movement of such data, and repealing Directive 95/46/EC (hereinafter: "GDPR").1. The Controller of your personal data is Ideamotive Sp. z o.o. with its registered office in Warsaw (postal code 00-819), at ul. Złota 61/101, entered into the Register of Entrepreneurs by the District Court for the Capital City of Warsaw in Warsaw, 12th Commercial Division of the National Court Register under KRS number 0000529079, possessing NIP 5272722655, REGON 147483183.2. Contact with the Controller is possible:1) by post, at the correspondence address:ul. Złota 61/101, 00-819 Warsaw;2) via e-mail at: [email protected]. Your personal data, depending on the personal data collected during the recruitment process, as well as the consents expressed, are processed for the following purposes:Purpose of personal data processingLegal basis for personal data processingRetention period of personal data for the given purpose1. Conducting the recruitment process.art. 6 sec. 1 lit. b GDPRPersonal data will be processed until the completion of the recruitment process for which the application/CV was submitted.*Unless consent to process personal data for future recruitment is given, as mentioned below.Processing of personal data referred to in art. 9 sec. 1 GDPR (so-called special categories of data), if you include such data in your application/CV.Art. 9 sec. 2 lit. a GDPR In this case, personal data may be processed until the consent is withdrawn, and if consent is not withdrawn until the recruitment process is completed – the data will be processed until the completion of the recruitment process for which the application/CV was submitted, or in the case of consent to process such data for future recruitment – for a period of three years from the date of expressing the aforementioned consent.The expressed consent can be withdrawn at any time. Withdrawal of consent does not affect the lawfulness of data processing until the consent is withdrawn.1 The retention period of personal data is determined individually for each purpose of personal data processing.Processing of personal data for future recruitment, if you have given your appropriate consent.art. 6 sec. 1 lit a GDPR In this case, personal data may be processed until the consent is withdrawn, and if consent is not withdrawn – for a period of three years from the date of expressing consent.The expressed consent can be withdrawn at any time. Withdrawal of consent does not affect the lawfulness of data processing until the consent is withdrawn.Fulfilling the following legally justified interests of the Controller:1) ensuring the safety of the Controller, its property, and the property of other persons located on the premises, in buildings, or rooms used by the Controller, as well as the safety of these persons – if you enter the premises, building, or rooms covered by video surveillance by the Controller.art. 6 sec. 1 lit f GDPR In the case of video surveillance, personal data are processed for a period of 3 months from the date of recording.4. Your personal data may be obtained directly from you during recruitment or from a recruitment agency/recruitment portal, if you have submitted an application/CV through them.5. The Controller may process the following categories of your personal 1) identification data, e.g., first name, last name, residential address;2) contact details, e.g., correspondence address, phone number, e-mail address;3) employment history data;4) education, training, and qualification data;5) video surveillance data;6) additional data provided in the application/CV (e.g., hobbies, interests).6. Authorized employees and collaborators of the Controller may have access to your personal data; entities with whom the Controller has concluded a personal data processing entrustment agreement, or to whom disclosure of your personal data is permitted by binding legal provisions. Bearing the above in mind, recipients of your personal data may be the following entities or categories of entities:1) institutions or authorities entitled to request access to or receive personal data on the basis of legal provisions, e.g., the President of the Personal Data Protection Office, the Police;2) entities providing services to the Controller (law firms, auditors, entities maintaining the Controller's IT systems or providing other IT services, entities providing security services for facilities used by the Controller);3) the Controller's contractors, if the recruitment is conducted in connection with a project carried out for the Controller's contractor or as part of other cooperation with such a contractor;4) Polish Post, courier companies.7. If, in connection with the processing of your personal data, it is necessary to transfer your personal data outside the European Economic Area (EEA) to countries not belonging to the EEA, whose level of data protection has not been recognized as adequate by the European Commission, the Controller will transfer your personal data only to the extent permitted by law, e.g., by applying appropriate safeguards in the form of standard data protection clauses adopted by the European Commission or in cases where the conditions specified in art. 49 sec. 1 GDPR are met. Copies of any safeguards mentioned above or information about their availability can be obtained by contacting the Controller at the addresses indicated in point 2 above.8. You have the right to:1) access your personal data and copies thereof;2) the right to rectification (correction) of your data;3) the right to data portability for data processed automatically and based on consent or contract;4) the right to erasure of data in situations specified in art. 17 GDPR, in a situation where data processing is not carried out to fulfill an obligation arising from a legal provision;5) the right to restrict data processing;6) the right to object to data processing (in the case of personal data processing based on art. 6 sec. 1 lit. f GDPR);7) the right to withdraw your consent to the processing of personal data, if the basis for processing personal data is consent. You can withdraw your consent at any time by contacting the Controller at the addresses indicated in point 2 above. Withdrawal of consent does not affect the lawfulness of data processing until consent is withdrawn.9. You have the right to lodge a complaint with a supervisory authority – the President of the Personal Data Protection Office.10.The provision of your personal data is voluntary, but it is necessary to participate in the ongoing recruitment process.11.Your personal data will not be processed in an automated manner that could result in automated decision-making, including decisions based on profiling.