MS Office
Wojciech Hagel
Analytics Engineer
Berlin
Summary
Analytics professional with proven ability to transform complex data into actionable insights. Skilled in data modeling, SQL, and Python, with strong focus on team collaboration and achieving results. Known for flexibility in adapting to changing needs, delivering reliable and impactful solutions. Proactive problem-solver with keen analytical skills and strategic mindset.
Overview
5
5
years of professional experience
3
3
Languages
Work History
Analytics Engineer
Enter
12.2024 - Current
- Responsible for redesigning the current data warehouse architecture by implementing a Snowflake schema, specifically tailored to Enter's reporting needs. This includes reworking all layers in the DBT project from staging, to cleaning, core, and finally the marts layer
- Taking care of the backend part of transitioning from Salesforce-based reporting to an event-based approach, leveraging Amazon's S3 for more scalable and flexible data storage and processing
- Building and maintaining new ETL pipelines using Airbyte and Python, ensuring the efficient flow of data between systems while meeting the company's evolving data needs
Analytics Engineer
Enpal
10.2023 - 11.2024
- As part of the Analytics Engineering group, I participated in and was responsible for implementing the best possible data models, following industry best practices while ensuring the models were tailored to meet Enpal's specific reporting needs. This significantly enhanced the quality and efficiency of the data flow supporting business decision-making
- Continued managing the 140+ KPI performance report while decentralizing its ownership by distributing responsibility to BI Domains aligned with business areas. Focused on ensuring smooth data delivery and maintaining data quality, while BI Domains handled stakeholder management
- Took ownership of the NPS (Net Promoter Score) reporting process, improving the underlying data structure and enhancing the overall report. Additionally, I automated the distribution of the NPS report via Microsoft Teams, ensuring seamless and timely delivery to key stakeholders
Business Intelligence Analyst
Enpal
09.2022 - 09.2023
- Managed a company-wide performance report tracking 140+ KPIs, reviewed daily by C-Level management to drive strategic decisions
- Served as the primary point of contact for stakeholder requests across departments, gathering requirements and implementing changes to ensure the report met business needs
- Spearheaded the transformation of the report from a manual Excel file to an automated Tableau dashboard, improving reporting accuracy and efficiency
- Built and optimized the underlying data flow for the Tableau dashboard, ensuring seamless integration and accurate, up-to-date information
- Contributed to the automation of the report distribution process, enabling automatic delivery to C-Level management and key stakeholders, streamlining communication and reducing manual effort
- Played an integral role in migrating from the Microsoft stack to DBT & Snowflake, ensuring a smooth, uninterrupted transition while maintaining the accuracy of the 140+ KPI report throughout the process
Business Ingelligence Analyst
Bank of Scottland
11.2020 - 08.2022
- Managing multiple stakeholders, translating their business needs into efficient BI solutions and data-driven insights
- Developing and optimizing data models for Power BI to create accurate and actionable financial insights that support business decisions and reporting
- Conducting requirement analysis and developing T-SQL scripts to support data extraction, transformation, and reporting processes
- Working with sensitive financial data, ensuring high levels of accuracy and consistency, as the data is critical for regulatory reporting compliance
Business Ingelligence Analyst / Developer
Igefa Handelsgesellschaft
11.2019 - 11.2020
- Developed reports for internal stakeholders to provide insights into customers' journeys within the company, enabling data-driven decision-making
- Led the development of a data warehouse from scratch, ensuring that it was designed to meet business requirements and support the organization's data analysis needs
- Designed and implemented ETL processes, ensuring the efficient extraction, transformation, and loading of data for analysis
- Created OLAP cubes to support multidimensional analysis and improve the efficiency of querying large datasets
Education
Bachelor of Science - Business Informatics
Hochschule Für Wirtschaft Und Recht Berlin
Berlin 04.2001 -
Skills
Power BI tools
Python programming
ETL development
SQL database management
Data quality assurance
Tableau software
Data warehousing
Critical thinking
Data integration
Time series analysis
Software
Interests
Gaming
Series binging
Swimming
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Analytics Engineer
Enter
12.2024 - Current
Analytics Engineer
Enpal
10.2023 - 11.2024
Business Intelligence Analyst
Enpal
09.2022 - 09.2023
Business Ingelligence Analyst
Bank of Scottland
11.2020 - 08.2022
Business Ingelligence Analyst / Developer
Igefa Handelsgesellschaft
11.2019 - 11.2020
Bachelor of Science - Business Informatics
Hochschule Für Wirtschaft Und Recht Berlin
04.2001 -