BNP Paribas Cardif Insurance Company is part of the French BNP Paribas Banking Group. We are one of the leaders in the field of insurance and our most important product is Inability to Pay Insurance. So, if you have a loan or mortgage, you have probably already met us in everyday life. We are also one of the biggest sponsors of tennis matches, where our logo shines from all sides, which is probably where you know us from as well. :)

We are on the lookout for an experienced DWH Analyst / Developer with strong knowledge of analytical tools. Our well-established company offers a secure environment for you to actively contribute to desicion-making processes. Be part of our team and join us!

This role covers following activities

• Designing, developing, and maintaining scalable and efficient data warehouse solutions
• Collaborating with stakeholders to understand business requirements, transforming them into effective BI solutions
• Developing and maintaining conceptual, logical, and physical data models
• Contributing to the alignment of data warehouse solutions with the enterprise architecture
• Managing MS SQL databases, optimizing performance and ensuring data integrity and security
• Designing, developing, and optimizing ETL processes to extract, transform, and load data efficiently into the data warehouse
• Creating comprehensive documentation and reporting to support data warehouse processes

Your profile

• Proven experience 3-5 years in Data Warehouse development and Business Intelligence
• Fluent English (at least B2)
• Expertise in MS SQL Server (database design, query optimization, and performance tuning)
• Experience with Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS) – OLAP Cubes
• You understand Enterprise Architecture principles and their application to data solutions.
• You would describe yourself as a strong analytical and problem-solving person with excellent communiation and collaboration abilities? You are the one!

What we offer

• Possibility to work in a dynamic and professional team in an international company with a strong background.
• Flexibility in the form of a flexible working week, when you choose the beginning and end of your working hours.
• We operate in a hybrid model because we believe that personal contact is very important for building team spirit.
• A wide range of interesting benefits - 5 weeks of vacation, free days, 18,000 points per year to cafeteria for culture, sport, education and other activities; meal vouchers in the amount of 211 CZK/day, generous pension contribution, etc.
• The opportunity to learn from experts in your fields, you can look forward to professional and soft trainings with us.
• We also offer talent programs or the opportunity to participate in voluntary CSR activities.

Benefits

• Bonuses
• Notebook
• Contributions to the pension / life insurance
• Flexible start/end of working hours
• Meal tickets / catering allowance
• Holidays 5 weeks
• Educational courses, training
• Cafeteria
• Contribution to sport / culture / leisure
• Education allowance
• Sick days
• Occasional work from home
• Launch of a completely new project