#vacancy #SystemAnalyst #DWH #middle #senior
Role: DWH System Analyst (for a retail project)
Rate: We will consider your offer
Grade: Middle / Senior
Company: IT People group
Location: RF
Engagement Term: No term
Work Format: Remote, via sole proprietor/civil law contract
Workload: Full-time
Requirements:
- Relevant experience of 4+ years for middle and 6+ years for senior specialists;
- 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 for data model design
- Skills in working with large data volumes (billions of records, TBs of data)
- Expert SQL knowledge
- 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 poorly structured requirements in the format of data mart descriptions
- Strong communication skills for interacting with business stakeholders, developers, and administrators on equal terms
- Experience in optimizing complex queries
- Fluent spoken and written Russian
Additional for Senior:
- Planning and time management skills
- Task assignment skills for related departments
- Experience with distributed storage systems (Hadoop, S3)
Responsibilities:
- Analysis of business needs for prepared data
- Preparation of requirements regarding performance metric calculation methodology
- Design of data models for presentation and detailed data layers
- Identification of relevant data sources, data profiling in sources, and within the data platform scope
- Development of algorithms for building data marts and detailed layer objects
- Development of data mart prototypes and their approval with the consumer
- Support of data mart development at all stages of the workflow: flow development, testing, UAT, handover to support, incident resolution on the 3rd line of support
Additional for Senior:
- Estimation of computational resources required to solve the task (storage and compute sizing)
- Estimation of effort for implementing modifications
- Definition of data quality check logic and its implementation for created data marts
