DWH Analyst

Requirements:

• Analysis of business needs for prepared data
• Preparation of requirements for performance calculation methodology
• Design of data models for presentation and detailed data layers
• Search for relevant data sources, data profiling in sources, as well as within the data platform
• Development of algorithms for building data marts and detailed layer objects
• Development of prototypes for data marts and their approval with the consumer
• Support for data mart development at all stages of the workflow: flow development, testing, UAT, handover to support, incident resolution on the 3rd line of support
• Estimation of computational resources required for the task (storage and compute sizing)
• Estimation of labor costs for improvements
• Definition of data quality check logic and its implementation for created data marts

Responsibilities:

• Solid understanding of data platform construction principles (DWH, OLAP, Data Lake, Lakehouse)
• Knowledge of data model design methodologies (Kimball, Data Vault), practical experience applying them in practice for data model design
• Skills in working with large volumes of data (billions of records, TBs of data)
• Expert knowledge of SQL
• Knowledge of RDBMS (PostgreSQL, Oracle, MS SQL)
• Understanding of principles and experience working with MPP systems (GreenPlum, Clickhouse, Trino)
• Ability to analyze existing data flows, their dependencies (ETL/ELT, Airflow)
• Ability to systematize loosely structured requirements in the format of data mart descriptions
• Strong communication skills for interacting with business customers, developers, and administrators on an equal footing)
• Experience in optimizing complex queries
• Planning and time management skills
• Skills in assigning tasks to related departments
• Experience working with distributed storage systems (Hadoop, S3)
• Fluent oral and written communication