ETS Technical Sales
,
London, Greater London
BI / SQL Developer in Insurance
|
Salary: £40000.00 - £50000 per annum + Pension |
---|
Overview
BI / SQL Developer - Data Warehouse in Insurance London Up to £50k Permanent Full time Our client is looking for a talented BI SQL/ETL developer with experience in data warehouse development data migration and a strong background in insurance data analytics. This exciting position offers plenty of variety and is a great opportunity within a growing company 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 our abilities to efficiently solve the challenges our 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 5 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 Plus, flexible working hours, extra holidays Your Birthday off Annual Holidays: 22 days plus bank holidays . Training and qualifications package Company pension scheme Renumeration includes your basic salary plus bonuses based on your performance and company sales. This job was originally posted as www.totaljobs.com/job/89616350