Company: IBS
Location: Nizhny Novgorod, RU
Employment Type: full-time
Salary: 30,000–40,800 RUB per month
Junior developer for the Big Data and Data Warehousing team. Working with Greenplum, SQL, ETL/ELT pipelines, and data marts in a corporate DWH.
Responsibilities:
- Database Design and Maintenance: development and support of database objects (tables, views, indexes, stored procedures) in the Greenplum environment
- Data Mart Development: design and calculation of metrics for data marts for business tasks using SQL
- ETL/ELT Pipeline Construction: implementation and optimization of data loading and transformation processes in the corporate data warehouse (DWH) using Apache Airflow for orchestration
- Data Quality Control: performing initial testing and validation of loading results, ensuring data integrity and accuracy
- Solution Documentation: active participation in the creation and maintenance of technical documentation for developed processes and data schemas
- Planning and Reporting: maintaining regular reports on task progress, tracking issues and deadlines in tracking systems (Jira)
Requirements:
- Higher education in IT
- SQL Proficiency: confident knowledge of syntax and basic constructs (SELECT, INSERT, JOIN), working with aggregate functions and window expressions. Understanding of set operations (UNION, INTERSECT, EXCEPT) and Cartesian products
- Databases: experience with relational DBMS (any vendor — PostgreSQL, MySQL, ClickHouse, etc.) at the pet project level
- Programming Skills: knowledge of programming languages (e.g., Python) and object-oriented programming (OOP) principles will be an advantage
- Portfolio: completion of pet projects (personal educational projects) with a mandatory link to a Git repository to assess code style and problem-solving approach
- Willingness to work 5/2 from the office (Nizhny Novgorod, Nesterova, d.31)
Conditions:
- Work Format: office (N. Novgorod)
- Salary from 30,000 to 40,800 ₽ per month
- Schedule 5/2
Skills:
- Greenplum
- SQL
- Apache Airflow
- ETL
- ELT
- DWH
- PostgreSQL
- MySQL
- ClickHouse
- Python
- OOP
- Jira
- Git
