Skip to the content


Career Opportunity: BI / SQL Developer

BI /  SQL Developer -Data Warehouse, Insurance

Salary: £               £35,000 – £45,000 (according to experience)

Location:              Chelmsford, South East

Start Date:           ASAP

Permanent Full time

Sectors:                Information Technology

Closing Date:       TBA

BI Developer - SQL / ETL, Data Warehouse, Insurance

We’re looking for a talented BI SQL/ETL developer with experience in data warehouse development and a keen interest in insurance data analytics.

Based in Chelmsford, Insurance Data Solutions (IDS) specialises in delivering software solutions to the insurance sector empowering clients across all lines of business in making data driven decisions.  

You will join an experienced team and get fully involved in in the full lifecycle of BI projects;

  • technically defining client BI requirements,
  • data analysis and preparation ensuring data reliability,
  • developing data warehouse platforms, data marts, extracts, views,
  • delivering actionable insight with data visualisation tools (such as Power BI, QlikView or Tableau).

 This exciting position offers plenty of variety and is a great opportunity to progress your career within a growing company and in the fields on data analytics and insurance.

The Company

IDS has established itself over the last 13 years as a software company specialising in providing data services and solutions to the insurance sector. Our clients include brokers, insurers, MGA’s and insurance software providers. 

Our success is attributed our deep knowledge of insurance data, systems and processes and our abilities to efficiently solve the challenges our clients face with data. Our repertoire of services and solutions includes data migration, data archiving, bordereaux processing, sanctions checking and business intelligence.

The IDS Insurance Data Analytics solution gives our clients a single version of the truth and unified view of their data. It includes a data warehouse and a web platform where clients can manage data visualisation dashboards and reports tailored to their strategic, operational and financial decision-making requirements.

 Key Accountabilities of this position will include (but not limited to):

  • Support full lifecycle of data warehouse developments including analysis, design, testing and implementation.
  • Maintain and create tables, views, stored procedures and functions using SQL Server and reporting services.
  • Develop dimensional and relational data models that are accurate, efficient and robust.
  • Liaison with clients to technically translate BI requirements
  • Help turn those into first class reports and dashboards using Excel, PowerBI / Tableau / Qlikview and SSIS.
  • Optimise existing and write new SQL. scripts in the design and development of ETL to support the data migration team and support in testing and reconciliation to ensure that the data is to the required standard.
  • Trouble shoot and manage the satisfactory resolution of any issues assigned to you.
  • Use experience to mentor and train other team members and clients in BI technologies and methodologies.
  • Communicate regularly with the team and clients on progress.

 Experience and Skills:

  • Minimum 3 years’ experience in similar positions
  • Very Strong SQL skills including querying, building stored procedures, tables and views
  • Experience of data warehousing environments is essential
  • At least one scripting language (Python or R preferred)
  • Experience in any of the following business intelligence tools (i.e. Tableau, Qlik or PowerBi)
  • Experience of working with insurance data sets and data types
  • Degree educated (computer science or mathematics preferred).
  • Experience of the Microsoft tool set, SSIS, SSRS essential.



  • Self-starting attitude, passion for technology and keen to identify where there is something else that can be done to support the end client and act accordingly.
  • Ability to work in a fast-paced, constantly-changing environment while maintaining a strong eye for detail with good problem-solving skills
  • Strong communication and collaboration skills – as a team player and in gathering requirements from clients.
  • Professional, presentable, approachable and confident working with clients


Required Tech Skills:   BI / data warehouse developer, SQL server 2016, Cloud, SSRS, SSIS, MS Azure or AWS, (PowerBI. Tableau or Qlikview), MySQL, APIs, SQL for ETL, Business intelligence / data warehouse technologies.


Package and Rewards

An attractive package is on offer;

Basic salary ranging between £35,000-£50,000 depending on experience

Renumeration includes your basic salary plus bonuses based on your performance and company sales.  Through regular performance reviews we recognise and reward employees with;

  • bonuses for increased responsibility, commitment and workload
  • Plus, flexible working hours, extra holidays, TOIL and overtime

NEST company pension scheme 

Free Parking at Moulsham Mill, Chelmsford City Centre

Annual Holidays: 22 days plus bank holidays.

Training and qualifications package


Further information

Follow this link to our Insurance Data Solutions website:


How to Apply

Please Send your CV with Covering letter to:


Contact Details

Apply now or call for a confidential discussion about this opportunity.

Cheryl Flynn, Sales & Marketing Director Insurance Data Solutions

TEL: 01245 608253

All resumes, CV's and enquiries will be held in strict confidence.

About the author

Cheryl Flynn has been the Sales and Marketing Director of the company for the past eleven years.