Senior BI Data Engineer
BI Data Engineer Reporting to: Business Intelligence Manager
Location: London About us IQUW is a speciality (re)insurer at Lloyd's (Syndicate 1856) underwriting a diverse range of Property, Commercial and Speciality (re)insurance products from Cargo and Marine to Political Violence, Terror and War. We combine data, intelligent automation and human expertise to make smart decisions, fast. The role
- Support, improve and deliver high quality BI reporting and data transformation solutions as part of the Central BI Team using tools such as Azure Data Factory, Microsoft Fabric, Databricks and Power Bi.
- Actively participate within the central Data & BI Team to help develop other team members and support the delivery of the team objectives.
- Perform operation support activities to ensure the Central BI solution meets the business SLA's, including occasional OOH activities.
- Enhance existing Data Lakehouse with new Databricks pipelines to ingest new data sources.
- Build out data transformations to support new Facts and Dimensions within existing Data Lakehouse
- Conduct data analysis and then design and deliver the subsequent data extraction and database repository.
- Provide the agreed level of documentation and handover to enable the support and continued development of the BI/ data transformation solutions delivered.
- Liaise with business personnel to review, refine, and document business requirements.
- Work directly with the Actuarial, Underwriting, Claims, Finance and Central MI business representatives to identify and document business requirements.
- Provide technical support and guidance to the business teams to enable them to achieve their own reporting goals.
- Databricks
- Azure Data Factory
- Data Lakehouse Medallion architecture
- Microsoft Azure
- T-SQL Development (MS SQL Server 2005 onwards)
- Python, PySpark
- Azure DevOps
- MDS
- Kimball Dimensional Modelling Methodology
- Power Bi
- Unity Catalogue
- Microsoft Fabric
- Insurance sector (Lloyds Syndicate, Underwriting, Broking)
- Degree educated in relevant field or long-standing technical experience.
- Excellent communication skills - written and verbal, being able to liaise with staff at all levels around issues and opportunities.
- Can do attitude - self-starter, makes things happen. Ability and attitude to learn and develop.
- Excellent documentation skills and attention to detail.
- Proactive and self-motivated taking ownership of allocated task through to the delivery.
- A team player who can establish and maintain effective working relationships with colleagues at all levels.
- Strong customer focus with the ability to develop productive working relationships with a range of stakeholders.
- Strong time management skills.
- A full job description can be seen here.
Recommended Jobs
Business Development Manager - Pharma Solutions
Unilabs, a leading provider of Pharmaceutical and Diagnostic services, is seeking a highly motivated and experienced Business Development Manager (BDM) to join our team. The BDM will serve as the key...
Self Employed Personal Trainer - Monument - Self Employed
Self Employed Personal Trainer - Monument - London, United KingdomSelf Employed Personal Trainer - Build Your Business with The Gym Group! Are you a passionate and ambitious Level 3 qualified Pers...
Nursery Deputy Manager
Our client is dedicated to providing high-quality care and delivering incredible outcomes for the children in their care. All of the settings across our client sites are bespoke nurseries are design...
Freelance Designer
Freelance Designer | Harts Group | Soho, London We’re looking for a creative, detail-loving Freelance Designer to support our brilliant team across various design projects. You’ll help shape h...
Speculative Application
LIFE AT SATALIA As an organisation, we push the boundaries of data science, optimisation and artificial intelligence to solve the hardest problems in industry. Satalia is a community of individu...
Junior Administrator
We’re looking for an enthusiastic and detail-obsessed individual to join our Funding & Payments team as a Junior Funding Administrator. This is an entry-level position with no prior experience necess...
Field Sales Representatives
Hi there! Thanks for stopping by our job ad. This isn’t your typical door-to-door role. Our people’s success speaks for itself. ~100% of agents who hit target earnt average commission over £2.2k...