Job Opportunities in Ukraine
March 25, 2022
KeepSolid
Одеса
SQL Data Analyst
Required skills:
- Knowledge of SQL language, including Postgre SQL dialect;
- Skills in working with .csv files in Libre Office 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;
New Jobs from This Company