Business Intelligence Analyst (m/w/d), Trier
Core
Translating business requirements into KPI definitions, data models, and visualization concepts to create actionable dashboards for internal teams and clients.
Role type
Business Intelligence Analyst
Builds
Reporting and BI landscape (Power BI dashboards, data models, and visualizations)
Domain
Media agency / Digital Marketing Analytics
Deliverable
dashboards & analysis
Required skills
Power BI, DAX, Power Query/M, SQL, Data Modeling, KPI Definition, Data Preparation, Marketing Analytics, Web Analytics (GA4, Google Ads), Performance Optimization
Preferred skills
Certifications in Power BI/DAX/SQL, Knowledge of Looker Studio/BigQuery, Agile methodologies
Technologies
Power BI, DAX, Power Query/M, SQL, Google Analytics 4, Google Ads, Looker Studio, BigQuery
Responsibilities
Translate business requirements into clear KPI definitions, data models, and visualization concepts; Develop and maintain Power BI dashboards from data modeling to visual design; Process and prepare data using Power Query/M and SQL; Analyze marketing KPIs and web analytics data to support data-driven decisions; Optimize database performance, query costs, and data quality; Identify automation opportunities for recurring reporting needs.
Seniority
Mid-level, hands-on IC