Required skills
- Power BI
- Databricks
- Azure Databricks
- Data Modeling
- Dimensional Modeling
- Star Schema
- DAX
- Row-Level Security
- Data Mart
- Semantic Model
- Microsoft Azure
- Business Intelligence
Languages: German
Job description
Seeking an experienced Power BI Developer for a new data platform based on Microsoft Azure and Databricks. The role involves designing the data layers and Power BI semantic model for reporting and selections.
Project overview
For our client, an insurance company in the greater Frankfurt am Main area, we are looking for an experienced Power BI Developer as part of the setup of a new strategic data platform (Lakehouse) based on Microsoft Azure and Databricks. You will design the Gold layer and the semantic Power BI model, which will be the basis for sales and campaign reporting as well as selections, and will support the client's reporting team in implementing the reports.
Responsibilities
- Design of the reporting-ready Data Mart/Gold layer (facts, dimensions, reusable business KPIs) together with Data Engineering
- Development of the semantic Power BI model with measures (DAX), relationships, hierarchies, drill-downs, and authorization logic (Row-Level Security)
- Contribution to sales and campaign reports as well as logic for customer and campaign selections
- Definition of reusable reporting standards and UX guidelines, as well as ensuring performance and release capability
- Validation, report testing, and troubleshooting together with the business departments
- Documentation and enablement of key users and the internal reporting team
Requirements
General Framework Conditions
- Several years of experience in developing Power BI solutions in an enterprise environment
- Very good knowledge of semantic models, DAX, Row-Level Security, and deployment processes
- Experience in connecting Databricks or Lakehouse platforms (Databricks SQL, Delta Lake)
- Sound knowledge of dimensional modeling (Star Schema)
- Experience with sales, customer, or campaign KPIs in the insurance or financial sector is an advantage
- Strong communication skills in exchange with business departments
- Certifications (e.g., PL-300, DP-600) are an advantage
- Fluent German and good English skills
- Workload: 80–100%
- Start: Beginning of November 2026
- Duration: until 03/31/2027 with an option for extension (follow-up phases planned until the end of 2028)
- Work location: Greater Frankfurt am Main area (Germany)
- Onsite/Remote: High onsite component in the first 2-3 months (3-4 days per week), then approx. 2 days onsite, rest remote
- Client interview: Availability for interviews with the client at the end of October 2026
Project details
- Start: 2026-11
- Duration: 6 Monate
- Remote: hybrid
- Location: Frankfurt, Deutschland, DE
- Languages: German
Indexed by 9am's meta-search. You are a job provider? Claim or manage this listing
Found on FreelancerMap DE