Position: Senior С#/.Net Engineer, ETL
Company: OSA HP
Experience required: 5y
English level: intermediate

**We offer:**
Office in the city center, metro Universitet
Possibility to influence the core product
Cooperation with SA (solution architect), challenging tasks
You can have an impact on product technical development 
You will have possibility to design and develop services from scratch 
Competitive salary.

**Project Description:**

Our product is focused on AI in retail and it includes:
Analytics interface. This is a constructor which works with set of metrics and generates client dashboards + reports
Reactive interface. Task manager which shows a tree of tasks to act on specific internal problems to decrease % of lost sales
Machine learning service that enriches data with predictions
ETL to collect retailer’s data


**Responsibilities:**
Design, implement new components and services
Integrate new pipelines
Process huge volumes of data (approx. 8 billion rows)
Performance optimization
Working with external API’s and services


**Mandatory Skills:**
5+ years of software development experience
C#, .NET Core 5.0 (3.0 - desirable), ETL
Experience with object-oriented software design and service-oriented architectures                     
PostgreSQL 11+
Strong experience with databases is a must, especially understanding of internal work of DB engines 
data storage algorithms (LMS, B-tree) 
Index types etc.
Successful candidate must be able to write effective and optimized SQL queries
Async I/O
Good written and verbal communication
Good team player
Knowledge of Scrum and Agile development
Experience in mentoring and developing junior colleagues

**Nice-to-Have Skills:**
ClickHouse or any other column-oriented DBMS
Message Brokers core understanding

**Some stats:**
2 TB of warm data
5000 active users in production
5 requests per second / user.