#vacancy #SystemAnalyst #Backend #SQL #UML #OpenAPI #Kafka #RabbitMQ #DWH #Finance #Logistics #GDPR #remote #middle #senior

System Analyst Salary: 160,000 RUB - 200,000 RUB Company: Codex-IT Grade: Middle+, Senior Location and Citizenship: Russian Federation Required Experience: from 3 years Format: Remote work

About the project: A large project in the finance or logistics sector (choice). Work on integration solutions, backend logic design, translation of business requirements into technical specifications for development and architecture teams.

🔘 Key Goal: Translate business requirements into detailed technical specifications for developers and architects.

📌 Tasks:

• Development of detailed technical specifications (TSD)
• Design of UML diagrams (Sequence, Component, State Diagram)
• Description of REST/SOAP API (OpenAPI / Swagger)
• Design of database schemas and writing complex SQL queries
• Design of integration solutions (synchronous/asynchronous, ETL, message queues)
• Work with DWH schemas (star, snowflake) and Data Lake / Data Warehouse concepts
• Interaction with developers, architects, and business stakeholders

📋 Requirements (mandatory):

• System analyst experience of 3+ years, focusing on integration and backend system logic
• Deep experience in developing technical specifications (TSD), UML diagrams (Sequence, Component, State Diagram), describing REST/SOAP API (OpenAPI/Swagger)
• Experience in designing database schemas, writing complex SQL queries (joins, window functions), understanding normalization
• Knowledge of integration principles (synchronous/asynchronous, ETL, message queues — Kafka / RabbitMQ)
• Mandatory experience in one of the subject areas:
  • Finance: data from GL (general ledger), invoices, payments, exchange rates, consolidation
  • Logistics: shipment data, cargo tracking, stock balances, routes
• Basic knowledge in data engineering and inter-system integrations (Data Lake, Data Warehouse concepts, "star"/"snowflake" DWH schemas, integration via data bus)
• Experience with architecture description tools (Draw.io, ArchiMate, PlantUML, Enterprise Architect, etc.)
• Understanding of security fundamentals (PII, GDPR) in the context of financial and transport data

➕ Will be a plus:

• Experience with Kafka / RabbitMQ in production
• Knowledge of Python or Java for prototyping
• Experience in data migration between systems
• Certifications (TOGAF, CBAP, etc.)

🙋 Conditions:

• Long-term project
• Full-time employment
• Remote work / hybrid (optional)
• Employment according to the Labor Code of the Russian Federation or self-employment/sole proprietorship