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

Xempus; München; Hybrid; EUR 90.000 - 120.000; Vollzeit

Benefits dieser Stelle

Hybrid work

Health insurance

30 days vacation

Development budget

Deutschlandticket

Job bike

Zusammenfassung

Xempus is seeking a Senior Analytics & BI Developer to transform complex data into actionable insights that power business-critical decisions. You will own the dbt-based transformation layer, build robust semantic models for BI tools, ensure data quality, and collaborate across Product, Finance, Engineering, and Operations to deliver reliable data solutions.

The role requires strong SQL, Python, dbt, Snowflake experience, and fluency in English.

Qualifikationen

• 6+ years of experience in analytics & BI development, data modeling, or analytics engineering.
• Production dbt experience: building from scratch and refactoring models.
• Deep SQL and dimensional/semantic modeling knowledge (Kimball, DRY).
• Hands-on with Snowflake or comparable cloud data platforms (BigQuery, Redshift, Databricks).
• Proven ability to build clean, modular, reusable data models and transformation logic.
• Strong data testing, documentation, and performance tuning skills.
• Ability to translate ambiguous business requirements into scalable data models.
• Excellent communication and stakeholder management across technical and non-technical teams.
• Fluency in English is essential.

Aufgaben

• Own the design, development, and maintenance of our dbt-based transformation layer.
• Build robust semantic models for BI tools and data products to understand and improve business performance.
• Ensure high data quality, consistency, and test coverage across the data lifecycle.
• Collaborate with Product, Finance, Engineering, and Operations to translate requirements into data models.
• Partner with Engineering to align dbt transformations with Snowflake-based data platform.
• Promote best practices in testing, performance optimization, and documentation.
• Turn models into insights presented clearly for stakeholders.
• Contribute to shaping a modern data culture across the organization.

Kenntnisse

SQL

Python

dbt

Snowflake

Tableau

Data modeling

Data testing

English fluency

Tools

Git

CI/CD pipelines

Jobbeschreibung

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 ([e-mail]) 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!

We are an equal opportunity employer and ensure that no applicant is subject to less favourable treatment on the grounds of gender, gender identity, marital status, race, colour, nationality, ethnicity, age, sexual orientation, socio‑economic, responsibilities for dependants, physical or mental disability. Any hiring decision are made on the basis of skills, qualifications and experiences.