BI Developer

Andersen is hiring a BI Developer for a global insurance leader. The project focuses on car and property insurance, enabling remote monitoring and management of assets from anywhere in the world.

Our customer is a world leader in insurance and B2B2C support, which offers global solutions that span international health and life insurance, travel insurance, cars, and their service. The company is dedicated to delivering world-class, agile, and sustainable IT solutions, driving full-spectrum digitalization.

The project is focused on car and property insurance, providing solutions for monitoring their condition remotely while users are in another city or country.

Technology stack on the project: ELT and ETL frameworks, SQL (we use PostgreSQL), Python/Airflow, Looker, Data modelling, Kafka.

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.

Must-haves:

• 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 with Kafka.
• 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 Intermediate+ and above.

Nice-to-haves:

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

Reasons why this job would be interesting to you:

• 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 USD 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!