Вакансія SQL Data Analyst

Skills

• SQL
• PostgreSQl
• LibreOffice Calc
• JSON
• ClickHouse
• SSH

Опис вакансії

Required skills:

• Knowledge of SQL language, including PostgreSQL dialect;
• Skills in working with .csv files in LibreOffice Calc;
• Understanding of set theory basic concepts (sets and operations - intersection, union, difference);
• Understanding the order of SQL query execution;
• Understanding of the principles of relationships in relational databases (keys, primary-external);
• Skills in creating select queries with table join (INNER, LEFT, OUTER joins);
• Ability to build compound queries using CTE and subquery mechanisms;
• Knowledge of window functions work principles (window function);
• Knowledge and ability to apply aggregate functions;
• understanding of type conversion in SQL and working with strings (case change, to_char(), like, in);
• ability to work with stored JSON strings;
• ability to import and export records to the database.

Desired skills:

• Experience with Clickhouse;
• Experience with ssh.