Senior Business Intelligence Analyst (f/m/d)

Trusted Shops develops SaaS solutions for over 40 million users and 30,000 businesses across Europe. Our product suite includes products such as the Trustmark, Buyer Protection and the eTrusted experience feedback platform. Our products are part of a 20-year mission to enable trust between people and businesses in the digital age.

The Data Platform Team contributes to this mission by providing the foundation of data-driven work, both for our colleagues, and for our customers. Ranging from metrics that measure our product usage to facts and figures that our customers use as a compass to guide them towards improving their business.

All these insights require careful analysis and modeling, and that's why we're looking for a Senior Business Intelligence Analyst (f/m/d) that thrives in a creative, changing environment, loves to build great data products, and is passionate about positively impacting business decisions through data. Want to be part of crafting a market-leading data platform? Come join us!

You will support a diverse team consisting of Cloud Engineers, Data Engineers and Data Analysts that utilize cloud-based technologies to manage a large variety of datasets tailored for an even larger number of use cases. A Product Owner and Agile Coach guide us forward, in a cross-functional way. We believe in the "You build it, you own it" philosophy, where you take charge of shepherding analyses through every stage until they deliver value to the business.

Your Key Responsibilities as Senior Business Intelligence Analyst (f/m/d):

In your role, you will bridge the gap between business needs and technical implementation. Your focus will be on understanding business processes, translating them into data requirements and creating actionable insights. You will:

• Gather requirements from various departments to clarify their data and reporting needs

• Profile data to understand quality, completeness, and business rules

• Deduce business rules by interviewing subject matter experts and analysing available data

• Define KPIs that measure business performance

• Build dimensional models that support efficient reporting and analysis

• Create reporting prototypes to validate analyses before full implementation

You'll work with our modern data stack including AWS services like S3, Athena, DuckDB, Glue, and RDS to access and analyse data. Your analyses will directly influence business decisions and help shape our data-driven culture.

Why Join Trusted Shops?

• Personal Development: You’ll receive direct support from your Engineering Manager, ensuring your growth and success

• Health & Wellbeing: Participate in monthly health activities and earn an extra vacation day for achieving health goals

• Continuous Learning: Enjoy your “Self Education Day” every last Friday of the month, where you can focus on personal growth, attend internal tech talks, read a book, or work on your goals

• Inclusive Work Culture: Flexible working options and a focus on work-life balance. No late-night work expected

A Typical Day as a Senior Business Intelligence Analyst (f/m/d) at Trusted Shops:

• Starting your day with setting up your mobile working environment – or adjusting your table at the office

• Opening your individual task manager and getting your mind into the analyses you are working on, ranging from quick ad-hoc requests to long-term strategic projects

• Meeting with the team in the daily standup and setting the stage for the collaborative work of the day. You'll probably have a look at your backlog, your Kanban board or whichever style of agile collaboration the team favours

• You continue working on requirements gathering, data profiling, or model building. Maybe a focus session writing SQL queries or working on a dimensional model design with colleagues

• Enjoy a flexible lunch break, whether it’s a home-cooked meal or a casual outing with colleagues at nearby restaurants

• Afternoon might include stakeholder meetings to validate KPIs or present reporting prototypes. It is completely up to you and the team how long and in which constellations and formats you work!

• On your Self-Education Day (monthly), focus on personal growth with a self-directed learning agenda and no scheduled Meetings

• Wrap up the day with Team-building activities such as Waffle Day or enjoy a drink on the Rooftop Terrace

Your profile

• Bachelor's degree in mathematics, information science, economics, or equivalent experience

• Strong analytical thinking with the ability to map business processes to data objects

• You have gathered 5 or more years of experience as a BI Analyst, a lead Data Engineer, a Senior Report Developer or similar role

• Strong SQL skills for data summarization, profiling, and analysis

• Domain knowledge in subscription-based business or recurring revenue models (e.g. insurance, magazine subscriptions, freemium software, etc) is highly valuable

• Strong knowledge of dimensional data modeling and reporting best practices

• Basic competency in Entity-Relationship modeling and Third Normal Form

• Understanding of data warehouse concepts and architecture

• You collaborate based on mutual respect

• Strong communication skills in English for gathering requirements and interviewing stakeholders. German is a plus

What we offer you:

• Hybrid work: Combine flexible remote work with team time in the office

• Workation: Temporarily work from a destination of your choice within the EU, Iceland, Liechtenstein or Norway

• Permanent contract with Europe's trusted brand

• One "Self Education Day" per month

• 27 vacation days + 3.5 additional days off at Christmas, New Year's Eve and Carnival

• Buddy programme (an experienced trustee is at your side)

• Individual training opportunities

• Events (Team Events, Unit Events, etc.)

• Health Pass (free online and offline sports, fitness and health courses)

BUILD A COMMUNITY OF TRUST WITH US - #cometotrust

At Trusted Shops, we are interested in you as a person - whether you fit in with us is independent of gender, nationality, ethnic and social origin, religion/belief, disability, age, sexual orientation and identity. Trusted Shops is clearly committed to diversity and against discrimination.