Analytics & BI Developer (m/f/d)

Who we are

We are Xempus, Germany´s leading independent Software-as-Service (SaaS) platform for the management and distribution of pension, life and health insurance. Our mission: making pension, life and health insurance digital and understandable, efficient and accessible for everyone. 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 – no matter where we are! Whether from one of our offices or from home – join us and together we create a more secure future for everyone!

The role

We are looking for an 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

• 5+ 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)
• 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

Does that sound like your kind of job? Then apply now!