Senior Analytics Engineer (m/f/d)

<h3>Who we are</h3> <span>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!</span> <h3>The role</h3> <p>We’re looking for a Senior Analytics Engineer (m/f/d) who combines deep technical expertise with a strategic mindset. In this role, you’ll have full ownership to define standards and embed a modern data culture across the organization. <br/>Your impact: turn raw data into trusted insights that drive key business decisions and set the foundation for scalable, future-proof analytics.<br/> <span><br/></span><strong>Responsibilities:</strong> <br/><ul><li>Design, develop, and maintain dbt-based transformation pipelines</li><li>Build robust, scalable, and well-documented data models for BI tools and data products to improve business performance</li><li>Define and implement best practices for version control, testing, performance optimization, and documentation</li><li>Ensure data quality and consistency throughout the lifecycle, including comprehensive test coverage. Collaborate with analysts and data users to make data easy to use, trustworthy, and fast to access</li><li>Collaborate with Product, Finance, Engineering, and Operations to translate business metrics into reliable, scalable data models</li><li>Align dbt transformations with our Snowflake-based data platform in partnership with Engineering</li><li>Create dashboards and reports that turn models into actionable insights for stakeholders</li><li>Champion data culture by embedding data-driven thinking across the organization</li></ul> <strong>Tech Stack you will work with:</strong><br/><ul><li>Transformation / Modeling: dbt (core or Cloud)</li><li>Cloud Data Platform: Snowflake (currently in migration phase)</li><li>BI / Consumption: Tableau (or similar)</li><li>Version Control: Git</li><li>Workflow &amp; Orchestration: Airflow / Dagster / Prefect</li><li>Programming: SQL (expert level), Python</li><li>Testing &amp; QA: dbt tests, Great Expectations, or similar frameworks</li></ul></p> <h3>What we are looking for</h3> <ul><li>At least 6 years of experience in data engineering, analytics engineering, or advanced BI development role</li><li>Proven hands-on experience with dbt in a production environment</li><li>Deep expertise in SQL and dimensional/semantic modeling (e.g., Kimball, DRY modeling principles)</li><li>Experience working with Snowflake or another modern cloud data platform (e.g., BigQuery, Redshift)</li><li>A track record of building clean, modular, reusable data pipelines</li><li>Strong understanding of data testing, CI/CD, documentation, and performance tuning</li><li>Ability to translate ambiguous business requirements into scalable data models</li><li>Passion for building a modern data culture and driving data-driven decision-making across the organization</li><li>A builder mindset: excited to shape foundational data architecture in a growing environment and influence long-term data strategy</li><li>Excellent communication and stakeholder management skills across technical and non-technical teams</li></ul> <h3>Why Xempus</h3> <ul><li>Join one of the leading insurtechs in Europe as it enters its next growth phase </li><li>Find creative freedom and quick decision-making structures in a dynamic, innovative environment  </li><li>Opportunity to participate in one of the most generous employee stock option programs in the industry </li><li>Very attractive contribution to the company pension scheme</li><li>Corporate health insurance (600€ reimbursement of various medical and pharmacy costs per year)</li><li>Work with a team of amazing colleagues with great team spirit (company parties, charity events e.g.) </li><li>Have the option of hybrid working - for family friendliness and maximum flexibility in your everyday life. You can find out more <a href="https://www.youtube.com/watch?v=ojR8_sCj3gM" rel="noreferrer noopener" target="_blank">here</a>.</li><li>Broad range of personal &amp; professional development opportunities: individual annual training budget, free courses, and a transparent career development model </li><li>Various health offerings such as bike leasing and EGYM Wellpass</li><li>Modern offices in a central location, including free drinks &amp; fruit </li><li>We offer you an option for an unpaid extra holiday in addition to your 30-day holiday entitlement per year</li></ul> <h3>Contact</h3> <strong>Does that sound like your kind of job? Then apply now!</strong><br/>If you have any questions, difficulties uploadi