Job
In this role, you prepare complex data sets, develop automated reporting solutions in Power BI, and ensure transparent visualizations that support the sales team.
This listing has been machine translated. Show original
Job technologies
Your role in the team
- You independently prepare extensive data sets from various sources.
- You use Excel and Power Query for cleaning, transforming, linking, and structuring data.
- You develop reusable and automated data processing workflows.
- You consolidate data from Excel files, CRM exports, and other data sources.
- You review data for completeness, plausibility, and consistency, and develop appropriate control mechanisms.
- You independently develop our existing Power BI reporting landscape further.
- You create meaningful dashboards and visualizations for executive management, Field Force Management, and back office.
- You develop and maintain data models, DAX calculations, and KPI visualizations.
- You contribute your own ideas to improve the visualization and utilization of our evaluations.
- You ensure that the reports are comprehensible, reliable, and user-friendly.
- You develop analyses on visitor performance, distribution, market coverage, product placements, and sales.
- You implement target agreement and target achievement calculations for our field service team and its managers.
- You create target-actual analyses and check for noticeable deviations.
- You recognize the connections between operational sales performance and the evaluated key figures.
- You question results, clarify discrepancies with the relevant departments, and prepare insights in an understandable manner.
- You will also gain practical experience with our sales processes, for example through interaction with supervisors and accompanying the field service team.
- You identify manual, recurring evaluation processes and develop efficient automation solutions.
- You use Excel, Power Query, Power BI, and, if applicable, shared AI tools.
- You evaluate new technologies and suggest meaningful improvements.
- You document processes, calculation logics, and technical solutions in a comprehensible manner.
- You develop solutions that colleagues without technical background can reliably use as well.
- You work closely with management, Field Force Management, supervisors, and back office.
- You translate technical requirements into suitable technical solutions.
- You present your evaluations, explain their application, and support the teams in their usage.
- You ensure that knowledge is documented and that evaluation processes function independently of individual persons.
Our expectations of you
Education
- Completed vocational training, a degree, or comparable practical experience in Business Informatics, Controlling, Business Administration, Data Analysis, or Business Intelligence.
Qualifications
- Excellent Excel skills, especially with complex formulas, pivot analysis, and processing large data sets.
- Excellent practical knowledge of Power Query, including data import, cleaning, transformation, merging, and automation of data preparation.
- Basic knowledge of Python.
- A good understanding of sales metrics, business economics, and operational processes.
- Analytical thinking, meticulous work approach, and the ability to critically question numbers.
- Proactivity, solution orientation, and enjoyment in improving existing processes.
- The ability to explain complex analyses understandably and to document your work thoroughly.
- Excellent spoken and written German skills.
- Willingness to work regularly at least two days a week in our office in Weischlitz.
Experience
- Extensive hands-on experience with Power BI, including dashboard development, DAX, and data modeling.
- Professional experience in reporting, data analysis, or sales controlling.
What we offer
- Attractive compensation of €52,000-€62,000 gross annually, depending on your qualifications and experience.
- At least two days of presence per week in our office in Weischlitz.
- On the remaining days, you can work remotely.
- A higher presence is expected during the onboarding period.
- You can contribute your own ideas, develop solutions, and actively further develop our reporting and BI landscape.
- You work with Excel, Power Query, Power BI, and other modern tools.
- We are open to new technologies and support you in suitable further training.
- You work directly with the management and the operational departments.
- We value open communication, mutual support, and respectful collaboration.
Benefits
Work-Life-Integration
Topics you will work on
Job locations
About your employer
Sellence GmbH, a rising company from Bad Wiessee, supports brand manufacturers and retailers in the premium tobacco products sector. They enhance product placement and utilize digital tools for route planning and reporting. With a skilled team and creative approaches, Sellence aims to make tobacco sales efficient and future-oriented.
- Startup
- Onsite, Hybrid
- Trade
More jobs
These jobs might also interest you
You’ll be joining at a stage where we’re building and evolving our new CRM platform. That’s exactly what makes this role special: you won’t just develop features—you’ll actively help shape the technical foundation of a modern CRM ecosystem. Together...
Consultant & Project Manager – You are the first point of contact for our clients and take on the leadership of new projects. Optimize processes & create added value – With your expertise, you will design more efficient workflows and support our clients...
Consultant & Project Manager – You are the primary contact for our clients and take on the leadership of new projects. Optimize processes & create added value – With your expertise, you will design more efficient workflows and support our clients with...