My client a leading insurance business who is at the fore front of insuretech is recruiting a data lead to take a lead role within the Data Warehouse tower. The role will involve the support of all Data Analysis for the Data Warehouse and ETL solutions and support projects and small change within the suite of Data Warehouse applications and be the Lead within the team.
The role will be engaged in the investigation, evaluation, interpretation and classification of data, in order to define and clarify information structures which describe the relationships between real world entities. Such structures facilitate the development of software systems, links between systems or retrieval activities.
They will investigate corporate data requirements, and apply data analysis, data modelling and quality assurance techniques, to establish, modify or maintain data structures and their associated components (entity descriptions, relationship descriptions, attribute definitions). They will provide advice and guidance to database designers and others using the data structures and associated components.
There will be a level of Data Analysis support activity during the development, testing, release and warranty phases of any project and work packages. There will also be an element of support activities for user enquiries and other identified issues that arise within Data Warehouse and ETL environments as required.
The role will work closely with the Data warehouse Development and Support Managers to ensure that all data solutions are implemented with data quality in mind. The role will also interface directly with the Enterprise Data Architects and the CTO team
·Data specification based upon business specifications, user requirements and optimal presentation of data to reporting tools such as MicroStrategy.
·Data design of all aspects of Data Warehouse deliverables which will include input into the Business Glossary, ownership and delivery of source to target mappings, amendment and adherence to the Physical Data Model, Data Profiling and input into business rules.
Data Lead Job Description
Design will ensure data is modelled logically, consistently and intuitively, making certain that proposed solutions perform optimally within agreed tolerances.
Provide consultancy and development estimates with Key assumptions as part of evaluating work packages in support of projects relating to data deliverables and overall project or BAU deliverables
Liaise with business representatives, business expert users and BA, PM, Developers and Architects to ensure all requirements are within scope of the proposed solution, the Data
·Involvement in Project & BAU work as a Project Team Member where required.
·Production and maintenance of documentation including technical, procedural and administrative documents where required.
·Provide second line support as part of transitioning warehouse deliverables from projects to dedicated support team.
·Proficiency to an intermediate hands on level -SQL Server (T-SQL and SSIS), InfoSphere Data Architect, Microsoft Master Data Services, Excel.
30 days holiday increasing to one day each year.
Agile working environment and work from home scheme.
Working for a leading insure tech business forefront of new technologies.
Excellent benefits package and annual bonus.