Business/System Analyst

Date of placement:

15.03.2023

The vacancy is closed

Required work experience: 2-5 years.

Work schedule: full-time.

Responsibilities:
— Analysis of the customer's business requirements.
— Formalization and documentation of requirements: identification of project users; determination of access rights; study and systematization of project documentation in terms of identifying processes to be automated; preparation of documentation describing entities, relationships and processes of the subject area using special notations.
— Analysis of functional requirements for software.
— Writing technical specifications.
— Risk analysis in the development of systems.
— Software testing.
— Analysis of the causes of errors in the development of systems.

Requirements:
— Higher or secondary specialized education in the field of IT.
— Knowledge in the field of UX.
— Ability to compose SQL queries and work with databases.
— Experience with the target web browser developer tool.
— Knowledge of the basics of programming (including object-oriented), design, development, documentation of software.
— Knowledge of the basics of algorithm theory, database theory, systems theory and system analysis, fundamentals of information security.

Respond

ID	(3,4)	Class	SQL
0	0,28	DB	SELECT * FROM en_vacancies WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LI SELECT * FROM en_vacancies WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
1	0,22	DB	SELECT * FROM en_rubrics WHERE 1=1 AND (en_rubrics.furl='vacancy') AND active = :active AND activ SELECT * FROM en_rubrics WHERE 1 = 1 AND (en_rubrics.furl = 'vacancy') AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1	1
2	0,39	DB	SELECT * FROM en_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1 SELECT * FROM en_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 10000	1
3	0,21	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
4	0,14	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
5	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
6	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
7	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
8	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
9	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
10	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
11	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
12	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
13	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
14	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
15	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
16	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
17	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
18	0,12	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
19	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
20	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
21	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
22	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1
23	0,11	DB	SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000 SELECT string FROM en_config WHERE title = :title AND active = 1 ORDER BY id ASC LIMIT 1000	1

(3,4)

Class

SQL

0,28

SELECT * FROM en_vacancies WHERE id = :id AND active = :active AND active = 1 ORDER BY idx ASC LI

SELECT 
  * 
FROM 
  en_vacancies 
WHERE 
  id = :id 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  1

0,22

SELECT * FROM en_rubrics WHERE 1=1 AND (en_rubrics.furl='vacancy') AND active = :active AND activ

SELECT 
  * 
FROM 
  en_rubrics 
WHERE 
  1 = 1 
  AND (en_rubrics.furl = 'vacancy') 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  1

0,39

SELECT * FROM en_rubrics WHERE 1 = 1 AND active = :active AND active = 1 ORDER BY idx ASC LIMIT 1

SELECT 
  * 
FROM 
  en_rubrics 
WHERE 
  1 = 1 
  AND active = :active 
  AND active = 1 
ORDER BY 
  idx ASC 
LIMIT 
  10000

0,21