•••• is looking for an experienced BI Architect & Engineer to help establish a single source of truth for our underwriting performance reporting.
Sitting within our MI & Data Insights team, you’ll assess and redesign our existing BI ecosystem, creating a more streamlined, scalable and efficient reporting service. This is a hands-on role combining data engineering and BI architecture, with the opportunity to shape how data products and reporting solutions are designed and delivered across the business.
About the role
Working closely with our Data team, BI Developers and Quality Assurance & Controls Lead, you’ll take the lead on assessing and modernising our existing BI architecture, streamlining pipelines and creating a scalable model that’s fit for the future.
You’ll design the semantic layer within Databricks, reshape reporting and ETL processes, and enhance our tooling to improve both functionality and the user experience. You’ll also develop a governed sandbox model that gives colleagues greater freedom to undertake ad hoc analysis and self-service reporting, while ensuring the right controls are in place. Alongside this, you’ll support release management and deployment, helping us build a more efficient, reliable and scalable reporting environment.
About you
You’ll bring advanced expertise across both data engineering and BI architectural design, alongside the judgement to balance long-term technical ambition with practical delivery.
You’ll ideally have:
- Strong data-modelling expertise, including dimensional modelling and star and snowflake schemas.
- Experience architecting and delivering governed sandbox environments within visualisation tools.
- Demonstrable experience within the company or Lloyd’s insurance market.
- Experience within delegated business or an MGA, although this is preferred rather than essential.
- Strong SQL skills, alongside experience with languages such as DAX, M or Python.
- Experience with visualisation platforms such as Qlik, ThoughtSpot, Tableau or Power BI.
- Familiarity with medallion data architecture and Databricks or an equivalent data lake.
- Familiarity with Azure DevOps or GitHub.
- An understanding of underwriting performance KPIs and the calculations behind them.
- The ability to interpret complex data and identify anomalies.
About
•••• is a specialist insurance provider, pioneering emerging risk and market leader in cyber. Our global insurance platform uses cutting-edge technology and data science to deliver smarter, faster underwriting and protect customers from today's most critical business risk.Headquartered in London with offices in New York, Melbourne, Sydney, Austin, Madrid, Brussels and Brisbane, •••• has over 1200 staff and is trusted by more than 100,000 businesses across 90 countries.At ••••, insurance isn't just about underwriting. From data science to software development, and digital marketing design, we've got something for everyone. We're passionate about pushing boundaries, thinking differently and building the insurance company of the future.•••• is committed to the principles of equal opportunities and creating an environment in which all individuals are always treated with dignity and respect. We encourage a diverse corporate culture of openness and appreciation to create an environment in which your talent can be developed in the best possible way. Should you require any reasonable adjustments at any stage of the recruitment process please let us know.Feeling like you need to tick every box before applying? We see things differently. In a rapidly scaling company like ours, ambition and the drive to learn count for more than a 'perfect' checklist. We're building the future of insurance, and that requires diverse talent eager to grow with us. If this role excites you and you're ready to make a significant impact, bring your unique background and let's build something great together.