Your responsibilities will include:**
- Developing DWH data layers in ArenadataDB (ODS, DDS, DM / Data Vault).
- Administering, operating, and scaling the DWH cluster.
- Participating in the development of pipelines for data migration, aggregation, and normalization in DWH (ELT).
- Implementing data migration from existing accounting RDBMS – MSSQL, PostgreSQL.
- Monitoring and optimizing DWH performance, preparing recommendations for optimizing resource pools and SQL queries.
What we value:
- Higher technical education.
- Experience with and operation of GreenPlum, MSSQL, and PostgreSQL databases.
- Understanding of pipeline construction using PXF connections, Apache Airflow, AirByte.
- Solid knowledge and skills in SQL, experience in optimizing SQL queries.
- Experience in administering MSSQL and PostgreSQL databases.
- Experience with DBT, AirFlow, and AirByte in Python will be a plus.
What we offer:
- Employment in an accredited IT company within a large, high-tech medical holding company, comprising 8 advanced medical centers in various cities across our country, a sanatorium, and over 80 health posts at industrial enterprises.
- Fully official salary and annual bonuses based on performance.
- Comprehensive health care program - voluntary medical insurance policy with dentistry. Corporate discounts on medical services and stays at sanatoriums, including for your loved ones. Preferential terms from our partners for health insurance for the whole family.
- Corporate training and employee development, discounts on various courses from our partners.
- Friendly IT team – we organize joint corporate events, Townhalls, and team-building activities outside the city.
- Annual event - Corporate Award "For the Sake of Life", where we honor the best of the best! Our employees are our treasure.
- We love and support sports interests, we have corporate sports communities. We will support and help if you want to start your own!
- Special conditions on services from our partners (finance, insurance, cars, recreation and leisure, etc.).
- Work location: Business Center "Petrovsky Fort" (Finlandsky Prospekt, 4). Nearest metro stations - "Ploshchad Lenina", "Gorkovskaya".
- Work format during the probation period - full-time, in the office. After successful completion of the probation period - hybrid.
In your cover letter, please indicate your expected salary level.
