Data Engineer - Management Services

Miller; City Of London; On-site; GBP 50,000 - 70,000; Full time

Job summary

A leading specialist (re)insurance company in the UK is seeking a Data Engineer to join their Technology, Data and Innovation team. The role involves developing data architecture and integrating various data sources to enhance business value. Ideal candidates should have advanced TSQL skills and experience in data warehouse modelling, with an attractive benefits package including pension contributions, private medical insurance, and more.

Benefits

10% pension contribution, matched up to 5%

Private Medical Insurance

Medicare cash plan

Minimum of 25 days annual leave

Life Assurance

Income Protection

Critical Illness cover

Enhanced Maternity, Paternity Adoption and Shared Parental Leave

Qualifications

• Experience with data architecture and analytics solutions.
• Ability to deal with complex data transformations and modelling.

Responsibilities

• Develop architecture for data analytics and reporting.
• Integrate data from various sources to deliver business value.
• Assist in data platform optimization and construction.
• Comply with company policies and external regulations.

Skills

Advanced TSQL

Data warehouse modelling skills

Scripting languages (Python)

Azure Data Factory

Airflow

Snowflake (desirable)

Job description

As a leading specialist (re)insurance broking partnership, Miller is a recognised leader in our specialist fields. With offices in London, Ipswich, Bermuda, Brussels, Paris, Singapore and Switzerland, our network has increased to more than 1000 colleagues.

We always act with integrity, make principled decisions, and give clients clear, honest and unbiased advice. We are extremely proud that by acting with integrity and making principled decisions, we have earned a reputation for keeping our promises to clients, markets and each other.

The Opportunity

We have a new exciting opportunity for a Data Engineer to join our Technology, Data and Innovation team at Miller. Main responsibilities surround developing the LLP's use of technology, in particular the core components of an effective data analytics and reporting architecture capable of meeting a wide range of needs.

Role Responsibilities

• Develop the architecture, tools, procedures and methods employed in the operating environment in line with technical advances and business requirements.
• Assist in the design of the data warehouse, integrating data from various sources to deliver value to the business.
• Deal with complex data, source and target tables mappings, load process, transformation, reconciliation, error handling, physical and logical data modelling.
• Assist in the construction and optimisation of the data platform.
• Create solutions for data issues (Data quality, Data mapping, Metadata management, Migration and Reporting solutions).
• Ensure that developments are carried out in accordance with established Company IT procedures and standards. Participate in the establishment of development procedures and standards.
• Take responsibility for the support and maintenance of existing applications and systems as assigned.
• Participate in the process of selecting the solution most appropriate to the stated business requirements.
• Perform assigned responsibilities as delegated by more senior members of the department.
• Provide cover as required for other developers.
• Adhere to and meet fully the expectations of Miller, as set out in its policies and procedures, training material, and embedded in its systems and controls. Our policies and procedures are written to encapsulate the compliance, legal and financial crime related legislation and regulations which apply to Miller.
• Comply with any external rules and requirements imposed on individuals performing their role at Miller, such as Lloyd’s byelaws and FCA rules.
• Promote Miller brand and values to enhance Miller’s reputation in the market.

Knowledge

• Advanced TSQL.
• Data warehouse modelling skills.
• Scripting languages (Python).
• Azure Data Factory.
• Airflow.
• Snowflake (desirable).

Experience

• Insurance background – desirable.

Benefits

• 10% pension contribution from Miller. In addition, Miller will match any employee contributions up to 5%.
• Private Medical Insurance.
• Medicare cash plan.
• Minimum of 25 days annual leave (with flexibility to buy more).
• Life Assurance.
• Income Protection.
• Critical Illness cover.
• Enhanced Maternity, Paternity Adoption and Shared Parental Leave.