About Julian-Sebastian
German
Native or bilingual
Russian
Native or bilingual
English
Native or bilingual
Experience
- Bilthouse GmbHBusiness AnalystSOFTWARE PUBLISHINGOctober 2023 - Today (2 years and 10 months)München, GermanyPower 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.
- Bilthouse GmbHWorking Student Data & FinanceSOFTWARE PUBLISHINGOctober 2022 - October 2023 (1 year)Hamburg, GermanyEntry 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.
- Sparakassen Risiko RatingsSoftware Tester of a Correlation-Based Asset and Risk Management SystemBANKING AND INSURANCEApril 2019 - November 2019 (7 months)Berlin, GermanySoftware 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.
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
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master of Science Quantitative EconomicsChristian Albrechts Universität zu KielMathematisches VWL Studium mit überwiegend statistisch-ökonometrischen Inhalten. Fokus auf Wechselkursdynamik und Monetary Economics.
- Bachelor of Science Business AdministrationBrandenburgische Technische Universität Cottbus-Senftenberg2018BWL-Studium mit Vertiefung in Finanzmathematik, Ökonometrie und Makroökonomie. Thesis zur multivariaten makroökonometrischen Zeitreihenanalyse mit 1,0 als eine der jahrgangsbesten Arbeiten nominiert.