Project specification
Project expertise
Description
A company is looking for an experienced Senior BI Consultant / Data Analyst (m/w/d) with a strong understanding of business and expertise in Sales & Marketing Analytics. The goal of the project is to represent and analyze the entire Sales and Marketing pipeline based on data – from lead generation through to revenue closure.
The freelancer will act as the central interface between the business departments and an international Data Engineering team that operates the existing data platform based on Microsoft Fabric. We are looking for a proactive BI expert who critically questions business requirements, develops suitable KPI and reporting concepts, and implements them hands-on in Power BI.
Main responsibilities:
- Independently gather, analyze, and structure business requirements from Sales and Marketing
- Design and further develop comprehensive Sales and Marketing reporting along the Customer Journey
- Define and validate relevant KPIs such as Lead Conversion, Sales Pipeline, and revenue development
- Analyze existing source systems, such as HubSpot, and model the underlying data structures
- Translate business requirements into technical data requirements and coordinate with the Data Engineering team
- Develop and optimize Power BI dashboards and reports
- Conduct ad-hoc analyses and derive data-based recommendations for action
- Ensure a consistent reporting and KPI structure in collaboration with the business departments
Requirements
Must-have:
- Several years of experience as a Senior BI Consultant, Data Analyst, or Business Intelligence Specialist
- Very good knowledge of Power BI, DAX, and SQL
- Experience in data modeling and developing BI reporting solutions
- Proven experience with Sales, Marketing, or Revenue Analytics projects
- Understanding of Sales Funnels, Lead Management, and sales-relevant KPIs
- Experience in Requirements Engineering and working with business departments
- Ability to translate business requirements into technical data requirements and BI solutions
- Analytical and conceptual skills
- High level of independence, proactivity, and strong communication skills
- Very good German and English skills
Nice-to-have:
- Experience with Microsoft Fabric and the Microsoft Azure data environment
- Knowledge of CRM and ERP data structures, especially HubSpot
- Experience integrating and analyzing HubSpot data in Microsoft Fabric and Power BI
- Experience working in international project teams and building comprehensive Lead-to-Revenue reporting solutions
We are looking for a BI all-rounder who can bridge the gap between Business and Data Engineering. The ideal candidate should be able to capture unstructured requirements, understand business relationships, define meaningful KPIs, and develop reliable reporting solutions. An independent and solution-oriented approach to work is essential.
Not applying this time?
Get notified about similar projects matching your experience.
Frequently asked questions
The project is based in Germany.
The project preferably starts in December 2026 and is planned to end in May 2027 (5 months).
The project offers 0 - 100% remote work.
The project requires the following languages: German (Advanced) and English (Advanced).
The project is related to the following industry: Professional Services.
The project covers the following business areas: Business Intelligence, Marketing, and Sales.
Yes! Recommend a freelancer for the project and earn 30% of FRATCH's profits every time they get placed — for the duration of that project. Simply share your invite link with a colleague to get started.
To apply for the project, click the Apply button on the project page to submit your profile for review. We will forward your resume to the client and get back to you within a few days.
Join other experts who are already part of our network
