Senior Data Engineer
ERS
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
ERS Syndicate 218 at Lloyds is seeking a skilled BI Engineer to join the Central BI Team in Swansea. You will deliver high-quality BI reporting solutions, design and maintain ETL processes, and support data extraction from multiple sources into the data warehouse.
The role focuses on data quality, reporting capability, and analytical maturity, with responsibility for daily operations, backlog refinement, and collaboration with Underwriting, Claims, Finance, and Central MI.
Qualifications
- 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 reports.
- Kimball Dimensional Modelling Methodology.
Responsibilities
- Contribute to daily support activities, ensuring scheduled processes run correctly and issues are escalated promptly.
- Perform data analysis tasks, profiling work requests to scale effort and feed the team backlog.
- Design and deliver data extraction processes from new and existing sources, to integrate into a data warehouse.
- Maintain and enhance ETL processes, ensuring reliability, accuracy and performance.
- Support BI environment service levels and resolve known issues.
- Participate in BI meetings and own actions through escalation process.
Skills
Education
Tools
Job description
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.
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.
- 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.
- 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.
- 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.
- 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
- Fabric
- Microsoft Azure
- Team Foundation Server
- Azure Dev Ops
- Insurance sector (Lloyds Syndicate, Underwriting, Broking)
- Degree educated in relevant field or long-standing technical experience
- 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
- A full job description will be found here.
#ERSLI
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
