You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Julian-Sebastian HilgemannJH

Julian-Sebastian Hilgemann

Business Intelligence Developer

€1,000/day
München, DE
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Julian-Sebastian

You get more than clean data - you get dashboards that accelerate decisions.

I help product and data teams prepare their data in Power BI so that reports not only are accurate but also used. From data modeling in dbt to complex DAX logic to the finished dashboard design - I take over the complete BI stack or step in precisely where it gets stuck.

What I specifically help with:
- Power BI Semantic Models: Calculation Groups, RLS, Field Parameters, clean DAX taxonomies
- Analytics Engineering with dbt + SQL - Kimball modeling, SCD2, reproducible pipelines
- Dashboard design with a real design claim: readable layouts, clear hierarchies, no chart cemeteries

What sets me apart:I come from business administration/econometrics, but have a strong visual eye - more pronounced than with most BI profiles. The result is dashboards that stakeholders actually open.

Typical projects: Building BI from scratch, refactoring existing Power BI models, interactive reporting layers on existing data warehouses.
  • German

    Native or bilingual

  • Russian

    Native or bilingual

  • English

    Native or bilingual

Remote only
Primarily works remotely

Experience

  • Bilthouse GmbH
    Business Analyst
    SOFTWARE PUBLISHING
    October 2023 - Today (2 years and 10 months)
    München, Germany
    Power BI dashboards for the executive board and leadership - from data modeling to finished dashboard design. Reports with 80+ monthly users, advanced DAX measures, Row-Level Security, and documented BI design standards in Figma and Zeroheight.

    Built a central star schema data model in dbt/Postgres that consolidates multiple billions in annual volume - reducing monthly KPI reporting from several days to a few hours.

    In addition, developed and produced a Python-based lead scoring model (sigmoid scoring via Postgres/dbt, results directly in Power BI) that controls Google Ads conversion uploads and SEA bidding.

    Furthermore, built revenue forecasting models based on cohort conversion logic and time series methods for C-level projections.

    Working method: close coordination with business stakeholders, LLM-supported workflows for documentation and prototyping, Git/GitHub, SCRUM.
    Microsoft Power BI Figma (Software) DBT Time Series Analysis Requirements Engineering
  • Bilthouse GmbH
    Working Student Data & Finance
    SOFTWARE PUBLISHING
    October 2022 - October 2023 (1 year)
    Hamburg, Germany
    Entry into the company through controlling and finance - with an increasing analytical focus.

    Developed automated FI/CO reporting tools for sales units. Built granular Excel financial models for cash flow analysis and PE fund reporting - focusing on data consolidation and decision-making basis for investors and consultants.

    Built granular Excel financial models to compare real estate cash flows against alternative asset classes - as a basis for decision-making for consultants in client discussions.

    In addition, automated private equity fund reporting: consolidated multi-source data and prepared it for investor relations.
    Microsoft Excel Macro VBA Excel Financial Modeling Budget Planning Controlling
  • Sparakassen Risiko Ratings
    Software Tester of a Correlation-Based Asset and Risk Management System
    BANKING AND INSURANCE
    April 2019 - November 2019 (7 months)
    Berlin, Germany
    Software testing for plausibility of a correlation-based asset and risk management system to verify compliance with BASEL regulations.
    Plausibility check of implemented calculations by replicating them in Excel/VBA.
    Microsoft Excel VBA Risk Analysis

Recommendations

Be the first to recommend Julian-Sebastian

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Master of Science Quantitative Economics
    Christian Albrechts Universität zu Kiel
    Mathematisches VWL Studium mit überwiegend statistisch-ökonometrischen Inhalten. Fokus auf Wechselkursdynamik und Monetary Economics.
  • Bachelor of Science Business Administration
    Brandenburgische Technische Universität Cottbus-Senftenberg
    2018
    BWL-Studium mit Vertiefung in Finanzmathematik, Ökonometrie und Makroökonomie. Thesis zur multivariaten makroökonometrischen Zeitreihenanalyse mit 1,0 als eine der jahrgangsbesten Arbeiten nominiert.

Skill set

Categories