Data engineer

Data Analyst designs, develops and manages the Company information system, including data sources, data storage systems and reporting systems to obtain, store, process and report commercial information from a variety of sources. They work with business users and with Commercial Business Analysts to establish proper data architecture, automate ETL and reporting processes and create data reporting and validation tools. Data Analyst bears responsibility for proper documentation and version control of the information systems. Data Analyst is also responsible for the optimization and refactoring of the Company Data Warehouse and administration of the underlying IT infrastructure, in collaboration with external partners. Data Analyst is responsible either for integrating required reports into the Company information systems, including DWH and the Company BI system (QlikSense), or providing summary reporting and insights. In addition, Data Analystcan be involved in the development of various informational tools belonging to other business functions, wherever strong IT and systems expertise is required. ETL Deployment and Automation: Own the ETL (Extract-Transform-Load) process with third-party data providers, including research agencies, data service providers, distributors and direct customers, etc. Create and deploy automated ETL tools and procedures to ensure timely data collection from the providers in the most appropriate form; pre-processing, validation and screening of the data. Load the data into the Data Warehouse and ensure the integrity and validity of the updated datasets. Data Warehouse / System Maintenance and Administration: Work with providers to maintain Data Warehouse and other dedicated external servers: develop required functionality, manage and audit user roles and access rights, oversee the server administration from the Company side, monitor the software lifecycle and request required updates. Monitor the server and data warehouse performance and solve or prevent possible performance issues through code optimization, proper task scheduling or other means. Data Architecture and Uniformity: Build and maintain proper architecture of data stored at the Company Data Warehouse to ensure flexibility, scalability, reliability (including but not limited to proper version control) and performance. Build and maintain proper architecture of data in the Company BI System (QlikSense) to ensure flexibility, scalability and superior performance for both back-end tasks and end-user interactions. Document the changes to the system architecture, object and entity relations in accordance with industrial standards. Ensure uniformity of additional data sources being added to the Data Warehouse with the existing data architecture and document the data sources. Establish and maintain naming conventions and code style guidelines, document and communicate them to other system users, audit compliance. System Refactoring and Optimization: Review and optimize Data Warehouse code (SQL) and BI code to improve performance, readability and reliability. Lead the code review part of the change management process, i.e. ensure that existing code is properly adapted to the changes in business model, partners, utilized systems etc. Tools & Automation: Create queries and procedures to extract, load, convert, combine, transform or map particular datasets with specific conditions to be used for internal, external or technical reports. Create macros and programs for the automation of routine tasks in the ComAnt department or for other business users based on business needs and in line with company strategy and policies. Building Capabilities & Culture: Train the team on BI systems and other technical tools (e. g., advanced functions in Excel or Google Sheets) within area of responsibility and expertise. Requirements: Bachelor’s Degree (Analytics, Programming, Mathematics) Minimum of 3 years of prior experience as systems analyst or an SQL programmer in commercial environment Project management skills: development and monitoring of third-party informational, analytical and commercial systems Ability to build effective cooperation with providers to integrate BI systems, data change processes etc. Good understanding of Sales Process on E-commerce (Price, Promotion, Retail management) will be a plus Tools SQL - advanced knowledge as a must, including MS SQL Server administration. Experience with BI systems as a must, experience with QlikSense or QlikView as an advantage. Google Sheets, Google Big Query, Google Data Studio as an advantage MS Excel - advanced kills as a must, including developing macros in VBA Python (incl. Pandas), R for analytical purposes and other programming languages (front-end and back-end) as an advantage Knowledge of mathematical statistics and methods of statistical data analysis as an advantage