Senior Data Architect / DWH Architect (k/m) - banking industry

Place of work: Wrocław

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

Join the Ideamotive team as a Senior Data Architect. We are looking for an experienced person who will support long-term data warehousing projects carried out for our clients from the banking and regulated sectors. As part of our team, you will have a real impact on shaping data architecture in complex corporate environments. We provide Ideamotive support at every stage of cooperation.

Your scope of responsibilities

• Responsibility for data warehouse architecture and modeling.
• Establishing data flow standards.
• Designing dimensional models and 3NF models.
• Supporting ETL and analytics teams in making technical decisions.
• Ensuring the consistency of solutions with the strict requirements of the regulated sector.

Our requirements

• Several years of experience in designing data warehouse (DWH) architecture.
• Practical knowledge of data modeling (dimensional and 3NF).
• In-depth understanding of ETL and ELT processes.
• Very good knowledge of SQL.
• Experience working with Oracle or MS SQL databases in a production environment.
• Prior work experience in banking or another regulated sector.

Nice to have

• Knowledge of tools such as Ab Initio, IBM DataStage or Control-M.
• Experience with Kafka, Spark and the data lakehouse concept.
• Practical knowledge of cloud solutions (Azure, AWS).
• Knowledge in the area of data governance.
• Knowledge of architecture frameworks and notations (TOGAF, ArchiMate).

Benefits

• possibility of remote work
• flexible working hours
• team integration meetings

Recruitment stages

• Initial interview.
• Technical interview.
• Decision.

• If after reading this advertisement you feel that this is a role where you can really build something, it is very possible that we are looking for you.

Ideamotive

What is Ideamotive?

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

Our company was recognized by Forbes three years in a row as one of the fastest-growing IT organizations in Poland and was included on the Financial Times 1000 list.

Our team delivery consists of 60 people, our core business has 12 people, and we are eager to grow, so a “can do” approach and a focus on action are essential here.

We have a very close-knit, committed team, and we enjoy what we do.

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

If this atmosphere matches your expectations, apply! Let's see what story we can write together.

INFORMATION OBLIGATION OF IDEAMOTIVE SP. Z O.O. (for candidates for cooperation, i.e. persons applying to establish cooperation with the Company on the basis of a civil law contract, e.g. a contract for services or 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 personal 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, registered in the Register of Entrepreneurs of the National Court Register kept by the District Court for the Capital City of Warsaw in Warsaw, 12th Commercial Division of the National Court Register under KRS number 0000529079, holding tax identification number (NIP) 5272722655, REGON 147483183.2. Contact with the Controller is possible:1) by mail, at the correspondence address: ul. Złota 61/101, 00-819 Warsaw;2) by e-mail at: [email protected]. Depending on the personal data collected during the recruitment process, as well as the consents you have given, your personal data are processed for the following purposes:Purpose of processing personal dataLegal basis for processing personal dataRetention period of personal data for the given purpose of processing1Conducting the recruitment process.Art. 6(1)(b) GDPRPersonal data will be processed until the end of the recruitment process to which the application/CV was submitted*.*unless consent is given to process personal data for the purposes of future recruitments, as described below.Processing of personal data referred to in Art. 9(1) GDPR (so-called special categories of data), in the case where you include such data in your application/CV.Art. 9(2)(a) GDPR In this case, personal data may be processed until consent is withdrawn, and if consent has not been withdrawn, until the end of the recruitment process to which the application/CV was submitted, or, in the case of consent to processing such data for future recruitments, for a period of three years from the date consent is given.The given consent may be withdrawn at any time. Withdrawal of consent does not affect the lawfulness of processing based on consent before its withdrawal.Processing personal data for the purposes of future recruitments, in the case you have given the appropriate consent.Art. 6(1)(a) GDPR In this case, personal data may be processed until consent is withdrawn, and if consent has not been withdrawn, for a period of three years from the date consent is given.The given consent may be withdrawn at any time. Withdrawal of consent does not affect the lawfulness of processing based on consent before its withdrawal.Pursuing the following legitimate interests of the Controller:1) ensuring the security of the Controller, its property and the safety of other persons on its premises, in buildings or rooms used by the Controller, as well as the safety of these persons - if you enter premises, buildings or rooms covered by the Controller's video surveillance.Art. 6(1)(f) GDPRIn 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 the recruitment process or from a recruitment agency/recruitment portal, if you submitted your application/CV through them.5. The Controller may process the following categories of your personal 1) identification data, e.g. first name, surname, residential address;2) contact details, e.g. correspondence address, telephone number, e-mail address;3) employment history data;4) data on education, training and qualifications held;5) video surveillance data;6) additional data provided in the application/CV (e.g. hobbies, interests).6. Access to your personal data may be granted to authorized employees and collaborators of the Controller; entities with which the Controller has concluded a personal data processing entrustment agreement, or to which the disclosure of your personal data is consistent with binding provisions of law. Considering the above, the recipients of your personal data may be the following entities or categories of entities:1) institutions or bodies authorized to demand 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) contractors of the Controller, where recruitment is conducted in connection with a project carried out for the Controller's contractor or within other cooperation with such a contractor;4) Polish Post, courier companies.7. If, in connection with the processing of your personal data, it becomes 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 by the European Commission as adequate, 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(1) GDPR are met. Copies of any safeguards referred to above, or information on 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 the content of your personal data and obtain copies thereof;2) rectification of your personal data (correction);3) data portability for data processed in an automated manner and on the basis of consent or a contract;4) erasure of data in the situations specified in Art. 17 GDPR, where data processing is not carried out in order to comply with a legal obligation;5) restriction of data processing;6) object to data processing (in the case of processing personal data on the basis of Art. 6(1)(f) GDPR);7) withdraw the given consent to the processing of personal data, if the basis for processing is consent. You may withdraw the given 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 processing carried out before the withdrawal of consent.9. You have the right to lodge a complaint with the supervisory authority, the President of the Personal Data Protection Office.10. Providing your personal data is voluntary, but necessary to take part 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.