Job
In this role, you will develop automated data processing workflows and Power BI dashboards, analyze sales metrics, and thoroughly prepare data from various sources to support informed decision-making.
This listing has been machine translated. Show original
Job technologies
Your role in the team
- For a leading brand manufacturer, we manage the nationwide field sales. Extensive data on market visits, distribution, product placements, sales, and target achievement are generated daily.
- This information forms the basis for important operational and economic decisions.
- Our reporting landscape is already established. Now we want to further develop it: with efficient data preparation, automated analyses, powerful Power BI dashboards, and solutions that our teams can use independently.
- We are looking for someone who not only processes data but also understands contexts, questions critically, and develops their own ideas.
- 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 check 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 utilization.
- 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 datasets.
- 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 clearly 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 per week on-site at our office in Weischlitz. On the remaining days, you can work remotely. During the onboarding period, a higher presence is expected.
- 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 relevant further training.
- You work directly with the management and the operational departments.
- We value open communication, mutual support, and respectful collaboration.
- Permanent employment contract
- 28 days of vacation
- Flexible working hours
- Tax-advantaged fringe benefits
- Structured onboarding
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...