Keepsolid Career
At KeepSolid, our main goal is to improve company efficiency, while improving employee performance with all of our employees.
While developing modern products, we simplify complex tasks by offering simple solutions compatible for various devices that are available worldwide.
Our team of experts realize that software is just a tool that helps achieve results. We understand there is a human element with development, which is why we combine information technology, case analysis, and solve problems for our users in a timely and professional manner.
CV Requirements
-
A CV should include:
- Applicant’s photo
- An employment history (covering the previous company names, projects the candidate worked on, and for how long)
- Education
- Marital status
- Contact details
- Each employment history entry should contain:
- A detailed description of job duties and responsibilities
- A list of quantified achievements
- Highly desirable: a list of contacts for references, who can confirm the above
- CVs are accepted in PDF file only.
- Additional documents, if any, can be attached to a cover letter in a separate archive.
- All external links, e.g. a link to LinkedIn profile, or Google Docs, without a PDF CV attached, will not be considered.
SQL Data Analyst
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;<.li>
- 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.
- Experience with Clickhouse;
- Experience with ssh;