Job
- Level
- Experienced
- Location
- Weischlitz
- Working Model
- Hybrid, Onsite
- Job Field
- BI
- Employment Type
- Full Time
- Contract Type
- Permanent employment
- Salary
- 52.000 to 62.000€ gross/year
Job Summary
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.
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.
This text has been machine translated. Show original
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.
This text has been machine translated. Show original
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
This text has been machine translated. Show original
Benefits
Work-Life-Integration
Topics You Will Work On
Job Locations
About Your Employer
Sellence GmbH
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.
Description
- Company Type
- Startup
- Working Model
- Hybrid, Onsite
- Industry
- Trade
Business Intelligence Specialist - Power BI & Excel
- Salary
- 52.000 to 62.000€ gross/yearEstimated net salary based on the gross salary in the job ad using tax class I.33.400 to 38.580 € net/year · Tax class I
- Location
- Weischlitz
- Working Model
- Hybrid, Onsite
- Diversity
- Open for all genders
