Power BI / Data & Reporting Specialist (FMCG)

Confidential Employer; Deutschland; Vor Ort; EUR 30.000 - 45.000; Vollzeit

Benefits dieser Stelle

Work-Life Balance

Professional Growth support

Competitive salary and benefits package

Zusammenfassung

Confidential Employer is seeking a Data & Reporting Specialist to expand its reporting infrastructure for major FMCG projects. The role is based in Germany with a hybrid work model allowing 2 days remote and 3 days in the office.

Responsibilities include collaborating with data teams, data modeling, and creating insightful Power BI dashboards. Candidates should have a strong background in Power BI development, excellent English communication skills, and knowledge of SQL.

Benefits include professional growth support, competitive salary, and a positive workplace culture.

Qualifikationen

• 3+ years of experience in end-to-end Power BI development.
• Strong proficiency in Power Query for ETL processes.
• Good knowledge of SQL for data extraction and manipulation.
• Fluency in English required for international collaboration.

Aufgaben

• Collaborate with international teams to align data sources.
• Clean and transform datasets using Power Query.
• Design and maintain user-friendly Power BI reports.
• Write DAX calculations to create business metrics and KPIs.
• Manage Power BI workspaces and implement security.

Kenntnisse

End-to-end Power BI development

Data modeling

Power Query

Advanced DAX

SQL

Tools

Power BI

Azure infrastructure

Power Automate

Python

Jobbeschreibung

At SMOLLAN PORTUGAL (Permanent), in Lisbon, Portugal

Salary: €30.000 - €45.000

Expires at: 2027-07-01

Remote policy: Partial remote

About the role

Smollan Portugal is expanding its data capabilities, and we are looking for a Data & Reporting Specialist to drive our reporting infrastructure across several major FMCG client projects.

In this role, you will work in a truly international environment, collaborating daily with our internal data and tech teams across the UK, the Netherlands, and Slovenia. Your mission will be to own our end-to-end Power BI ecosystem‑turning raw data into reliable, scalable data models and delivering strategic dashboards that support regional business decisions.

What you will do

• International Collaboration: Align with internal tech and data teams in the UK, Netherlands, and Slovenia to map data sources and integrate regional analytical solutions.
• Data Engineering & Modeling: Connect to diverse data sources, clean and transform complex datasets using Power Query (M), and build optimized data models (Star Schema).
• Dashboard Architecture: Design, develop, and maintain user-friendly, high-performance Power BI reports following visualization best practices.
• Advanced Analytics: Write complex DAX calculations to create business metrics, KPIs, and time‑intelligence tracking.
• Governance & Security: Manage workspaces within the Power BI Service, configure scheduled refreshes, and implement Row-Level Security (RLS).

Main requirements

• Proven Senior Experience: background (+3 years) in end-to-end Power BI development and data modeling.
• Technical Mastery: Strong proficiency in Power Query (for ETL processes) and advanced DAX.
• Data Foundations: Good knowledge of SQL for data extraction, querying, and manipulation.
• Language: Fluency in English is mandatory due to daily interaction with international teams.
• Communication: Ability to translate complex technical data concepts into clear insights for business stakeholders.
• Pluses: Familiarity with Azure infrastructure, Power Automate, or Python.

Benefits & Perks

• Work‑Life Balance: A hybrid work model (2 days remote / 3 days in our office).
• Certified Best Workplace Culture: Reflecting our commitment to a positive, inclusive, and people‑first culture.
• International Scale: Opportunity to work in a multicultural environment with cross‑border projects and major global brands.
• Professional Growth: Active support for continuous learning, training, and technical certifications.
• Competitive salary and benefits package.