Develops and supports business intelligence solutions, including data extraction, data warehouse ETL, dimensional modeling, cubes, reporting, data analysis, and SQL performance tuning. Maintains scheduled processes and BI environments, resolves service issues, supports business reporting needs, and collaborates with underwriting, claims, finance, and management information teams. The role also contributes to data quality, reporting capability, team development, and future BI strategy.
Overview
About us
ERS Syndicate 218 at Lloyds is managed by Starr. We are the UK’s largest specialist motor insurer with an A+ rating and have been making motoring passions and livelihoods possible since 1946. We work exclusively with motor insurance brokers to help get under the skin of the most difficult insurance risks, helping build products to meet their customer’s needs.
Role Purpose
- To support, improve and deliver high quality BI reporting solutions as part of the Central BI Team.
- Actively participate within the Central BI Team to help develop other team members and support the delivery of the team objectives.
- Perform operational support activities to ensure the Central BI solution meets the business SLA’s, including occasional OOH activities.
- Support the team lead in developing and managing future strategy decisions.
- Take ownership of key initiatives that enhance data quality, reporting capability and analytical maturity across the business.
Key responsibilities
Business Intelligence Team
- Contribute to daily support activities, ensuring scheduled processes are running correctly, consistently and any issues are raised for investigation and resolution in a timely manner.
- Conduct data analysis tasks, profiling work requests to scale effort and complexity, to feed into the team backlog for future development.
- Design and deliver data extraction processes from new and existing sources, to integrate into an established data warehouse.
- Maintain and enhance existing ETL processes, ensuring reliability, accuracy and performance, including fine tuning of stored procs, views, functions and queries as the underlying dataset grows.
- Contribute to the management and continuous improvement of BI technical environment to ensure expected service levels are met and known service issues are resolved.
- Participate in BI and business meetings and take ownership of relevant action points throughout the escalation process to achieve satisfactory results.
Wider BI Business Support
- Work directly with, but not limited to, the 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.
The above duties and responsibilities are not an exhaustive list, and you may be required to undertake other reasonable duties compatible with your experience and competencies. This description may be varied from time to time to reflect changing business requirements.
Essential qualifications, skills and experience
- T-SQL Development (MS SQL Server 2019 onwards)
- MS Integration Services (SSIS) including development of full DW ETL Solutions
- MS Analysis Services (SSAS) for complex cube reporting solutions
- MS Reporting Services (SSRS) including development of complex report
- Kimball Dimensional Modelling Methodology
Experience of the following would also be advantageous to support potential future strategies:
- Fabric
- Microsoft Azure
Experience of the following systems would also be advantageous:
- Team Foundation Server
- Azure Dev Ops
Experience of the following business areas would be advantageous:
- Insurance sector (Lloyds Syndicate, Underwriting, Broking)
Qualifications:
- Degree educated in relevant field or long-standing technical experience
Benefits
- Competitive Benchmarked Salary
- 25 days holiday
- Discretionary bonus scheme
- Employee assistance programme
- Annual holiday buy (up to 3 extra days)
- Salary sacrifice benefits
- Annual benefits reviews
- The option for professional qualifications and study support
Additional Information
- A full job description will be found here.
#ERSLI
Similar Jobs
Software • Consulting
Design, develop, and support scalable cloud-based data solutions across AWS and Azure. Build ETL/ELT pipelines, data integrations, migration processes, warehouses, data lakes, and lakehouses. Perform data profiling, quality assessments, validation, reconciliation, troubleshooting, and root-cause analysis. Create source-to-target mappings and technical documentation while supporting data governance, security, and compliance. Collaborate with technical and business stakeholders to deliver secure, high-quality data solutions.
Top Skills:
Amazon AthenaAmazon QuicksightAmazon RedshiftAmazon S3AWSAws GlueAws LambdaAws Step FunctionsAzure Data FactoryAzure Data Lake StorageAzure SqlAzure Synapse AnalyticsData IntegrationData LakesData MigrationData ModelingData ProfilingData Quality ManagementData ReconciliationData ValidationData WarehousingEltETLLakehouse ArchitectureAzureMicrosoft FabricMicrosoft Sql ServerMySQLOraclePostgresSQL
Analytics
Lead the design, deployment, and operation of scalable data pipelines and cloud infrastructure for Kpler’s marine insurance initiative. Build containerized AWS services using Python, Docker, Kubernetes, Airflow, and Terraform; manage PostgreSQL and Kafka/Flink streaming systems; establish observability standards; provide technical direction; collaborate cross-functionally; and mentor engineers.
Top Skills:
AirflowAWSCi/CdClaudeCopilotCursorDockerFlinkKafkaKubernetesPostgresPythonTerraform
Artificial Intelligence • Information Technology • Generative AI • Big Data Analytics
Design, build, deploy, and optimize scalable AI and machine learning systems using large datasets. Develop predictive models, recommendation systems, personalization engines, forecasting solutions, generative AI applications, and production ML pipelines. Collaborate with data, backend, and product teams to integrate models into applications, while monitoring performance, data quality, drift, reliability, and cost. Establish best practices for evaluation, experimentation, reproducibility, and deployment, and research emerging AI technologies.
Top Skills:
Ai AgentsAirflowSparkAPIsAWSCi/CdDatabricksDeep LearningDockerEmbeddingsGCPLarge Language ModelsAzureMlopsNumpyPandasPythonPyTorchRagRelational DatabasesScikit-LearnSQLTensorFlowTransformer ArchitecturesVector Databases
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.
