Data Engineer - Management Services in City of London

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.