The Ukrainian IT company Nova Digital, which is part of the NOVA group of companies, is a powerful manufacturer of web applications and software for architectures of any complexity and load on them. We create, maintain and constantly improve software products, the convenience of which has already been appreciated by 32 million private and business clients of Nova Poshta. We are expanding our team, so we are currently looking for a Middle Python Database Developer. What will you do - Development
The Ukrainian IT company Nova Digital, which is part of the NOVA group of companies, is a powerful manufacturer of web applications and software for architectures of any complexity and load on them. We create, maintain and constantly improve software products, the convenience of which has already been appreciated by 32 million private and business clients of Nova Poshta. We are expanding our team, so we are currently looking for a Middle Python Database Developer. What will you do - Development of solutions based on the PostgreSQL database. Support and development of existing data models, creation of new ones - DWH design. Optimization and its support. Creation and optimization of ETL workflow, design and optimization of database architecture - Design and development of reports and dashboards according to customer requirements. Implementation of calculation logic, formation of data showcases - Creation of subscriptions, reports and analytical dashboards, support and improvement of existing assets - Cooperation with teams of developers, analysts and business users to develop and implement data-based solutions About you - Python 3+ experience as a developer from 2 years, knowledge of NumPy and Pandas libraries, writing clean and readable scripts - Confident knowledge of SQL. Writing on an ongoing basis functions, store procedures, triggers, views, calculations, ctes, recs. Query plan analysis skills - Experience in building ETL processes. Desirable experience in designing DWH storages - Experience in working with highly loaded and extremely large databases (from 5-10TB) - The ability to quickly understand the code without understanding the business process - Working with frameworks and configuring API methods for data exchange - Managing projects in Git, working with branches and setting up CI/CD English level B1 Will be an advantage - Professional experience working with PostgreSQL (DB engine, SSAS) as a developer - PostgreSQL Server administration skills - Experience working with BI tools Power BI/Tableau/Google Looker - Experience working in logistics companies We offer - Official employment - Paid vacation - Medical insurance - Necessary equipment for work - Corporate culture that motivates and charges with positivity - Work in a socially responsible company that follows trends, values the ideas of employees and develops together with them - The opportunity to directly influence creating a product that is used by millions of users - The possibility of working remotely or in a modern office, if desired Send your resume, let's get to know each other :)