#RU #vacancy #remote #remote #DWH #Lakehouse #ETL
Vacancy: DWH Analyst-Engineer
Grade: Senior
Company: outstaff
Format: remote
Location: Russia
Citizenship: RF
Salary Range: 230,000 to 320,000 rubles net per month
Employment Type, Format: Labor Code/Sole Proprietor
🟡Responsibilities:
- Analysis of business needs for prepared data
- Preparation of requirements regarding the methodology for calculating indicators
- 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 environment
- 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 in 3rd line support
- Estimation of computational resources required to solve the task (storage and compute sizing)
- Estimation of labor costs for performing enhancements
- Definition of data quality check logic and its implementation for created data marts
🟡Requirements:
Key Competencies
SQL
PostgreSQL
DWH
Oracle
ClickHouse
Greenplum
ETL
Airflow
MSSQL
Hadoop
s3
elt
olap
Data Vault
Kimball
Data Lake
trino
Lakehouse
- Solid understanding of data platform construction principles (DWH, OLAP, Data Lake, Lakehouse)
- Knowledge of data modeling design methodologies (Kimball, Data Vault), practical experience in applying them for data model design
- Skills in working with large data volumes (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 unstructured requirements in the format of data mart descriptions
- Strong communication skills for interacting with business stakeholders, developers, admins)
- Experience in optimizing complex queries
- Time management and planning skills
- Skills in task delegation to related departments
- Experience working with distributed storage (Hadoop, S3)
- Proficient oral and written communication
Please send resumes and questions to Telegram via DM @Geniya_HR