Data Analyst - Client Microsoft GmbH
Creakom Business Solutions GmbH
München
01.2022 - Current
- Planning and creating management and partner reports on local incentive campaigns and local custom deals
- Analyzed large datasets to identify trends, patterns and correlations for business insights.
- Developed dashboards with Power BI to monitor key performance indicators.
- Gathered requirements from stakeholders to design data models and reports.
- Leveraged SQL queries to extract, transform and load data into databases.
- Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.
- Optimized existing database structures for better performance on analytics tasks.
- Collaborated with stakeholders across the organization to understand their needs from a data perspective.
- Maintained documentation of all the processes related to Data Analysis.
- Performed quality assurance testing on newly developed reporting solutions.
- Utilized advanced analytics tools such as Excel PowerPivot, to manipulate large volumes of structured and unstructured data sets.
- Worked with internal teams to understand business needs and changing strategies.
- Interacted with non-technical stakeholders to deliver analyses and answer questions on deliverables.
- Provided technical support for existing reports, dashboards or other tools.
- Requirement engineering and analysis
- Regular updating and checking of the reports created
- Coordination with BI and reporting teams
- Advising the customer on process optimization and the resulting implementation
- Finding solutions and correcting report errors
- Experience in writing complex stored procedures, job creation for ETL
- Develop visualizations for conveying key insights and reports
- Implementation of 5+ dashboards from Excel to SQL and Power Bi
- Utilized MS SQL, SSIS, PBI dashboards and Excel/Power Pivots for data intelligence and analysis
- Modeling database objects in relational databases
- Convert data into actionable insights by predicting and modeling future outcomes
- As part of an agile team, I have developed meaningful data analysis and visualize them in reports and dashboards
