This position is no longer open for applications

BI / SQL Developer

BI / SQL Developer (J5751) Chelmsford, England

Salary: GBP25000 - GBP35000 per annum + Pension Bonus Free Parking

BI / SQL Developer – Data Warehouse in Insurance

Chelmsford

Up to £35k + Bonus

Our client is looking for a talented BI / SQL/ETL developer with experience in data warehouse development and a keen interest in insurance data analytics.

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

Established as a software company specialising in providing data services and solutions to the insurance sector, the company has clients that include brokers, insurers, MGA’s and insurance software providers. Their success is attributed their deep knowledge of insurance data, systems and processes and ability to efficiently solve the challenges their clients face with data.

 Key Accountabilities:

  • 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.

 

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

  • Flexible working hours, extra holidays - Your Birthday off.
  • Free Parking
  • Training and qualifications package
  • Annual Holidays: 22 days plus bank holidays.
  • Company pension scheme 

 

 

;