Data Engineer/Inżynier Hurtowni Danych (K/M)

ESOTIQ & Henderson S.A is a company designing, producing, and selling clothing and cosmetic products. It has been publicly listed on the Warsaw Stock Exchange since 2011 (NewConnect) and main market since 2015. The company has a team involved in creative projects with notable collaborators such as model Joanna Krupa and fashion house EVA MINGE.

• Minimum 4 years of experience in data engineering
• Very good practical knowledge of **SQL/**T-SQL and Microsoft SQL Server
• Practical experience with SSIS and SQL Server Agent and building ETL/ELT processes
• Knowledge of data modeling and data warehouse design principles, including landing, staging, and mart layers
• Experience in analyzing existing code, diagnosing errors, and optimizing data processing
• Practical knowledge of SSAS and working with semantic layers for analysis and reporting
• Knowledge of data security, quality, and access control principles
• Independence, responsibility, and ability to collaborate with teams and translate business needs into technical solutions

• Development and maintenance of data warehouse and data models in landing, staging, and mart layers
• Building, maintaining, and optimizing ETL/ELT processes integrating data from ERP, POS, eCommerce, and other sources
• Development and optimization of solutions using **SQL/**T-SQL, SSIS, and SQL Server Agent
• Preparation of data sets and development of semantic layer using SSAS for analysis and reporting
• Ensuring data quality and continuity through validations, monitoring, error diagnosis, and performance improvement
• Cooperation with Data & BI team and business stakeholders to define requirements, priorities, and acceptance criteria
• Participation in the development of the DWH/BI platform, documentation of solutions, and preparation of selected reports