BI Developers in Germany

Tools: Fabric, AWS, dbt, Power BI, SQL, DWH, R, Python

• Supported customers in implementing an architecture design for extracting and preparing data
• Planned the design and implementation of the BI and DWH platform
• Ensured the scalability and performance of the data platform

Embedded Analytics & AI-assisted BI

Design and development of an integrated analytics solution based on ASP.NET Core, Power BI Embedded, and LLM services to provide contextual business information.

Development of an AI agent with Function/Tool Calling for secure orchestration of REST APIs, SQL data sources, and technical services within defined business processes.

Build-up of automated BI workflows including workspace management, deployment processes, and scheduled refresh via the Power BI REST API.

Implementation of secure service-to-service communication with Microsoft Entra ID and service principal, as well as integration into existing enterprise system landscapes.

Technologies: ASP.NET Core, C#/.NET, Power BI Embedded, Power BI REST API, LLM API, AI Agents, Function/Tool Calling, Entra ID

Focus areas: knowledge transfer, reporting, cost analysis Tasks

• Ensure knowledge transfer from the outgoing controller
• Document key controlling processes
• Operational controlling (cash flow planning, reporting)
• Simplify the cost center structure to improve cost analysis Results
• Transparent knowledge transfer and sustainable documentation of controlling processes
• Improved cost analysis and more efficient reporting

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.

• 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.

• Support during SSRS implementation, including training employees on SSRS

• Automated Python-based analysis of test script repositories
• Built a SQLite database for signal and value tracking
• Identified critical discrepancies with ad-hoc SQL queries
• Technologies: Python, SQLite, Excel/ODBC

• Analysis of complex business processes and end-to-end user journeys in digital product and platform environments
• Gathering, structuring, and prioritizing business and technical requirements (Functional / Non-Functional Requirements)
• Translating business goals into actionable requirements, user stories, and acceptance criteria
• Conducting stakeholder interviews, workshops, and reviews with business teams, IT, UX, and management
• Creating and maintaining requirement artifacts (BRD, FRD, user stories, process models, decision papers)
• Ensuring consistency between business needs, technical implementation, and product vision
• Close collaboration with development teams to clarify business questions during implementation
• Support with impact analyses (A/B tests), change requests, and scope management
• Quality assurance of implemented requirements including acceptance criteria and business testing
• Advising on the further development of product strategy and roadmap structure
• Prioritizing backlog items based on business value
• Defining and sharpening product goals, KPIs, MVP definition, and other success metrics
• Evaluating new features, tools, and initiatives from a user and business perspective
• Facilitating decision-making between business, product, and technology
• Supporting go-to-market considerations and product positioning
• Sparring partner for product and stakeholder decisions at management level
• Dashboard creation, data modeling, BI report administration, and data analysis in Power BI

DWH for customer and financial data

• Extension of the DWH with new data sources
• Report development
• Data quality management

Methodology: Scrum

Tools: Atlassian Confluence & Jira

Databases: Microsoft SQL Server

Programming languages: SQL, T-SQL

ETL: Microsoft SQL Server Integration Services (SSIS)

Frontend platform: PowerBI, Microsoft Reporting Services

• Evaluate, design, and implement Power BI solutions for Cat4 reporting, significantly improving reporting efficiency, accuracy, and stakeholder visibility.
• Develop and maintain robust data integration interfaces between Cat4 and Power BI, eliminating manual processing bottlenecks.
• Configure and continuously optimise Power BI reports to deliver sharper management insights and support data-driven decision-making.
• Ensure full GDPR data protection compliance across Power BI reports, proactively identifying and mitigating risks.
• Acquired in-depth product knowledge of CAT4, a globally deployed enterprise platform, enabling effective requirements analysis, solution design, and seamless Power BI integration across client environments.
• Developed and integrated scalable reporting templates within the CAT4 product interface, delivering new product features and enhancing data visualisation, reporting efficiency, and stakeholder visibility across global users.
• Trained and mentored staff on Power BI configuration and best practices, accelerating adoption and embedding a data-driven culture.
• Prepared clear technical documentation and delivered hands-on demonstrations to end users and clients, ensuring smooth adoption and confident use of Power BI solutions integrated with CAT4.
• Researched and recommended licensing strategies for cost-effective and scalable Power BI deployment.

SKILLS - BI & Visualisation: Power BI (Desktop, Service, Report Builder), DAX, Power Query

Project and Product Management Tool: CAT4

• Data Management of Oracle based Data Warehouse
• Operational monitoring of DWH
• ETL Processes in Oracle SQL
• Consulting in reporting and DWH development
• Developing Dynamic List, Grid, Jxls, Pivot Reports in Report Server
• Data visualization in Report Server

• 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%

Project description: Design and step-by-step implementation of a central, multidimensional controlling platform based on IBM Planning Analytics to optimize and automate internal company planning and reporting.

Business & technical consulting: Analyzed the provided operational base data and proactively advised the controlling team on cube design best practices and optimal dimension structures.

Data integration & ETL: Designed and developed robust TurboIntegrator processes for automated data loading, transformation, and dimension maintenance.

Logic & business implementation: Implemented complex business logic and calculations with high performance using TM1 business rules (including efficient skipping/feeding).

Development of a Python HTTPS server to integrate an input widget in IBM PAW, enabling direct data write-back to TM1 cubes via the TM1 REST API.

Reporting & analytics: Created dynamic, user-friendly reports and dashboards for management and specialist departments.

• Establishing the Microsoft Fabric platform with the company as the central data warehouse and reporting system.
• The company migrated several operational systems including D365 to new version. The new data warehouse is based on a Fabric/Power BI architecture with Azure cloud Entra Authentication.

Tasks Performed:

• Full administrative responsibility for the Fabric platform F64 and F32 capacities, as well as two F8 capacities for development and prototyping.
• Integration of Fabric with Microsoft Entra.
• Data modeling for the data warehouse bronze, silver and gold layers using data modeling tools.
• Star Schema as well as entity relationship modeling.
• Data modeling for data marts and for dimensional modeling and Power BI (semantic model).
• Design of data models for Microsoft SSAS multidimensional and tabular OLAP cubes using DAX and MDX.
• Definition of design patterns for the ETL team for loading OLAP cubes (Tabular and MD), star schemas and data vault structures.
• Planning and managing team of 4 ETL and reporting developers.
• Performance Tuning of Power BI reports, particularly the semantic layer, as well as the Fabric notebooks
• SQL Performance Tuning.
• DB Design for Azure SQL.
• Reporting directly to project senior management.

Label: Power BI, Fabric, Analysis Services (multidimensional and tabular), D365, SSIS, Tabular Editor, SQL Server and Azure SQL, TOAD Data Modeler, DBSchema, Visual Studio Code, DAX Studio, SSMS, Visual Studio, Jira and Confluence.