What you will be doing:**
- Refactoring and creating data marts, procedures, and jobs in SQL (oracle, greenplum).
- Working with an orchestrator (airflow).
- Direct participation in report creation.
- Migrating reports from legacy sources to DWH.
To be successful, you will need:
- SQL (oracle/postgres dialects will be an advantage) - ability to work with DML and DDL. Understanding of code and database optimization principles, ability to work with indexes.
- Basic python and git (for working with airflow).
- Analytical mindset, structured thinking.
It will be a plus if you:
- Have experience with BI systems, Power Pivot, Excel.
- Have a higher technical/mathematical education.
We offer you:
- Work in an accredited IT company
- Atmosphere of stability and security, as we operate in full compliance with the Labor Code of the Russian Federation
- Our own corporate library with over 300 books
- Opportunity to work both in the office and remotely
- Opportunity for external training at the company's expense, including English language lessons at Skyeng
- Extended Voluntary Medical Insurance package with dentistry and doctor-on-call service
- Active corporate life and a rich event calendar: we participate in sports races and marathons, we have a football team and a table tennis team, as well as quizzes, meetups, and much more! And yoga classes are held right in the office
- Only self-expression and free style. No dress code!
- A comfortable, beautiful, and technologically advanced office in the city center with work and relaxation areas and a yoga studio. For employees living outside of Novosibirsk, coworking space rental is also covered.
- A cozy office kitchen with coffee machines, microwaves, dishes, and all necessary appliances. Plus fruits, coffee/tea, syrups, and alternative milk.
