This role is to work within the Business Intelligence team at TMHCC to support the development of new reporting requirements. This includes working with the BI solutions architect to design and develop solutions. The role will involve some data modelling to enhance the warehouse and/or datamart design. The role may also involve working on BAU defect resolution or enhancements to the BI systems to provide more bandwidth within the BI team.
General Activities & Key Tasks:
SQL Server Development work using T-SQL and SQL Server Integration Services (SSIS)
Working with the BI Architect and BA’s to enhance the warehouse and / or datamart schema, including data modelling
Reporting services development work using SSRS and java Node.js wrapper
Analysis Services development work using MDX and TABULAR models
Requirements analysis and the translation of these requirements into business solutions
Working with business analysts or business representatives to ensure that the solution is correct, reconciled and signed-off.
Provide assistance with the resolution of user problems and queries
Data analysis, reconciliation and manipulation as required.
Report design and development
Essential Skills & Qualifications
Must have at least two years’ experience of using SQL Server for data manipulation and reporting
Proven experience in at least one of the following:
Development using SQL Server Reporting Services
Development using SQL Server Analysis Services
Proven experience in data modelling and dimensional modelling
London Market Insurance knowledge and experience – at least 1 year
Full project lifecycle experience from initial design and data modelling through development, testing and into production support.
Excellent analysis skills with the ability to convert business requirements into practical solutions.
Strong documentation skills including MS Visio.
Confident, friendly, self-motivated, solutions-driven personality
Good written and verbal communication skills.
Desirable Skills & Qualifications
Power BI experience
Experience of anchor modelling