Data Analysts in Germany

Creation of workflows for generating the data basis for the article import of a web shop: combining data from several sources, analyzing the requirements, designing the process with Jupyter Notebooks and Knime. Also creating code for automation in Python using Polars and Pandas.

Processing the source data, filtering and merging the source files and creating the needed intermediate products, creating the upload files, plausibility checks, quality checks.

Technologies used: PyCharm, Python, Jupyter Notebooks, SQL, Knime. Pandas, Polars

• Developed and maintained dynamic 5 Power BI dashboards to report KPIs, identify trends, and uncover actionable insights.
• Collaborated with Marketing and Engineering teams to optimize and implement new marketing campaigns.
• Interpreted data to identify trends and actionable insights, collaborating with stakeholders to convert them to actions and optimisations
• Continuous improvement of reports to enhance understanding of business

• Analysis of the existing reporting platform including processes and governance topics with stakeholders from sales and marketing.

• Detailed analysis and evaluation of client-defined requirements for existing reporting and new dashboards.

• Supporting stakeholders in managing sales processes and early detection of KPI trends.

• Use of Microsoft Power BI as central analysis and reporting platform.

• Developing a proposal for the necessary evolution of processes and the Power BI platform.

• Gathering current business processes and defining company-wide KPIs in coordination with stakeholders.

• Analysis and inventory of the client's Power BI platform.

• Analysis of processes and data governance.

• Recording and documenting current business processes.

• Developing recommendations for process and reporting platform improvements.

• Designing and implementing dashboards in Power BI.

• Defining company-wide KPIs and aligning them with stakeholders.

• Microsoft Power BI.

• Data analytics.

• KPI definition and reporting.

• Dashboard design and data visualization.

• Stakeholder management and requirements management.

Specialize in turning complex data from diverse environments into actionable business value through compelling visual storytelling. I am an expert in generating actionable insights and presenting recommendations to business stakeholders. My technical proficiency in SQL, Python, and leading data visualization tools like Tableau and Power BI allows me to deliver a new generation of self-service tools and analytics services.

• Data Visualization & Storytelling: Created impactful data visualizations and dashboards in Tableau and Power BI, effectively communicating findings and presenting actionable recommendations to C-suite stakeholders and business leaders.
• Stakeholder Management: Built effective working relationships with key business stakeholders, data engineers, and other partners to achieve common data-driven goals and targets.
• Insights & Recommendations: Generated actionable insights from complex data analysis for funnel conversion, marketing performance, and ROI, directly influencing business performance and strategy.
• Data Collaboration & Empowerment: Worked closely with cross-functional teams to support the ongoing data needs of internal partners, helping to optimize internal data processes and workflows.
• BI & Data Expertise: Applied extensive experience in data modeling, data collection, data mining, and analysis to deliver end-to-end analytical solutions from stakeholder discovery to production.

• Developed & maintained customer analytical reporting solutions to identify revenue trends, performance drivers, risks & optimization opportunities to ensure data driven decision making across Sales, Finance, Product, Data Engineering & Controlling.
• Defined & analyzed customer trends & performance metrics to identify root causes behind variances, anomalies & emerging risks across business domains to deliver actionable recommendations.
• Developed & owned analytical data models & reporting layers to ensure scalability, performance & analytical robustness to support executive & operational reporting across business domains.
• Planned, tracked & executed projects by ensuring adherence to timelines, data accuracy, consistency, deliverables, reliability & data quality standards through rigorous validation & reconciliation processes.
• Raised the analytical maturity by formalizing analytical workflows, documenting data processes & standard operating procedures (SOPs) & conducting training sessions to drive adoption of self-service analytics & embed a data driven culture across operational and business teams.
• Took ownership of the end-to-end lifecycle roadmap from requirement gathering, collection, transformation, developing robust business logics to data storytelling & stakeholder delivery.
• Converted complexity into structured clarity by translating requirements & business processes into analytical recommendations to ensure alignment between non-technical & technical stakeholders.
• Conducted advanced SQL based analysis of complex business datasets to uncover trends, correlations & performance improvement opportunities.
• Drove process automation & efficiency improvements by leveraging Python, SQL optimization & AI assisted tools to reduce processing time & increase reliability across analytical & operational workflows.
• Standardized KPI definitions & reporting logic to ensure consistency & trust across reporting solutions.
• Developed process monitoring dashboards & analyses to identify inefficiencies, bottlenecks & compliance deviations across end-to-end business processes to derive actionable recommendations for process improvement & automation.

• Perform extensive quantitative and qualitative data analysis on high-volume macroeconomic datasets, tracking inflation indicators, interest rates, and sentiment metrics to evaluate multi-asset market dynamics across Forex, global equity indices, and commodities.
• Structure, categorize, and annotate complex market data across multiple timeframes to establish clean inputs for pattern recognition and technical modeling.
• Develop, test, and debug algorithmic logic and custom indicator scripts using Pine Script, performing systematic error analysis and edge-case validation.
• Execute rigorous data verification and quality control on live financial feeds to eliminate noise, false signals, and data anomalies.
• Utilize statistical frameworks and risk analytics to optimize capital allocation, position sizing, and risk-to-reward ratios under volatile conditions.

• Built a Python pipeline that converts lectionary web content into structured daily JSON, applying liturgical-calendar rules for accurate weekday and Sunday coverage.
• Shipped a read-only FastAPI REST API with shared Pydantic models and delivered a Kirundi-first web client for browser and mobile use.
• Owned the data layer and backend architecture, collaborating closely on system architecture and interfaces while automating refreshes with GitHub Actions and validating the ETL with pytest.
• Impact: Created a reliable, API-driven source of truth for daily Bible readings in Kirundi, enabling consistent access to previously unstructured content.

• KPI dashboards for inventory and goods received quality control & testing ETL, dataset, dataflows and report development, complex DAX solutions

Data sources: Dataverse, RDB, Excel

Tools: ETL, data modeling, data flows, Power Query, M, Power BI, complex DAX

• Capacity: 25%

• Analysis of web and campaign performance to derive actionable insights for marketing and growth optimization
• Implementation and maintenance of tag management solutions to ensure reliable and consistent data collection
• Continuous development and optimization of reporting structures with a focus on scalability and data quality
• Conducting regular deep-dive analyses and leading monthly stakeholder sessions to present findings and align on optimization measures
• Designing and managing end-to-end data flows from data collection to visualization
• Tools: GA4, Google Tag Manager, Looker Studio, Airbyte, BigQuery

• Supported the International Web Presence project of the Federal Employment Agency (IntWeb) in quality management, taking on responsibility for the quality of processes and project deliverables while adhering to BA standards. The project's main goals are to give professionals abroad a quick overview of their chances to move to Germany and to enable them to take the necessary steps in a consistently digital way.

• Set the fundamental guidelines using the QA handbook

• Summarized test results in QA reports for PLA

• Analyzed project outcomes for improvement opportunities

• Quality management of requirements analysis (especially processes, methods and tools)

• Ensured compliance with SERA guidelines

• Created a cross-project test concept

• Agreed on sprint completion reports

• Conducted formal reviews of deliverables according to guidelines and/or project plan

• Acted as contact person for internal audit and external audits by auditors or the Federal Audit Office (BRH)

• Technologies: JIRA, Confluence, MS Office, GitLab, Kubernetes

• Performance optimization and centralization of reporting by creating data models using SSMS (SQL) & SSAS (DAX) and integrating data via SSIS
• Optimizing and extending the current PowerBI dataset (in parallel until the SSAS data model is ready)
• Expanding current reports (migrating reporting to SSAS source after building the SSAS data model)
• Conducting regression analyses, cohort analyses, price/quantity analyses, and strategy project success analyses
• Training internal team members

• Completed an intensive AI Engineering Program focused on LLM evaluation, retrieval, agent orchestration, and multimodal workflows.
• Designed retrieval pipelines with document ingestion, semantic search, and citation-aware outputs using LangChain and ChromaDB.
• Built LangGraph-based agent workflows with state handling, clarification loops, and human-in-the-loop approval steps.
• Applied prompt engineering and evaluation patterns, including scoring logic and guardrails, to improve output quality and reliability.
• Worked extensively with Python, FastAPI, OpenAI APIs, LangChain, LangGraph, and ChromaDB in end-to-end implementations.

• Analysis of process data
• Data preparation with SQL
• Development of reports & dashboards in Celonis

• Manage WordPress websites, ensuring SEO-friendly structures and high-performance functionality
• Create and optimize Google Ads campaigns, leveraging data to enhance conversion rates and ROI
• Develop Looker Studio & Power BI dashboards to track customer behavior, sales trends, and digital performance
• Implement Google Tag Manager (GTM) and Google Analytics (GA4) to enable precise event tracking and reporting