Karthik Kannepalli

Senior BI Developer and Analytics Engineer with 8+ years of experience designing scalable data platforms, ELT pipelines, and analytics solutions across Germany and India. Experienced in building production-grade workflows with Airflow, Databricks, Python, and SQL, implementing Medallion Architecture, and developing dimensional data models supporting reporting for a €72M revenue portfolio. Proven track record of automating BI processes, improving data reliability, and translating complex business requirements into scalable, analytics-ready data products

0+
Years experience
0
Languages
0
Skills
Work Experience
Senior BI Developer | Analytics Engineer
Solvd Group
Dec 2024 — PresentCurrentLangenfeld, Germany
  • Designed and implemented 3-tier Medallion Architecture (Bronze → Silver → Gold) pipelines in Databricks, transforming raw MongoDB operational data into governed, analytics-ready datasets supporting 15+ enterprise reporting dashboards
  • Architected and maintained 10+ production Airflow DAGs orchestrating scheduled ELT workflows, automating data ingestion and transformation across a data platform supporting €72M in annual revenue — reducing report preparation time by ~80%
  • Designed dimensional data models and standardized transformation logic across pipeline layers, improving data consistency and eliminating downstream reporting failures across 10 insurance products and 50+ enterprise customers
  • Automated previously manual reporting workflows through scheduled Airflow pipelines, saving an estimated ~15 hours of manual effort per week and eliminating human error in business-critical financial reporting
  • Developed domain-specific data marts supporting 8+ automotive insurance KPIs — including damage metrics, complaint ratios, SLA performance, and financial indicators — across 6 business functions including Finance, Controlling, Operations, and C-level
Data Analyst
Solvd Group
Apr 2022 — Nov 2024Langenfeld, Germany
  • Engineered semantic reporting models and SQL Server data layers that supported €72M in annual revenue reporting and budget variance analysis
  • Developed and standardized reusable SQL transformations and reporting datasets across the BI team, enhancing consistency and minimizing duplicated efforts
  • Collaborated with business stakeholders to define KPI logic and reporting requirements, effectively bridging business processes with technical implementation
Analytics Consultant — Operations Transaction Advisory
Deloitte GmbH
Jun 2021 — Oct 2021Düsseldorf, Germany
  • Executed SQL-driven data analysis to underpin due diligence, mergers, and demerger engagements — extracting, validating, and reconciling extensive datasets from client systems under tight timelines
  • Presented structured data insights to senior advisory teams, showcasing proficiency in navigating complex, unfamiliar data environments swiftly
Demand Planning Manager
Emma - The Sleep Tech Company
Jul 2020 — May 2021Frankfurt, Germany
  • Built forecasting models and inventory planning workflows using SQL, Tableau, and R, transforming sales and inventory data into structured planning datasets for supply chain decision-making
  • Developed data-driven planning models adopted by the supply chain team to support demand forecasting and inventory optimization.
Data Analyst
Analytics Quotient
Jul 2015 — Jul 2017Bengaluru, India
  • Designed and implemented RFM segmentation models for digital subscription and merchandising clients, transforming raw transactional data into customer segmentation datasets for marketing analytics
  • Developed reusable reporting frameworks in Excel and R, automating recurring marketing analytics through standardized data transformation workflows
Skills
DatabricksSQLTableauBusiness IntelligenceData WarehousingApache AirflowPysparkGitELT PipelinesMedallion ArchitectureExcelPythonR
Education
Master of Science, Management
EBS Universität für Wirtschaft und Recht, Wiesbaden, Germany
2017 — 2020
Bachelor of Science, Electronics and Communications
National Institute of Technology, Goa, India
2011 — 2015
Certifications
Data Analyst in Databricks
Databricks
Mar 2026
Languages
English
Fluent
German
Intermediate
Hindi
Advanced
Telugu
Native