Senior Analytics & BI Developer (m/f/d)

Who we are

Xempus is the leading European group pension, life and health insurance platform. We seamlessly connect insurers, insurance agents, corporates and their systems in an automated and customer-centric manner. Using standardized interfaces and structured data, we operate the central infrastructure for all customer-centric processes and enable agentic AI across pension, life and health insurance.

Since 2007, we have been constantly working to drive the digitalization of the insurance industry. Here at Xempus, we believe that together we can make a difference – join us and together we create a more secure future for everyone!

The role

We are looking for a Senior Analytics & BI Developer (m/f/d) who combines technical expertise with a strong sense for business. Your mission: transform complex data into actionable insights that power business-critical decisions.

Responsibilities

Own the design, development, and maintenance of our dbt-based transformation layer

Build robust, modular, and well-documented semantic models for BI tools or data products that allow us to understand and enhance business performance

Ensure high data quality, consistency, and test coverage throughout the data lifecycle. Work closely with data analysts and data users to ensure that data is easy to use, trustworthy, and reduces time to insight

Collaborate closely with Product, Finance, Engineering, and Operations to define business requirements and translate them into reliable data models

Partner with Engineering to ensure alignment of dbt transformations with our new Snowflake-based data platform infrastructure

Establish and promote best practices in testing, performance optimization, and documentation

Turn models into insights that present data in a clear, actionable format for stakeholders

Contribute to shaping a modern data culture across the organization

Tech Stack you will work with

Programming

SQL (expert level), Python

Transformation / Modeling

dbt (Core or Cloud)

Cloud Data Platform

Snowflake

Visualization

Tableau (or similar)

Testing & QA

Data quality test and data validations approaches

Nice to have

• Git, CI/CD pipelines
• What we are looking for
• 6+ years of experience in an analytics & BI development, data modeling, or analytics engineering role
• Proven hands-on experience with dbt in a production environment — building from scratch and refactoring existing models
• Deep expertise in SQL and dimensional/semantic modeling (e.g., Kimball, DRY modeling principles, query optimization, execution plans, schema design)
• Hands-on experience working with Snowflake or another modern cloud data platform (e.g., BigQuery, Redshift, Databricks)
• A track record of building clean, modular, reusable data models and transformation logic
• Strong understanding of data testing, documentation, and performance tuning
• Ability to translate ambiguous business requirements into scalable data models
• Excellent communication and stakeholder management skills across technical and non-technical teams
• A builder mindset: excited to shape foundational data architecture in a growing environment
• Fluency in English is essential
• Nice to have
• Experience in insurance or financial services data models
• Experience introducing dbt or analytics engineering practices in an early-stage environment
• German language skills are a strong plus

Why Xempus

Shape the Future

: Help reinvent intelligent automation of occupational pensions at one of Germany’s leading insurtechs

Maximum Freedom

: Creative ownership and fast decision - in a dynamic, innovative environment

Top Contribution

: 100% employer contribution – we double every euro you invest in your occupational pension scheme

Health Coverage

: Company health insurance with €600 annual reimbursement for various medical services

People-Driven Culture

: Genuine cross-departmental teamwork, open doors, and collaboration at eye level

Flexible Working

• : Hybrid working for maximum freedom and work-life balance –
• learn more here

Learn & Grow

: Annual development budget, personal AI coaching, and transparent career paths with clear growth opportunities

Stay Active & Mobile

: Health benefits including job bike / EGYM Wellpass or traveling easily with the Deutschlandticket

Extra Time Off

: 30 days paid vacation – plus the option to take additional unpaid leave

Workation Option

Up to 30 days per year to combine work and travel

Contact

• Does that sound like your kind of job? Then apply now!
• If you have any questions, difficulties uploading your data, or require any assistance with the recruitment process,

Marta Von Deimling (

• <[email hidden]>
• ) is happy to help. Please be sure to submit your application using the application form - unfortunately,
• we cannot process applications sent by email.
• We’d love to hear from you!