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: conducting initial testing and validation of load results, ensuring data integrity and reliability.
- 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, fixing problems and deadlines in tracking systems (Jira).
Toolset:
Jira, Confluence, Greenplum, Apache Airflow.
Requirements:
- Higher IT education.
- 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: possession of completed pet projects (personal educational projects) with a mandatory link to a Git repository for evaluating code style and approach to problem-solving.
- Readiness to work 5/2 from the office (Nizhny Novgorod, Nesterova St., 31).
Conditions:
- Work in an accredited IT company with over 30 years of experience in implementing thousands of projects.
- Work on a banking project.
- Five-day work week, from 9:00 to 18:00 or from 10:00 to 19:00.
- Opportunity for growth from junior developer to lead specialist, manager.
- For your growth, we will use a modern approach to training and development (experienced mentor, numerous free courses for professional development).
- You will be a member of a strong team of experts and have the opportunity to share experience with colleagues throughout Russia.
- We not only work well but also have fun. You will find events to your liking and participate in them voluntarily: informal events, intellectual games, our own Cyber League, opportunities for volunteering and charity, creative evenings, and more.
- Voluntary medical insurance (DMS).
