Programista Hurtowni Danych (k/m)

PZU Tech S.A. in Warsaw is hiring a developer specialized in data warehouse solutions focused on client data quality improvement, including deduplication, standardization, validation, and monitoring consistency between source systems and data warehouse.

• Very good knowledge of SQL and Oracle databases.
• Minimum 2 years of experience in designing and building data warehouse solutions.
• Knowledge of data modeling and data integration processes.
• Ability to collaborate with business and independently conduct analytical agreements.
• Knowledge of data quality issues and testing of data solutions.
• Experience designing, implementing, and optimizing data standardization processes, especially identification, address, contact, and registry data.
• Knowledge of deduplication concepts including record identification, matching rules, attribute selection, exception analysis, and edge cases.
• Ability to create and maintain data quality rules including completeness, correctness, consistency, uniqueness in data feeding and processing.
• Experience analyzing deduplication and standardization results, preparing control reports, explaining inconsistencies and recommending corrections to rules or source data.
• Knowledge of SAS (4GL, macros, Enterprise Guide, Data Integration Studio).

• Analyze business processes and translate business requirements into data and analytical solutions.
• Design and develop data warehouse and data integration solutions focused on deduplication and data standardization.
• Design data models, loading processes, and data transformations.
• Collaborate with analysts, business users, architects, and IT teams.
• Participate in projects for development and transformation of the data environment, including modernization of data warehouse architecture.
• Prepare and maintain technical documentation.
• Participate in testing and data quality analysis.

The offer includes a detailed data protection information clause explaining the personal data processing terms by PZU TECH SA for recruitment purposes, legal bases, data retention periods, data sharing, and candidates' rights according to GDPR.