Database Integration Engineer

Job Type:

Permanent

Build a brilliant future with Hiscox
 

About us:

HISCOX is an international insurer specialized in the market of luxury goods & property, and high-end professional insurance. As experts in risk, we give people and businesses the confidence to realise their ambitions. With offices in 9 European countries, we have a very international staff and encourage a culture that fosters inclusion and collaboration, offering exciting opportunities for personal and professional growth.

In our Lisbon office we have the privilege of employing approximately 500 exceptional professionals representing 29 diverse nationalities. Despite our central location within the city, we recognize the importance of maintaining a healthy work-life balance. As part of our commitment to our employees’ well-being, we provide a 35-hour workweek along with the option for a hybrid working schedule.

The Team:

The IT Services (ITS) function consists of ~100 IT professionals that deliver and maintain the technology that enables everyone at Hiscox, our partners and our customers; every hour of every day. Our business is fast moving, quick to decide and we have rapidly evolving targets and priorities. You will be used to working in a similar environment and will have the ability to work in a self-motivated and confident manner. 

The Role:

Hiscox are hiring for a Data Integration Engineer to work within our IT Services infrastructure team.

Key Responsibilities:

• Act as a primary technical contact for key technical areas, coordinating with stakeholders and colleagues as required.
• Contribute to the planning, design and delivery of IT initiatives.
• Configure tools to automate the provisioning, testing and deployment of data integrations and infrastructure.
• Produce and own system and designs, policies and documentation.
• Provide reports and proposals for improvements to colleagues and stakeholders.
• Provide advice and guidance to support the adoption of methods and tools.
• Drive IT Services in the migration towards a code centric model for managing data integrations and infrastructure.
• Act as a support escalation point for the 3rd line infrastructure support provider.
• Proactively manage IT data integrations and infrastructure to minimise business disruption and identify and drive initiatives to improve the quality and effectiveness of these services.
• Manage and provide 3rd line support for data integrations and infrastructure in accordance with agreed service levels, standards and processes.
• Discover and remove technical debt as part of a continuous improvement work ethic.
• Drive decision making across different teams and disciplines, seeking informed decisions that lead to value-add, quality, appropriate outcomes.
• Drive the adoption of Agile values, principles and practices within IT Services.
• Actively contribute to the development of other team members.
• Embrace change and support the IT Services vision and strategy.

Person Specification:

Technical Skills

• Design, implementation and administration of data integration solutions primarily around SQL Server, Azure SQL and Databricks
• Understanding and administration of Change Data Capture (native) and SQL Server Integration Services (knowledge of IBM CDC/data replication, Azure Data Factory and Databricks desirable)
• Task automation and scripting experience using T-SQL and PowerShell (knowledge of Terraform and Ansible desirable )
• Troubleshoot SQL Server/Azure SQL and related issues, appreciation of interactions with networking, storage and Active Directory
• Server, database and query performance tuning, using Query Store and Monitoring tools, e.g. SentryOne or similar
• Data platform Cloud migration and administration
• Experience using DevOps principles such as CI/CD and source control to automate and collaborate on routine data integration and administration tasks.
• Relevant certifications are advantageous

Why Hiscox?

• Healthy work-life balance with our 35h/week and hybrid working system.

• Holidays: 25 days + 2 Hiscox Days (Extra two Annual Leave).

• Health insurance, gym allowance, pension plan etc.

• After 5 years work 1-month sabbatical leave.

• Team spirit with many opportunities to engage and an open culture.

Work with amazing people and be part of a unique culture