accompio GmbH: Werkstudent (m/w/d) Data Analytics / Business Intelligence - Wuppertal
Core
Build a central Data Lake, connect ERP/CRM/ITSM data sources, and create reusable KPI layers and dashboards for management and business units.
Role type
Werkstudent (part-time student) Data Analytics / Business Intelligence
Builds
Central Data Lake, data models, KPI layers, and standard dashboards for internal reporting
Domain
IT Security services, Enterprise Resource Planning (ERP), Customer Relationship Management (CRM)
Deliverable
dashboards & analysis
Required skills
SQL (Joins, Aggregations, Window functions), BI tools (Power BI, Tableau, Metabase, Looker), Data modeling, Requirement translation, Documentation
Preferred skills
PostgreSQL, Python (pandas), dbt, Git, Microsoft Dynamics 365 Business Central, HaloPSA
Responsibilities
Bind data sources from ERP, CRM, and ITSM to the Data Lake; Clean, link, and transform raw data into analyzable data models; Build a reusable KPI layer with uniform definitions; Support selection and setup of BI tools; Create standard dashboards for management and business units; Build report templates and short guides; Serve as contact person for data model and report building questions; Document data sources, field meanings, and KPI definitions
