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. We create, serve 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 Database Developer. What will you do? Development of solutions based
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. We create, serve 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 Database Developer. What will you do? Development of solutions based on the PostgreSQL database. Support and development of existing data models, creation of new DWH design. Optimization of this support. Creation and optimization of ETL workflow, design and optimization of database architecture, design and development of dashboard reports in accordance with 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 solutions based on data About you Professional experience working with PostgreSQL (DBengine, SSIS, SSRS, SSAS), at least 3 years of experience as a developerExperience construction of ETL processes. Desirable experience in designing DWH and OLAP cube stores, developing SSRS reports (at least 2 years) Confident knowledge of SQL. Writing on a persistent basis functions, store procedures, triggers, views, calculations, ctes, recs. Skills of query plan analysis Experience of working with highly loaded and extremely large databases (from 5-10 TB) Ability to quickly understand code without understanding the business process Python 3 + 2 years of experience as a developer, knowledge of NumPy and Pandas libraries, writing clean and readable scripts Working with frameworks and setting up API methods for data exchange Managing projects in Git , working with CI/CD settings Level of English language B1 will be an advantage PostgreSQL Server administration skills Experience with BI tools Power BI/Tableau/Google Looker 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 and appreciates the ideas of employees and develops together with us The opportunity to directly influence the creation of a product that is used by millions of users The opportunity to work remotely or in a modern office, if desired Send your resume, let's get to know each other :)