Data Management Specialist

12/2020 – offen

Responsible for developing business intelligence (BI) solutions to analyze
corporate data.
Performing data extraction, transformation and loading (ETL) processes to
integrate various data sources into the BI system.
Creating and optimizing dashboards and reports to visualize company key
figures.
Managing and maintaining corporate databases and data warehouses.
Developing and implementing data quality standards and guidelines.
Monitoring data integrity and security.
Performing data analysis to identify opportunities for improvement in the data
management process.
- Monitoring data quality and making adjustments in case of discrepancies;
- Database management, including updating and adapting to business
requirements;
- publication of preliminary and declared sales of the month BPM
- a key role in the transition to a new database by reorganizing existing
procedures and processes and adapting data models and calculation files to
the new data source
- management of data management processes in the company;
- management of processes performed by outsourced employees (2 people)
- the quality assurance of data loading, including logging and fixing data
inconsistencies between initial reports and the database;
- control over the connection of dealers to the operational portal, checking the
correctness of transfer data;
- Checking the completeness of the data provided from partner reports: finding
discrepancies, their causes, communicating with dealers, making confirmed
adjustments to the database, monitoring the permissible convergence limits
deviations, monthly monitoring of up to 40 partner reports
- global control of inventory levels: providing calculated analytics by country
and business area, making changes to the calculation taking into account
changes in control requirements
- visualizing reports in Power BI for business teams;
- Role of Scrum Master in a consolidated analytics project

Datenanalyse, Power Bi, Microsoft SQL Server Analysis Services (SSAS), Data Vault, Administration von Datenbanken, Microsoft SQL-Server (MS SQL), Mysql, Open Database Connectivity, SQL, VBA (Visual Basic for Applications), Microsoft Powerpoint

7/2020 – 7/2021

- quality assurance of data loading, including logging and fixing data
inconsistencies between initial reports and the database;
- control over the connection of dealers to the operational portal for retrieving
data sales, inventories and receipts from the supplier, checking the
correctness of transfers data;
- management of an operational data transfer portal;
- monthly correction of reallocations [reallocations] in the database
- checking the completeness of the data provided from partner reports:
searching for discrepancies, their causes, communicating with dealers,
making confirmed adjustments to the database, monitoring the permissible
convergence limits discrepancies, monthly monitoring of up to 20 partner
reports;
- updating dealer report data in the database
- checking the correctness and loading of weekly reports;
- Participated in the development of a calculator for an indicator, where the
data source was several portals, databases, tables, writing formulas
- Conduct training on Qlik Sense reports and advise managers on the data of
these reports. Calculate a sales time series forecast for loading into Qlik Sense
in Python
- Preparation of part of the data for external audit

Business Intelligence (BI), Data Warehousing, Administration von Datenbanken, Open Database Connectivity, Greenplum

6/2019 – 7/2020

- Working with pivot tables
- Market analysis based on vendor data;
- Big data analysis using Python functionality, visualization, pilot project,
testing;
- Participation in a project related to obtaining, analyzing, checking and
verifying data from medical electronic systems and electronic prescriptions;
- Participation in the design of a dashboard on the Qlik Sense platform:
writing small loading scripts, customizing dashboards in the functional editor,
uploading, visualizing, advising managers on data issues reflected in Qlik
Sense reports;
- Advising managers on the correctness of uploading data from the portals
they are interested in; on issues of customizing reports and setting up pivot
tables;
- Preparation of business presentations as part of current projects;
- Uploading reports on request from various sources
- All types of data reconciliation using various tools

Business Intelligence (BI)