Time since we first saw it
Day 158
Up longer than most. Similar jobs usually come down between day 5 and day 43.
From 16,018 similar postings that came down. Coming down is not always a hire.
Reads like an Analyst role: dashboards and reporting.
Employment type in the employer’s posting: FULL_TIMEFrom the employer’s posting
Design and deliver data extraction processes from new and existing sources into the data warehouse
Maintain and enhance ETL processes, tuning stored procs, views and queries
Monitor daily scheduled processes and raise issues for resolution
Profile and analyse data work requests to feed the team backlog
Gather and document requirements with underwriting, claims, finance and MI teams
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 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.
Work directly with, but not limited to, the Underwriting, Claims, Finance and Central MI business representatives to identify and document business requirements.
Degree educated in relevant field or long-standing technical experience
From the employer’s posting.
ERS Syndicate 218 at Lloyds is managed by Starr.
In the employer’s words · Read in context
Open 5 monthsWe first saw this posting 158 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Day 158
Up longer than most. Similar jobs usually come down between day 5 and day 43.
From 16,018 similar postings that came down. Coming down is not always a hire.
4 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Hiring recordAdd your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
Essential qualifications, skills and experience - T-SQL Development (MS SQL Server 2019 onwards) - MS Integration Services (SSIS) including development of full DW ETL Solutions
- 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:
- 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
- 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 Analysis Services (SSAS) for complex cube reporting solutions - MS Reporting Services (SSRS) including development of complex report - Kimball Dimensional Modelling Methodology
Complete your application on careers-starr.icims.com. The employer’s form will show what is required.
Already applied? Track this application
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
Key responsibilities
Business Intelligence Team
Wider BI Business Support
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
Experience of the following would also be advantageous to support potential future strategies:
Experience of the following systems would also be advantageous:
Experience of the following business areas would be advantageous:
Qualifications:
Benefits
Additional Information
#ERSLI
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.
Selected passages from the saved posting. Check the full description for conditions and exceptions.
No pay amount identified in the saved description.
London
Working pattern and location restrictions need checking in the full posting.
No clear work-authorization passage found. Eligibility is unconfirmed.