BI Developer

Summary

The IT company Andersen invites BI Developer for a major digital transformation project with a global insurance and assistance provider based in Germany. The initiative focuses on building a scalable, modular enterprise platform to support core operations, system integrations, and financial workflows, ensuring seamless data consistency and interoperability.

The customer is a global B2B2C insurance and assistance leader offering global solutions that span international health and life insurance, travel insurance, automotive and maintenance. In 2021, the company was ranked 38th in the Fortune Global 500. Turnover of the company was 120 billion euros as of 2020.

The project is a large-scale, modular platform designed to support core business operations, system integrations, and financial workflows.

The technology stack on a project: ELT and ETL frameworks, SQL (PostgreSQL), Python/Airflow, Looker, Data modelling.

Responsibilities

• Designing, developing, and maintaining data extraction and transformation solutions within ELT and ETL frameworks, as well as data models for a centralized data warehouse and integration layer.
• Developing and maintaining centralized self-service reporting solutions (in Looker), dashboards, and scheduled data deliveries.
• Conducting data analysis and validation to ensure accuracy, completeness, and consistency across data sources and reports.
• Managing stakeholders by collecting business requirements and requests related to data analysis and reporting.
• Monitoring and optimizing data infrastructure, including database systems, data pipelines, and ETL processes.

Requirements

• Experience as a BI Developer for 3+ years.
• Experience in building and maintaining data extraction, transformation, and loading processes.
• Strong proficiency, preferably with hands-on experience using PostgreSQL.
• Experience writing scripts for data processing and automation.
• Skills in creating DAGs and automating data pipelines.
• Familiarity with the BI tool, including dashboard creation and data visualization.
• Understanding of normalization, denormalization, and schema design (e.g., star and snowflake schemas).
• Basic understanding or experience with real-time data streaming.
• Level of English – from Upper-Intermediate and above.

Desired skills

• Understanding of SFTP server operations and data exchange principles.
• Experience in database administration (configuration, monitoring, backup, and recovery).

Reasons to join us

• Experience in teamwork with leaders in FinTech, Healthcare, Retail, Telecom, and others. Andersen cooperates with such businesses as Samsung, Siemens, Johnson & Johnson, BNP Paribas, Ryanair, Mercedes, TUI, Verivox, Allianz, T-Systems, etc..
• The opportunity to change the project and/or develop expertise in an interesting business domain.
• Job conditions – you can work both fully remotely and from the office or can choose a hybrid variant.
• Guarantee of professional, financial, and career growth! The company has introduced systems of mentoring and adaptation for each new employee.
• The opportunity to earn up to an additional 1,000 EUR per month, depending on the level of expertise, which will be included in the annual bonus, by participating in the company's activities.
• Access to the corporate training portal, where the entire knowledge base of the company is collected and which is constantly updated.
• Bright corporate life (parties / pizza days / PlayStation / fruits / coffee / snacks / movies).
• Certification compensation (AWS, PMP, etc).
• Referral program.
• English courses.
• Private health insurance and compensation for sports activities.

Join us!