Company: UnSpot
Vacancy: Data Analyst/DWH
Location: strictly Russian Federation
Level: Middle+/Senior
Salary range: 250-350k gross under Sole Proprietorship agreement/Labor Contract
‼️CANDIDATES WITHOUT BANKING EXPERIENCE WILL NOT BE CONSIDERED‼️
Requirements:
- Higher education in natural sciences, technical, or economics;
- From 3 years of experience with DWH / Data Lake in a bank
- Experience as a system analyst in Customer Relationship Management/DWH projects
- Deep knowledge of SQL (Oracle), ability to write complex queries and read PL/SQL
- Understanding of DWH architecture and construction principles
- Experience in designing DB objects and data marts
- Understanding of data integration and processing
- Experience analyzing existing data loading streams
- Experience with ETL, preferably Informatica PowerCenter
- Experience with JIRA and Confluence
- Knowledge of Bank of Russia reporting and methodology for calculating mandatory ratios.
Will be a plus:
- Experience with MS SQL Reporting Services or Tableau
- Knowledge of 135-F, 220-I, N1 components;
- Understanding of Data Quality (DQ) principles
- Experience in designing DB objects on all DWH layers
- Understanding of the reporting automation lifecycle
Tasks:
- Analysis and formalization of customer requirements;
- Preparation of technical specifications and technical documentation, including Source2Target;
- Description and analysis of data loading streams into DWH;
- Participation in the automation and development of banking reporting;
- Design of DB objects and data marts;
- Analysis of existing ETL streams and data integration and processing procedures;
- Interaction with development teams;
- Work with JIRA and Confluence.
