Data Engineer (Corporate DWH)

TLDR

Work on a long-term internal data-driven project focused on enhancing corporate analytics capabilities through self-service analytics and automated reporting.

Design, develop, and maintain databases for analytical and reporting needs
Create and optimize Data Warehouse structures
Design and implement Data Marts for various business domains
Ensure data quality, consistency, and performance
Collaborate with BI Engineers to support reporting and self-service analytics
Develop and maintain permission and access control models
Support and improve existing database solutions
Build and maintain ELT pipelines
Participate in performance tuning and optimization of analytical workloads

Knowledge of database fundamentals: indexing, normalization, transactions, query optimization
Hands-on experience in database development and data modeling
Understanding of data warehousing concepts (star/snowflake schemas, fact & dimension tables)
Experience with analytical workloads and reporting systems
Knowledge of ETL/ELT concepts and data pipelines
Experience with structured and semi-structured data
Understanding of data access control and permission models
Good communication skills and ability to work with cross-functional teams
BS in Computer Science or related field (or equivalent practical experience)
Strong SQL skills
Strong experience with RDBMS (MS SQL Server or similar)
Solid data modeling skills (DWH, Data Marts)
Good Python knowledge
Basic AI prompting skills
Intermediate level of English

Nice to Have

Dagster, Airflow or other orchestration tools
Experience with BI tools (Apache Superset, Power BI, etc.)
Experience with performance optimization and analytical databases usage (Clickhouse)