Description
We are an ambitious team working at the intersection of IT and retail business.
We invite you to participate in a very important and ambitious project of federal scale!
We are developing an application that helps 60+ thousand employees at service offices across the country improve the lives of many millions of clients every month!
The foundation of our application is a symbiosis of advanced BI analytics, gamification, and AI models.
We offer opportunities to grow in the field of building advanced analytics, DWH architecture, and Data Science!
What you will be doing:
- Ensure data collection and organize data loading processes into analytical systems, including obtaining structured data from various sources, perform preparation, cleaning, and preprocessing of data from external sources, build aggregates
- Develop DWH objects on PostgreSQL using the Greenplum DBMS
- Calculate complex analytical metrics
- Participate in refining business hypotheses and suggest ideas for improving our application
- Participate in testing and supporting developed services to ensure their stable and reliable operation
- Prepare AD-HOC reports as needed.
Requirements:
- Ability to work with large volumes of data using SQL (DML and DDL dialects in PostgreSQL)
- Experience in optimizing SQL queries across multiple tables and data sources, ability to combine aggregate and window functions, write stored procedures and UDFs, create Views
- Understanding of DWH architecture design and knowledge of key design methodologies
- Knowledge and ability to apply key areas of statistics for working with data (knowledge of various distribution types, understanding of what confidence intervals and outlier detection are, and ability to use them)
- Experience with data-pipelines (knowledge of how to get data from a source, check its quality, perform aggregation, and derive useful insights based on it)
- Experience working in SCRUM / AGILE and using JIRA and Confluence.
It will be a plus to know Python with its main frameworks: Pandas, Numpy, Sklearn, and the ability to demonstrate/tell about real cases of their application (work experience, or pet-projects).
Conditions:
- Stable salary and social support for employees
- Office address: 66/1 Kuibysheva Street
- Extended private health insurance from day one and preferential insurance for family members
- Corporate training at Sber's Virtual School
- Flexible discount on mortgage loans, equal to 1/3 of the Central Bank's key rate
- Free SberPrime+ subscription, discounts on products from partner companies
- Corporate pension program.
Responsibilities
Requirements
Conditions
