Data Modeler

Opilio Recruitment
London (South)
From £45,000 to £55,000 per annum 12 Month Contract
14 Oct 2016
26 Oct 2016
One of the largest media organisations in the world is looking for an experienced Data Modeler to support their team. As the Data Modeler, you will be an integral member of the BI development team currently tasked with delivering a new DWH to support the reporting and analysis needs. As the Data Modeler you will have the opportunity to own, update and enhance the organisations DWH design, data model and architecture to meet the current and future reporting and analysis requirements. You shall act as the primary contact for both BI development teams and business BI champions to provide detailed understanding of the DWH solution, thus enabling the organisation to get the most value from its BI platform. The Data Modeler will work alongside project and BI programme teams ensuring solutions deliver to business requirements, and business process change is appropriately modeled and managed. This is a hands on role where developing ETL routines will be required in addition to DWH design activities. Role and Responsibilities As the Data Modeler your deliverables and activities would be: •Own, update and enhance the DWH design, data model (logical and physical) and architecture to meet BI programme needs •Translate and integrate reporting requirements into the data model by working closely with BI developers and Analysts •Produce DWH and ETL functional and technical specifications for development within BI Programme of work •Lead workshops to determine changes or updates required to the DWH with project leads. •Develop DWH and ETL routines during build and test cycles •Provide leadership and guidance on good practice DWH development and design •Develop DWH standards and governance processes and ensures development adheres to these •Peer review design and development of the BI team •Work with developers in the technical design of the BI solution •Support testing and defect resolution during project activities •Support training and change management activities during project activities •Develops documentation to support promotion of work between environments •Adhere to internal standards of documentation (be they departmental or project specific) •Work with Technology teams and other service providers to define and evaluate solution proposals for viability and appropriateness. •Production of documentation to support service transition •Support for solution delivery, providing project management support and quality assurance •Provide 3rd level support for incident and problem management General: •Give guidance of overall DWH and BI landscape and provide recommendations •Lead and drive continuous improvement of the DWH and BI platform •Keep abreast of current technology and trends that may be of use/benefit. Experience and Skills Personal Characteristics: •Customer oriented individual who is outcome focused •Excellent team player •Strong interpersonal and communication skills •Effective communicator across all business levels •High level of attention to detail and accuracy •Self-motivated and proactive with a ‘can do’ attitude •Highly analytical •Good negotiation skills The right Data Modeler will have the following Knowledge, Skills and Experience: •Minimum 5 years working as a DWH Data Modeller and ETL developer who has exposure in leading a group of BI developers •Strong data modelling skills in a large scale complex environment •Proven track record of leading design, build and support of DWH and data marts which are robust and scalable •Strong ETL and DWH developer, utilising Microsoft SSIS and SSAS development skills required •Solid experience utilising ER Studio to design data models •Exposure to SAP BW and Netezza would be highly regarded •Experience with SAP Business Objects and SAP ERP Modules beneficial •A range of technical project experience, ideally with experience of delivering BI solutions •Understanding and experience of project management methodologies and frameworks and change management processes •Knowledge of common methodologies for technical/software development projects such as Agile Scrum or Waterfall This job was originally posted as

More jobs like this