Senior Business Intelligence Developer

Grade: 3

Reporting to: Lead Business Intelligence Developer

Location: Swansea

About Us: IQUW is a speciality (re)insurer at Lloyd’s (Syndicate 1856) underwriting a diverse range of Property, Commercial and Speciality (re)insurance products from Cargo and Marine to Political Violence, Terror and War. We combine data, intelligent automation and human expertise to make smart decisions, fast.

Key Responsibilities

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

Preferred Skills and Experience

• 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
• PowerBI Report Development
• Kimball Dimensional Modelling Methodology

Additional Skills Advantageous

• Fabric
• Microsoft Azure
• Team Foundation Server
• Azure Dev Ops
• PowerBI Administration and/or support
• Insurance sector (Lloyds Syndicate, Underwriting, Broking)

Qualifications

• Degree educated in relevant field or long-standing technical experience

Key Personal Desirables

• Excellent communication skills – written and verbal, being able to liaise with staff at all levels around issues and opportunities.
• Can do attitude – self-starter, makes things happen.
• Ability and attitude to learn and develop.
• Excellent documentation skills and attention to detail.
• Proactive and self-motivated taking ownership of allocated task through to the delivery.
• A team player who can establish and maintain effective working relationships with colleagues at all levels.
• Confident, approachable, and collaborative, with strong customer focus with the ability to develop productive working relationships with a range of stakeholders.
• Strong time management skills.
• Curious and driven, committed to learning and developing themselves and others whilst staying motivated to help shape the future of data within the organization.