Senior Data Engineer

Markel Corporation; London; Hybrid; GBP 60,000 - 75,000; Full time

Job summary

A leading insurance firm in London is seeking a Senior Data Engineer to enhance data-driven decision-making in their International Portfolio Analytics team. You will design and implement automated data solutions, develop business analytics, and collaborate across various functional areas. The ideal candidate will have experience with Azure Cloud Services, T-SQL, and strong stakeholders' communication skills, along with a great benefits package such as a competitive salary and opportunities for career advancement.

Benefits

Annual bonus

25 days paid holiday plus Bank Holidays

Private medical and dental cover

Qualifications

• Experience in data engineering within the insurance sector, ideally the London Market.
• Be organized with the ability to multi-task.
• Have demonstrable experience in influencing and engaging with stakeholders.

Responsibilities

• Develop business analytics solutions across all areas of the Wholesale division.
• Design and implement automated data solutions.
• Ensure data quality, integrity, and governance across all systems.

Skills

Experience with Azure Cloud Services

Knowledge of data warehousing methodology

Database development using T-SQL

Data pipelines with Python

Excel data manipulation and visualization

Excellent interpersonal skills

Tools

Power BI

Job description

Are you from a data and analytical background and looking to use your skills in as a Senior Data Engineer?

We are looking for someone to join our International Portfolio Analytics team here at Markel

What part will you play? If you’re looking for a place where you can make a meaningful difference, you’ve found it. The work we do at Markel gives people the confidence to move forward and seize opportunities, and you’ll find your fit amongst our global community of optimists and problem-solvers. We’re always pushing each other to go further because we believe that when we realize our potential, we can help others reach theirs.

Join us and play your part in something special!

The opportunity:

The International Portfolio Analytics (IPA) team sits across all International Divisions within the Markel International Wholesale business which operates across London and Asian platforms. It is embedded within the underwriting business and is represented within the Wholesale Leadership Team. Its focus is on the areas that are critical to achieve profitability and performance targets for a specialty lines insurer: Data, Analytics and Insights, Portfolio Management and Pricing Model development.

The IPA team provides support to the following Divisions within Markel Wholesale:

• Cyber writes many differing types of business and industry areas for cyber coverage.
• Energy provides coverage on a worldwide basis for all aspects of upstream, midstream and downstream oil and gas activities as well as renewable energy.
• Equine provides coverage for Bloodstock and Livestock risks worldwide.
• Marine provides coverage for liability, hull, war, terrorism, specie and cargo risks worldwide.
• Professional and Financial Risks (PFR) underwrites business worldwide and covers traditional and emerging professional indemnity, management liability, financial institutions as well as specialist risk areas such as patents and libel & slander.
• Trade Credit, Political Risk and Surety (TCPRS) underwrites a variety of trade and investment-related risks using expert knowledge of commercial counterparty and country risks across a wide variety of trade sectors and geographies.
• International Casualty provides coverage for Environmental Liability, General Liability, Life Science and Clinical Trials

The primary function of this position is to assist in providing valuable insights, solutions, services and operational improvements across MINT Wholesale through the use of data & insights. This will mainly include working to improve and augment underwriting and claims enabling data driven decision making. It will also include creating business MI for the various other support functions within MINT Wholesale.

Activities include data analysis, automation of data flows, creating tooling and visualisation solutions.

What you’ll be doing:

• Develop business analytics solutions across all areas of the Wholesale division, supporting the Data, Analytics and Insights pillar in International Portfolio Analytics.
• Design and implement automated data solutions. Be an advocate for the use of data to support data driven decision making.
• Develop data models to enable smarter underwriting and claims decisions that will augment existing processes.
• Strong understanding of insurance data models, including policy, claims, and risk-related data, with hands-on experience in Verisk Impact and Eclipse systems.
• Collaborate with IT teamsto integrate new systems and technologies into the data ecosystem.
• Maintain and work with data engineering team on cloud-based data platforms
• Source new data and create conformed views of data in the IPA Data Analytics Cloud Platform.
• Ensure data quality, integrity, and governance across all systems.
• Be willing to learn new technologies and become an SME to the IPA team and where necessary Wholesale.
• Represent the IPA team, as appropriate, providing accurate and timely management information to MINT leadership, wholesale leadership and meetings as the need arises.
• Proven experience in data engineering within theinsurance sector, ideally theLondon Market.
• Work with other functional areas to include but not limited to: actuarial, IT, finance, Office of the CUO , legal and regulatory, compliance, credit control, reinsurance, delegated and underwriting support services to resolve issues and support the achievement of IPA and wholesale business priorities.
• Desirable to have business intelligence knowledge in Power BI.

Our must-haves:

• Experience withAzure Cloud Services(e.g. Data Factory, Databricks, Key Vault, Az SQL).
• Knowledge ofdata warehousingmethodology(e.g., Kimball and Inmon).
• Database development: Be able to transform and summarise data in T-SQL. Knowledge of database maintenance and administration a plus.
• Data pipelines: Python a plus.
• Automation: Have a process improvement mindset. Have demonstrated implementing process automation.
• Excel: Possess a thorough working knowledge Excel and be comfortable with manipulating, analysing and visualising large, complex sets of data.
• Have demonstrable experience in influencing and engaging with stakeholders using effective communication and ensuring buy-in.
• Excellent interpersonal skills
• Organised with ability to multi-task
• Adaptable and comfortable with fast pace and shifting priorities

Who we are:

Markel Group (NYSE – MKL) a Fortune 500 company with over 60 offices in 20+ countries, is a holding company for insurance, reinsurance, specialist advisory, and investment operations around the world.

We’re all about people | We win together | We strive for better | We enjoy the everyday | We think further

What’s in it for you?

• A great starting salary plus annual bonus & strong benefits package…
• 25 days paid holiday plus Bank Holidays, with the opportunity to buy/sell extra leave
• Fantastic company pension scheme, private medical and dental cover, life assurance, travel insurance cover, income protection, season ticket loan as well as other great benefits on offer
• There are countless opportunities to learn new skills and develop in your career and we can provide the support needed to do just that!

Are you ready to play your part?

Choose ‘Apply Now’ to fill out our short application, so that we can find out more about you.

Markel celebrates the value of a diverse workforce that brings experience and expertise from a wide variety of backgrounds and life circumstances. Whatever your background, if you feel you meet the requirements of this role then we want to hear from you. We are also happy to consider candidates who are looking for flexible working patterns.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, colour, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status.

We will ensure that individuals with disabilities are provided with all reasonable accommodations to be able to participate in the job application or interview process and to perform essential job functions if successful. Please contact us via email at [e-mail] or call us at 0161 507 5827 to request any accommodations that may be needed. This includes any alternative formats of any documents or information on how to apply offline.

#LI-DJ1

#LI-Hybrid #PlayYourPartUK