Senior Business Intelligence Analyst (f/m/d)

Trusted Shops SE (DE) • Cologne

Cologne

from today / asap

Your duties

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

  • If you want to know more about our organisation, feel free to check out the LinkedIn articles of our CTO


A Typical Day as a (Senior) Software Engineer (f/m/d) Fullstack 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 3 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

Not sure if you are what we are looking for? Apply!
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.

Contacts
Alessandro Canu

Alessandro Canu

 

Your benefits in data & analytics

New work

Work from wherever you feel most comfortable. Whether in one of our 5 offices or temporary from another location in Europe.

Health Pass

Stay fit – physically and psychologically. Our company health management offers you a wide range of courses, presentations and workshops.

International flair

With a team from more than 40 different nations, it never gets boring. We celebrate our diversity and the countless new perspectives it gives us.

Individual development opportunities

Unleash your talent and improve your individual skills that support you in your work.

Buddy programme

Your buddy will help you settle in when you first start out with us. Later, you can also share your experience with new colleagues.

Team events

Whether in summer, winter or whenever it suits your team – we enjoy spending time together.

Our values

Transparency

Open and clear communication gets us to our goals quickly. Address your topics openly – we will find a solution for everything together.

Respect

Every single one of our colleagues is a valuable part of our community. Respectful interaction and openness are prerequisites for our work.

Trust

We know you’re doing a great job – otherwise you wouldn't be here. We trust you, your skills, ideas and intentions.

Employee reviews

Marcel Münchrath
Marcel Münchrath
Data Analyst

I have been working as a "Data Analyst" at Trusted Shops since mid-2021 and work independently and in collaboration with colleagues on the topic of data. I have made it my task to provide automated, data-driven, real-time insights for customer success management in order to initiate measures for customer-oriented solutions and decisions. This is done through independent analysis, defining and determining KPIs, and creating dashboards. I enjoy supporting my team and Trusted Shops in achieving our goals with these data-driven topics day after day.

Have we awakened your interest?

Apply now