× Cookie Policy: We use cookies to help keep our site relevant and easy to use. To help us do this we need your permission to use cookies. EU legislation requires that all websites clearly specify if cookies are being used and their purpose. For more information on the cookies we use, please view our privacy policy. We use Google Analytics, which uses cookies to anonymously track activity on our site.

Data Modeler - London

Type: Fixed Term Contract Full-Time
Duration: 12 Months
Salary: £45,000 to £55,000 pa
Job Ref: JG2731
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


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

Skill Set
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

Apply below or to find out more information about the Data Modeler job, contact Jag Gill on jag.gill@opiliorecruitment.co.uk or call 0207 183 7145 quoting the reference JG2731.

Apply Back to Results

If this isn’t the right role for you, we are working on other Data Analyst Jobs so please call Jag on 0207 183 7145 to discuss.

Refer a friend; if we successfully place someone you have referred to us, we will give you £200 as a thank-you!!


Jag Gill

Jag Gill

Recruitment Consultant

Jag specialises in: PHP, Python, Node, Back End Development, HTML5, CSS3, Angular JS, React JS, Java Script, Front End Development

E: jag.gill@opiliorecruitment.co.uk
T: 0207 183 7145
M: 07794 548 877

Previously Viewed Jobs

Similar Jobs

One of the largest publishing organisations in the world is looking for an experienced Data Analyst to join their team based in London. The successful Data Analyst will take responsibility for data an... Read More


London Office

A: 48 Charlotte St, London, W1T 2NS
T: 020 7183 7145
E: london@opiliorecruitment.co.uk

Birmingham Office

A: The Barns, Whitestitch Lane, Meriden, CV7 7JE
T: 0121 285 0145
E: birmingham@opiliorecruitment.co.uk

Manchester Office

A: Peter House, Oxford St, Manchester, M1 5AN
T: 0161 850 3145
E: manchester@opiliorecruitment.co.uk


© Opilio Recruitment Ltd 2014 - Registered in England and Wales - 07372444