Required work experience: 3-6 years
Tasks:
Design and development of corporate data warehouse (DWH).
Development, support, optimization of SQL scripts and ETL processes.
Organization of data exchange between servers via API (in JSON or XML format) and data loading from various sources (file storage, third-party DBMS).
Development of models and data marts based on received business requirements (marketing, risks, collection, Finance) server.
Administration with DB, access rights, monitoring of daily processes.
Requirements:
Higher mathematical / technical education.
Excellent knowledge of SQL: experience working with large amounts of data, query optimization.
Experience with industrial DBMSs: MS SQL Server, PostgreSQL, other.
Experience working with ETL process development tools (SQL Server Integration Services (SSIS)).
Experience using Python to organize ETL processes.
Experience working in a Bank and understanding banking business processes will be a plus for the job.
Experience in developing OLAP cubes will be a plus.
We offer:
Work in a team of highly qualified professionals, graduates of leading Russian universities (MSU, MIPT, HSE) with extensive experience in the best consulting companies and major banks (BCG, McKinsey, PwC, HSBC, Raiffeisenbank, OTP Bank, Home Credit, VTB).
Office and accommodation in a favorable area in Homishin city.
Compensation for the cost of relocation, the RFP and extended medical insurance.
Bonuses based on KPI results.
Career prospects, direct impact on business and the ability to use the latest technologies without unnecessary bureaucracy.
Key skill:
English-B2-Intermediate-advanced
SQL
MS SQL Server
Data Analysis
MS SQL
ETL