Apply Now! for this Job

ETL Data Warehouse Consultant required for Data Analytics Team

Job Mode :Permanent Job
Published On :2008-09-25
Last Application Date :0 days remaining (2008-12-25)
Category :Information Technology & Telecoms (Consultant)
Pay Rate :Maximum �£50,000 plus Bonus and benefits
Location :Central London (City)
City :London
Country :UK
Job Posted By:Parham Consulting
Jobs Publisher's Website: www.parhamconsulting.com

Job Description

THE COMPANY AND SITUATION:

One of the biggest names in the world of professional services requires those skilled in ETL Data Manipulation for their Data Analytics Team, within their Forensic Technology division. The role involves both the use of technical skills and client contact to produce analytics work, proofs of concept or data-oriented managed services to clients in a wide variety of industry sectors. This is where much of the early stages work takes place in fraud detection and other data-driven projects. These are new positions as the team has been very successful, is currently experiencing a large demand for its services and hence is required to expand rapidly.

THE ROLE:

This is a client-facing role, where you will be interacting with the client from the initial consultation right through to delivery of results. The crux of the role is the manipulation, analysis and modelling of complex data and transformations in order to deliver a Business Intelligence solution to support optimal decision-making. This will also include the querying, profiling, implementation and quality testing of data.

THE EXPERIENCE REQUIRED:

Absolutely essential for this role is experience in the following:

· Commercial consulting experience: You must have experience of working for a consultancy, software house or service provider consulting to external end-user clients.
· Experience of ETL (as in Extract, Transform and Load – ETL in the Data Warehousing context)
· Experience in data extraction, cleansing & manipulation
· Experience in data quality and management
· Experience of the full systems development lifecycle
· SQL Experience – the requirement is for experience in the manipulation of data in SQL and associated ETL products

Please note the above are essential: You require all of the above to be eligible for this role.

It will also enhance your chances if you possess experience in as many of the following as possible:

· SQL Stored Procedures in either Oracle or SQL Server
· ETL products (e.g. Informatica, Ascentia, SQL Server SSIS, Ab-Initio)
· Relational and/or dimensional data modelling/data warehousing
· Handling large data volumes including efficiency and scalability concepts
· Data linking/fuzzy matching techniques
· Strong statistical or numerate academic background

Desirable, but by no means essential, is experience in any of the following:

· OLAP
· ERP (SAP, Baan, PeopleSoft, JD Edwards, Oracle Applications)
· Business Objects
· Crystal Reports
· Microsoft Access
· Datactics
· Trillium
· Dataflux
· 3rd party data applications such as Experian, Axciom, CACI
· Previous experience in Forensic or Fraud-related work


THE OPPORTUNITY:

So why work here? Simple! This team aims to be the best in the market. How will they achieve that? By attracting and retaining the best people. How will they do that? By creating an environment for you where you can learn, progress, be fulfilled and even…. Have fun!

back to Top