We are currently hiring a Data Engineer to join our team to assist with developing and maintaining our SQL Server databases in a multi-national Financial company.
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 & Science of Risk," SCOR uses its industry-recognized expertise and cutting-edge financial solutions to serve its clients and contribute to the welfare and resilience of society in around 160 countries worldwide.
Working at SCOR means engaging with some of the best minds in the industry - actuaries, data scientists, underwriters, risk modelers, engineers, and many others - as we work together to find solutions to pressing challenges facing societies.
As an international company, our common culture is defined by "The SCOR Way." Serving both to build momentum that drives the Group forward and as a compass to guide our actions and choices, The SCOR Way is anchored by five core values, reflecting the input of employees at all levels of the Group. We care about clients, people, and societies. We perform with integrity. We act with courage. We encourage open minds. And we thrive through collaboration.
Job Summary
- Certified Microsoft SQL Server Database Engineer (or similar) with 7+ years experience
- Developing, deploying and maintaining application and reporting databases
- Ensuring the highest levels of database performance and resilience
- Knowledge and experience of financial systems (especially Insurance/Reinsurance)
- Supporting database global users
- Knowledge and experience of Azure Devops and CI/CD tools
- Knowledge and experience of Job scheduling tool(s)
- Cloud Experience, preferably Azure
- Knowledge of user access and security controls (e.g. Active Directory)
- Knowledge of Agile working methodology
- Good team player
Key duties and responsibilities
- Developing, deploying and maintaining application and reporting databases
- Proactively ensure the highest levels of application database availability
- Monitor and test database performance for potential bottlenecks, identify possible solutions, and work with other developers to implement those fixes
- Maintain security, backup, and redundancy strategies for databases
- Write and maintain custom scripts to increase system efficiency and lower the human intervention time on any tasks
- Participate in the design of information and operational support systems
- Report to Application Domain Manager
- Provide support to database users
Required experience & competencies
Must Have:
- Certified Microsoft SQL Server Database Engineer with 7+ years experience
- Knowledge and experience of financial systems (preferably Insurance/Reinsurance)
- Knowledge and experience of using structured and unstructured data
- Knowledge and experience of Azure Devops/GIT and CI/CD tools
- Knowledge and experience of Job scheduling tool(s) e.g. Visual TOM
- Knowledge of user access and security controls (e.g. Active Directory)
- Experience of supporting global database users
- Proficiency in MS Excel
- Knowledge and experience of database performance tuning and testing
- Good problem solving skills
Nice to Have:
- Palintir (Data Foundry)
- Knowledge and xxperience of Powershell
- Knowledge of other RDMS (e.g. DB2, Sybase, Posgres)
- Knowledge of Prophet, MIND or similar Risk Modelling tools
- Knowledge and experience with C#
- ETL Tools (e.g. Talend)
- Prophet (or similar Risk Modelling tools)
- Knowledge and experience of Azure Cloud
- Using SNOW Helpdesk system
- Knowledge of Agile methodologies
Required Education
- Degree/Diploma in Computer Science, Data Analytics or a related subject