Data Warehouse/BI Engineer

Under the operational responsibility of the Solution Owner, you are responsible to work with databases, both relational and multidimensional and responsible for building online analytical processing (OLAP), in the respect of existing policies and procedures that produce high-quality software products and services. Right from prototyping and designing functional code to coding and testing, you take ownership of the software until it is handed over to the end users.

You are fully integrated within the Software Engineering Chapter, you contribute to develop the community, define and share guidelines, best practices, experience with others and perform technological watch on your domain

You will join the Tech & Data department (more than 200 employees across the globe) and will be able to grow and evolve in a global and very dynamic structure providing products, services, and support to all SCOR Group worldwide. 

On software development 

• Develop and maintain database, analytics and reporting related code, review data loaded into the datawarehouse for accuracy.
• Identify data sources and determine common data definitions across user groups.
• Write, maintain, test and document various areas of core business databases and ETL packages
• Collaborate with cross-functional teams and squads, including product owners, solution owners, quality assurance team and other developers to deliver efficient and high-quality software solutions
• Test software development methodology in an agile environment
• Participate in code reviews, peer programming, and continuous integration and delivery processes

On software maintenance 

• Provide ongoing maintenance, support and enhancements in existing systems and platforms: troubleshoot and fix software defects, performance issues, and software compatibility problems
• Maintain documentation and version control of software code and related artifacts
• Implement software security best practices and adhere to industry standards and regulations

On innovation

• Stay up-to-date with emerging trends, technologies, and software engineering best practices.
• Provide recommendations for continuous improvement
• Work alongside other engineers on the team to elevate technology and consistently apply best practices

• 5+ years of working with large-scale Enterprise data warehouse, data integration, data migration, ETL  and data quality verification with a proven track record of successful deliveries 
• Experience/ Knowledge of the Reinsurance business and/or the financial services industry is a plus

Hard skills

• 5+ years of experience in designing, modeling and development of data warehouse in SQL Server based environments
• 3+ years of experience with SSIS packages, SSRS reports and SSAS cubes
• 3+ years of experience with reporting and analytics tools (Tableau or PowerBI)
• Understanding of dimensional & normalized data models and data access methods
• Strong experience of Business & IT agile ways of working, experience with Scrum/Agile development methodologies

Preferred Skills:

• Experience with cloud platforms such as Azure
• Familiarity with modernized analytical solutions such as Databricks, Azure Data lake
• Familiarity with DevOps principles and practices
• Knowledge of software security principles and practices
• Knowledge of machine learning, artificial intelligence, or data science

Soft skills

• Client and service-oriented (understand users’ practices) 
• Willing to take initiatives
• Ability to work in a team and/or be an effective individual contributor.
• Used to working in a cross-cultural environment.
• Fluent English skills (oral & written)

Required Education 

• BS in Computer Science or related degree or equivalent work experience required

As a leading global reinsurer, SCOR offers its clients a diversified and innovative range of reinsurance and insurance solutions and services to control and manage risk. Applying “The Art & Scie