Description
Our team is looking for an experienced specialist who can perform an in-depth analysis of our insurance portfolio, identify weak spots, and propose ways to optimize processes. Your task will be to help improve data quality, identify customer segments with which the company works insufficiently effectively, and formulate recommendations for increasing the sales funnel and boosting profit.
Responsibilities
- Creating specialized data extracts and reports by building complex SQL queries
- Collaborating with the development department to improve the structure and quality of data in corporate data warehouses
- Deep analysis of customer behavior and profile data, customer base segmentation, identifying trends and patterns
- Creating interactive dashboards to track key KPIs and analyze sales department productivity
- Forecasting revenue and expense dynamics, developing business development scenarios
- Formulating and testing hypotheses for improving business processes and increasing profitability, including designing experiments and conducting A/B testing
- Identifying weak spots in the customer service process and preparing proposals for optimizing business models
- Maintaining up-to-date reporting, regular monitoring, and control of its accuracy
- Presenting final results of your work to internal clients and department managers.
Requirements
- Good knowledge of mathematical statistics and probability theory fundamentals
- Advanced proficiency in MS Excel and Google Sheets (formulas, macros, pivot tables, charts)
- Basic programming skills in Python (e.g., for automating data collection and processing)
- Excellent understanding of database principles, experience working with medium-complexity SQL queries
- Practical experience with web analytics systems (Google Analytics, Yandex Metrica)
- Ability to independently develop effective visualizations and presentations of analysis results (experience with Power BI, Tableau is a plus)
- High level of communication skills and ability to convey information clearly and accessibly to colleagues at different levels
- Ability to use neural networks in daily work
- Systems thinking, results-oriented approach, and responsibility for assigned tasks.
Conditions
-
Office-based work format in a modern office in Moscow
-
Regular business trips within the Russian Federation
-
Preferential mortgage lending terms
-
Free SberPrime+ subscription and discounts on partner products: Okko, SberMarket, MegaMarket, Samokat, Eapteka, etc.
-
Private health insurance (DMS) from the first working day and insurance discounts for family members.
-
Corporate pension program
-
Gifts and organization of children's recreation at the company's expense
-
Employer-funded training: online courses, access to the corporate library, internal trainings and meetups, opportunity to acquire new qualifications
-
Discounts on vacations at the "Mriya Resort & SPA" resort complex in Yalta.
