Best Option

Find the right accountancy solution for your requirements

  • Location: London
  • Rate: Up to 550.00
  • Start Date: 14/08/2019
  • Duration: Contract

Detailed JD:

10+ years BI experience

4-5 years Exp in data stacks: Teradata, Hadoop, Cassandra

3-4 years’ experience in extensive Data Migration

SAS Data Integration Studio 4.2+

Understanding of SAS Architecture: SAS Platform Administration

Data Flux  & Data quality experience

Worked extensively SAS and Teradata, Oracle, Hyperion and Business Objects

SAS GUI tools (Data Integration, Enterprise Guide Management Console)

Good knowledge of reporting and analysis tools

Financial Services background

Roles and Responsibilities:

Creating tasks in DI such process flow jobs and tables for the business

Assist with the design of new HADOOP analytics and modelling solutions.

Responsible for ensuring environment standards and principles are adhered to throughout platform development and deployment life cycle

Strong experience working on Hadoop platforms and surrounding technologies

On the SQL platform, utilising the full suite of Microsoft Business Intelligence, and developing with SSIS, SSAS and SSRS.

Designing and Creation of SAS DI Studio jobs for ETL flow with optimisations for ELT when applicable

Porting of base SAS code used for analytics to a SAS DI studio job – for data integration purposes

Debugging and optimisations of existing jobs and custom transforms

Analysing data loads (problematic loads: duplicates, failed loads, etc)

Data profiling and data mining – matching the data stored with business requirements

Work with Loop transformations

Creating new transformations & examining impact analysis