Responsibilities:
- Database Design and Support: Development and maintenance of database objects (tables, views, indexes, stored procedures) in the Greenplum environment.
- Data Mart Development: Design and calculation of metrics for data marts to meet business needs 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, logging issues and deadlines in tracking systems (Jira).
Toolset: Jira, Confluence, Greenplum, Apache Airflow.
Requirements:
- Higher IT education.
- SQL Proficiency: Solid knowledge of syntax and core constructs (SELECT, INSERT, JOIN), experience 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: Availability of completed pet projects (personal educational projects) with a mandatory link to a Git repository for assessing code style and problem-solving approach.
- Readiness to work 5/2 from the office (Nizhny Novgorod, Nesterova, d. 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.
- Opportunities for growth from junior developer to lead specialist, manager.
- For your growth, we will use a modern approach to learning and development (experienced mentor, many 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 across Russia.
- We not only work hard but also play hard. You can find activities 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).
